Archive

Posts Tagged ‘ASE’

Syncing the Replicated DB with Primary DB in warm standby setup!

November 7th, 2009 No comments
Following steps  we can use for syncing the replicated database  from the primary database in warm standby setup.
PDS – Primary Dataserver
PDB – Primary Database
RDS – Replicated Dataserver
RDB – Replicated Database in RDS
Step #1
Put database  PDB in dbo use only
Clean up all logins besides systems, ( terminate all user processes )
Step #2
Quiese the replication server.
isql -Usa -Ppasswd -SRS
1> admin quiesce_check
2> go
Replication Server RS is Quiesced
1>
Step #3
Stop the rep agent thread of Primary Database.
isql -Usa -Ppasswd -SPDS
use PDB
go
sp_stop_rep_agent PDB
go
Step #4
Suspend the connection to Primary database. Login into the Replication Server and issue the following command.
isql -Usa -Ppasswd -SRS
suspend connection to PDS.PDB
go
Step #5
Ignore the secondary transaction point in Primary Database.
isql -Usa -Ppasswd -SPDS
use PDB
go
dbcc settrunc(‘ltm’, ‘ignore’)
go
Step #6
Truncate the tran log and reset the locator value  to zero. Please only execute if the above step was successful.
isql -Usa -Ppasswd -SPDS
dump tran PDB with truncate_only
go
Issue this command in RSSD database.
rs_zeroltm PDS, PDB
go
Step #7
Dump the primary database.
isql -Usa -Ppasswd -SPDS
dump database PDB to ‘/dumpfs/PDB.dmp’
go
Step #8
Transfer the dump to RDS and load the RDB.
isql -Usa -Ppasswd -SRDS
load database RDB from ‘/sybase/RDS/dumpfs/PDB.dmp’
go
Step #9
Valid the secondary tran point  in PDS.
isql -Usa -Ppasswd -SPDS
use PDB
go
dbcc settrunc(‘ltm’, ‘valid’)
go
Step #10
Start the repagent for PDB in PDS.
isql -Usa -Ppasswd -SPDS
use PDB
go
sp_start_rep_agent PDB
go
Step #11
Resume the connection from the PDS.PDB in Replication Server.
isql -Usa -Ppasswd -SRS
resume connection to PDS.PDB
go
Step #12
Remove DBO use only from db.

Hello world!

October 31st, 2009 No comments

Same as all the languages , I am starting this blog with Hello World!

print “Hello world!

First of all the introduction with Sybase and its technologies which are heavily impacting  the information(data) across the globe.

About Sybase: Sybase is largest  enterprise software and service company execusively focused on managing and mobilizing the information . http://www.sybase.com/

About Adaptive Server Enterprise(ASE) : Adaptive Server Enterprise is the mission-critical data management system for taming the information explosion. http://www.sybase.com/products/databasemanagement/adaptiveserverenterprise

About Replication Server: Move and synchronize data across the distributed enterprise with Replication Server.  http://www.sybase.com/products/businesscontinuity/replicationserver

About Sybase IQ: Highly optimized business intelligence, analytics and data warehousing.  http://www.sybase.com/products/datawarehousing/sybaseiq

Besides that Sybase is supporting lot of technologies . To know more about. http://www.sybase.com/products