To dump and then load the database or transaction to a different database on a different Adaptive Server, use both the -S and -D options with the load command. Make sure that you:
Configure the TSM server and TSM client to enable the load command for different source and target machines. See “Configuring TSM to allow different source and target machines”.
Start Backup Server using the same login on both the source and target machines.
Use the -S and -D options with the load database or load transaction command, where -S specifies the source server and -D specifies the source database.
load database database_name from "syb_tsm:: -S server_name -D database_name::object_name"
For example, to load the backup object “obj1.3” to “anotherdb” where the source server is “myserver” and the database is “testdb,” enter:
load database anotherdb from "syb_tsm::-S myserver -D testdb::obj1.3"
