TSAMP Cheat Sheet for DBA managing DB2 clustering

Once the Tivoli Storage Automation for Multiplatforms(SA MP) and the shared disk approach with DB2 is set and configured, the DBA needs to manage the cluster. There are hundreds of TSAMP and RSCT commands, but these ones will give you a quick start . Determine TSAMP version # samversion #lssamctrl View cluster status # Lssam Monitor cluster continuously #lssam -top List SAMP control parameters #lssamctrl Check domain status # Lsrpdomain Check node status #Lsrpnode List all defined relationships # lsrel –Ab List active tiebreaker lsrsrc -Ab -c IBM.PeerNode Disable high availability clustering # db2haicu -disable Enable high availability clustering #... Read more →

Extract DB2 create database ddl using db2look and -createdb switch

Question: How can I extract the ddl for CREATE DATABASE ? It seems like you can extract the full range of database object DDLs, but I can’t extract the database ddl Answer: You can extract the CREATE DATABASE ddl. The minimum requirement is to have DB2 10.1.4 or DB2 10.5 installed You’re probably familiar with the dblook utility, used for extracting database object DDLs. The DDLs are used to duplicate the objects into a fresh database , source control or to Compare DDL of 2 databases in DB2 A new parameter was added called –createdb. An example of using the... Read more →