useful DB2 commands which needs to run to administer the DB2 Database for SAP workloads.<\/p>\n
#To start DB2
\ndb2start<\/p>\n
#To connect to particular database #To check DB configuration\/parameters #To update DB configuration\/parameters This is an example, you can update any parameter as per your requirement. LOGARCHMETH1 is parameter which need to update to keep the archive logs, This parameter is visible by check DB configuration command & after updating any parameter, DB restart requires & sometimes offline DB backup requires before starting up the DB.<\/p>\n #Backup DB2 Database #Restore DB2 Database The above command will restore the DB on \/db2\/TST\/sapdata1 folder. Make sure to check the DB parameters once restore completed as it always point to old configuration. After restore many times DB can’t start & throw roll forwarding error, in this case you need to complete the roll forwarding with below command – <\/p>\n #To end the roll forward status #To deactivate DB before shutting down #To shut down DB normally #To shut down db forcefully as application connections were still exists #To check all schema in DB2 DB #To list all the tables for all DB’s #To list all the tables in respective DB #To manually generate the archive logs #Unlock DDIC or any other user in DB2 #Check HA\/DR status in DB2 DB2 HA\/DR Cluster Stop \/ Start<\/strong><\/p>\n SAP application should be shut down before stopping the DB2 cluster.<\/p>\n Azure SUSE Linux host running on SBD cluster – Cluster should be set on maintenance mode ————————————————– Login to Primary DB host & verify the crm_status<\/p>\n #Stop the HADR Login to Secondary DB host and run below commands<\/p>\n #Stop the HADR #Start the HADR on Standby\/Secondary host first #Start the HADR on Primary host #Verify the HADR status on both hosts I will update the list with more commands very soon…. <\/p>\n","protected":false},"excerpt":{"rendered":" useful DB2 commands which needs to run to administer the DB2 Database for SAP workloads. #To start DB2 db2start #To connect to particular database db2 connect to dbname #To check DB configuration\/parameters db2 get db cfg for dbname #To update DB configuration\/parameters db2 update db cfg for dbname using LOGARCHMETH1 DISK:\/db2\/TST\/archivelog This is an example, […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[8],"tags":[616,692,688,697,698,696,689,690,695,691,693,694],"class_list":["post-779","post","type-post","status-publish","format-standard","hentry","category-sap-updates","tag-db2","tag-db2-backup","tag-db2-comamnds","tag-db2-hadr","tag-db2-rollforward","tag-db2pd","tag-db2start","tag-db2stop","tag-db2stop-force","tag-db2vend","tag-logarchmeth1","tag-logprimary"],"_links":{"self":[{"href":"https:\/\/adilfahim.com\/myblog\/wp-json\/wp\/v2\/posts\/779","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/adilfahim.com\/myblog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/adilfahim.com\/myblog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/adilfahim.com\/myblog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/adilfahim.com\/myblog\/wp-json\/wp\/v2\/comments?post=779"}],"version-history":[{"count":4,"href":"https:\/\/adilfahim.com\/myblog\/wp-json\/wp\/v2\/posts\/779\/revisions"}],"predecessor-version":[{"id":781,"href":"https:\/\/adilfahim.com\/myblog\/wp-json\/wp\/v2\/posts\/779\/revisions\/781"}],"wp:attachment":[{"href":"https:\/\/adilfahim.com\/myblog\/wp-json\/wp\/v2\/media?parent=779"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/adilfahim.com\/myblog\/wp-json\/wp\/v2\/categories?post=779"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/adilfahim.com\/myblog\/wp-json\/wp\/v2\/tags?post=779"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
\ndb2 connect to dbname<\/em><\/p>\n
\ndb2 get db cfg for dbname<\/em><\/p>\n
\ndb2 update db cfg for dbname<\/em> using LOGARCHMETH1 DISK:\/db2\/TST\/archivelog<\/p>\n
\ndb2 backup database dbname<\/em> to \/location<\/em><\/p>\n
\ndb2 restore db dbname<\/em> from \/location<\/em> on \/db2\/TST\/sapdata1<\/p>\n
\ndb2 rollforward db TST to end of logs & complete<\/p>\n
\ndb2 deactivate db dbname<\/em><\/p>\n
\ndb2stop<\/p>\n
\ndb2stop force<\/p>\n
\ndb2 select schemaname from syscat.schemata<\/p>\n
\ndb2 list tables for all<\/p>\n
\ndb2 list tables for schema dbname<\/em><\/p>\n
\ndb2 archive log for database dbname<\/em><\/p>\n
\ndb2 “update SAPSID.USR02 set UFLAG=0 where BNAME=’DDIC’ and MANDT=’000′<\/p>\n
\ndb2pd -d dbname<\/em> -hadr | grep -i hadr<\/p>\n
\n(This is a mandatory step otherwise Virtual Name will switch to other host if DB get down in Primary mode. By setting up maintenance mode, it stick on the same node until maintenance mode OFF)<\/p>\n
\nShut down sequence – Primary DB & then Secondary DB
\nStartup sequence – Secondary DB & then Primary DB
\n————————————————–<\/p>\n
\ndb2 stop hadr on db dbname<\/em>
\ndb2 deactivate db dbname<\/em>
\ndb2stop<\/p>\n
\ndb2 stop hadr on db dbname<\/em>
\ndb2 deactivate db dbname<\/em>
\ndb2stop
\n———————————————–<\/p>\n
\ndb2start
\ndb2start hadr on db dbname<\/em> as standby<\/p>\n
\ndb2start
\ndb2start hadr on db dbname<\/em> as primary
\n————————————————<\/p>\n
\ndb2pd -d dbname<\/em> -hadr | grep -i hadr<\/p>\n