This tips is using DB2 LUW in Windows as an example. The same idea can be applied in Linux as well.
people just use the 'db2admin start' to start the DB2 Administration
Server. However, when you have change the password for your db2admin
owner password in WINDOWS, you will find that you are unable to start
the Administration Server using only 'db2amin start' .
You can have a look at the example below:-
a) DAS user is Dylan
Password change to password2
b) Run the following command
db2admin setid Dylan password2
Now you can start your db2admin again using the 'db2admin start' command.
Websphere Replication Server is also know as Infosphere Replication Server
db2admin stop must be run if you wish to drop toolsdb
You must rollforward command to later timestamp of your online backup if you are loading from an online backup.
you are going to export LOB file make sure you use the 'lobsinfile'
parameter. Or else you will only be able to see 1 LOB file in your
output if you are supposed to have several LOB files.
You have to be extra careful of this especially if you are using the Control Center and run the export.
Make sure you have selected the box 'Place each large object (LOB) in a separate file' in the EXPORT windows under the Column tab.
You can always do a check on this, by clicking the 'Show Command' in the EXPORT windows before running the EXPORT.
In conclusion always make sure you use the 'lobsinfile' parameter when you are exporting a LOB file.
Dylan Cheong Ngee Shinn
*This is imported from developerWorks blogger. Originally written on Mar 25, 2011