Re: *EXTERNAL* Re: tsm/db2 won't start after boot drive crash/recovery
We only have one instance per AIX lpar. The instance/user name is "tsmuser" (real creative). I did have to add user "tsmuser" with group "tsmgroup" to AIX with the right values, since those were lost. Rick -Original Message- From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Paul van Dongen Sent: Wednesday, September 14, 2016 9:58 AM To: ADSM-L@VM.MARIST.EDU Subject: Re: *EXTERNAL* Re: tsm/db2 won't start after boot drive crash/recovery tsmdb1 is the database name; the instance name should be the username under which the TSM server instance runs. When there are multiple TSM server instances on the same AIX box, all databases are named "tsmdb1", each under his own DB2 instance. Met vriendelijke groet / With kind regards, Paul van Dongen System Expert Vancis BV Science Park 408 1098 XH Amsterdam W: www.vancis.nl -Original Message- From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of David Ehresman Sent: 14 September 2016 15:25 To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] *EXTERNAL* Re: tsm/db2 won't start after boot drive crash/recovery Which leads me to ask. Where (on AIX) does the tsmdb1 instance reside? David -Original Message- From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Rhodes, Richard L. Sent: Wednesday, September 14, 2016 9:00 AM To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] *EXTERNAL* Re: tsm/db2 won't start after boot drive crash/recovery Thanks! I added the lines to /etc/services, and tried db2start, and db2 came up. When I run db2iupdt I get: rssymapi2p:/home/root==>/opt/tivoli/tsm/db2/instance/db2iupdt tsmdb1 DBI1446I The db2iupdt command is running. DB2 installation is being initialized. The specified instance "tsmdb1" does not exist. Specify an existing instance name. Thanks! Rick -Original Message- From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Paul van Dongen Sent: Wednesday, September 14, 2016 8:30 AM To: ADSM-L@VM.MARIST.EDU Subject: Re: *EXTERNAL* Re: tsm/db2 won't start after boot drive crash/recovery Richard, I have recently moved several TSM servers between AIX systems (without restoring the DBs). Some points of attention: On a system without TSM, you must first install TSM software. You will also need some tweaking of the DB registry. 1. correct hostname in /sqllib/db2nodes.cfg 2. /etc/services must contain: DB2_ 60016/tcp DB2__160017/tcp DB2__260018/tcp DB2__END 60019/tcp Ports can vary, but must be in sequence 3. Instance "update": /opt/tivoli/tsm/db2/instance/db2iupdt 4. As instance owner: ~/sqllib/adm/db2set -g DB2SYSTEM= 5. dsm.sys for DBbackups has to be present (location depends on the TSM server version) If you need more details please PM me. Met vriendelijke groet / With kind regards, Paul van Dongen System Expert Vancis BV Science Park 408 1098 XH Amsterdam W: www.vancis.nl T: 020 560 6600 M: 06 4181 4446 E: paul.vandon...@vancis.nl -Original Message- From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Rhodes, Richard L. Sent: 14 September 2016 13:48 To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] *EXTERNAL* Re: tsm/db2 won't start after boot drive crash/recovery No, DB2 won't start at all. rssymapi2p:/tsmdata/tsmoc/config==>db2start SQL6031N Error in the db2nodes.cfg file at line number "0". Reason code "11". I'm not sure how to state this, but I think there is some configuration in DB2 (that would be in on the boot drive) that points to the TSM database TSMDB1. I think that configuration is missing. For example, I found out about this cmd fighting a db2 problem some time ago. Run on a working TSM system: ./db2ilist tsmuser (our db2 owner) Run on this recovered system: ./db2ilist(no output) Rick -Original Message- From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Lee, Gary Sent: Tuesday, September 13, 2016 3:42 PM To: ADSM-L@VM.MARIST.EDU Subject: *EXTERNAL* Re: tsm/db2 won't start after boot drive crash/recovery Was db2 running for sure? In previous installs I had to modify the startup script to do a db2start then sleep for 10 secs to get tsm to start correctly fron reboot of the system. This was under redhat linux 6. That was the message I would get. -Original Message- From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Rhodes, Richard L. Sent: Tuesday, September 13, 2016 3:29 PM To: ADSM-L@VM.MARIST.EDU Subject: [ADSM-L] tsm/db2 won't start after boot drive crash/recovery Hello, We have a TSM v7.1.4 instance called TSMOC. Its sole purpose in life is to run Operations Center. It runs on an AIX lpar that's used for some other things. Last Friday the AIX rootvg was lost during a live migration to a new storage
Re: *EXTERNAL* Re: tsm/db2 won't start after boot drive crash/recovery
tsmdb1 is the database name; the instance name should be the username under which the TSM server instance runs. When there are multiple TSM server instances on the same AIX box, all databases are named "tsmdb1", each under his own DB2 instance. Met vriendelijke groet / With kind regards, Paul van Dongen System Expert Vancis BV Science Park 408 1098 XH Amsterdam W: www.vancis.nl -Original Message- From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of David Ehresman Sent: 14 September 2016 15:25 To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] *EXTERNAL* Re: tsm/db2 won't start after boot drive crash/recovery Which leads me to ask. Where (on AIX) does the tsmdb1 instance reside? David -Original Message- From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Rhodes, Richard L. Sent: Wednesday, September 14, 2016 9:00 AM To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] *EXTERNAL* Re: tsm/db2 won't start after boot drive crash/recovery Thanks! I added the lines to /etc/services, and tried db2start, and db2 came up. When I run db2iupdt I get: rssymapi2p:/home/root==>/opt/tivoli/tsm/db2/instance/db2iupdt tsmdb1 DBI1446I The db2iupdt command is running. DB2 installation is being initialized. The specified instance "tsmdb1" does not exist. Specify an existing instance name. Thanks! Rick -Original Message- From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Paul van Dongen Sent: Wednesday, September 14, 2016 8:30 AM To: ADSM-L@VM.MARIST.EDU Subject: Re: *EXTERNAL* Re: tsm/db2 won't start after boot drive crash/recovery Richard, I have recently moved several TSM servers between AIX systems (without restoring the DBs). Some points of attention: On a system without TSM, you must first install TSM software. You will also need some tweaking of the DB registry. 1. correct hostname in /sqllib/db2nodes.cfg 2. /etc/services must contain: DB2_ 60016/tcp DB2__160017/tcp DB2__260018/tcp DB2__END 60019/tcp Ports can vary, but must be in sequence 3. Instance "update": /opt/tivoli/tsm/db2/instance/db2iupdt 4. As instance owner: ~/sqllib/adm/db2set -g DB2SYSTEM= 5. dsm.sys for DBbackups has to be present (location depends on the TSM server version) If you need more details please PM me. Met vriendelijke groet / With kind regards, Paul van Dongen System Expert Vancis BV Science Park 408 1098 XH Amsterdam W: www.vancis.nl T: 020 560 6600 M: 06 4181 4446 E: paul.vandon...@vancis.nl -Original Message- From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Rhodes, Richard L. Sent: 14 September 2016 13:48 To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] *EXTERNAL* Re: tsm/db2 won't start after boot drive crash/recovery No, DB2 won't start at all. rssymapi2p:/tsmdata/tsmoc/config==>db2start SQL6031N Error in the db2nodes.cfg file at line number "0". Reason code "11". I'm not sure how to state this, but I think there is some configuration in DB2 (that would be in on the boot drive) that points to the TSM database TSMDB1. I think that configuration is missing. For example, I found out about this cmd fighting a db2 problem some time ago. Run on a working TSM system: ./db2ilist tsmuser (our db2 owner) Run on this recovered system: ./db2ilist(no output) Rick -Original Message- From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Lee, Gary Sent: Tuesday, September 13, 2016 3:42 PM To: ADSM-L@VM.MARIST.EDU Subject: *EXTERNAL* Re: tsm/db2 won't start after boot drive crash/recovery Was db2 running for sure? In previous installs I had to modify the startup script to do a db2start then sleep for 10 secs to get tsm to start correctly fron reboot of the system. This was under redhat linux 6. That was the message I would get. -Original Message- From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Rhodes, Richard L. Sent: Tuesday, September 13, 2016 3:29 PM To: ADSM-L@VM.MARIST.EDU Subject: [ADSM-L] tsm/db2 won't start after boot drive crash/recovery Hello, We have a TSM v7.1.4 instance called TSMOC. Its sole purpose in life is to run Operations Center. It runs on an AIX lpar that's used for some other things. Last Friday the AIX rootvg was lost during a live migration to a new storage system. We decided to recover by installing a mksysb from a partner lpar which had the same AIX version and application version, but NOT TSM. So the lpar got back up and running quickly - only took an hour, but it's missing the TSM install. All the TSM instance files (dsmserv.opt, etc) and DB2 filesystems (data, logs, sqllib, etc) exist with all their data. They weren't lost since they were on a different lun and volume group. We installed TSM v7.1.4 and I then created the AIX db2 instance own
Re: *EXTERNAL* Re: tsm/db2 won't start after boot drive crash/recovery
Our TSM instance resides on a separate lun from AIX. We try not to add filesystems to rootvg, for the most part. I keep all our TSM and db2 setup in a filesystem tree called /tsmdata. Here is what it looks like for this system: /dev/tsmdata0.06 0.061%6 1% /tsmdata /dev/tsmscripts 0.34 0.23 34% 1499 3% /tsmdata/tsm_scripts /dev/tsmoc 10.16 10.012% 759 1% /tsmdata/tsmoc /dev/db2activelog1 9.59 1.59 84% 23 1% /tsmdata/tsmoc/db2activelog1 /dev/db2activelog2 9.59 1.59 84% 23 1% /tsmdata/tsmoc/db2activelog2 /dev/db2archivelog 38.22 33.84 12% 18 1% /tsmdata/tsmoc/db2archivelog /dev/db2data1 4.00 1.95 52% 104 1% /tsmdata/tsmoc/db2data1 /dev/db2data2 4.00 1.95 52% 104 1% /tsmdata/tsmoc/db2data2 /dev/tsmocinstall 12.50 8.74 31% 3146 1% /tsmdata/tsmoc/install The TSM config (dsmserv.opt and other stuff) is in /tsmdata/tsmoc/config. The DB2 home dir sqllib is at /tsmdata/tsmoc/config/sqllib. All these filesystems are on a separate lun in a separate vg on separate lun. rsp:/tsmdata/tsmoc/config==>lsvg rootvg vgtsmoc rsp:/tsmdata/tsmoc/config==>lsvg -l rootvg rootvg: LV NAME TYPE LPs PPs PVs LV STATE MOUNT POINT hd5 boot 1 1 1closed/syncd N/A hd6 paging 64 64 1open/syncdN/A hd8 jfs2log1 1 1open/syncdN/A hd4 jfs2 1 1 1open/syncd/ hd2 jfs2 22 22 1open/syncd/usr hd9var jfs2 6 6 1open/syncd/var hd3 jfs2 12 12 1open/syncd/tmp hd1 jfs2 1 1 1open/syncd/home hd10opt jfs2 39 39 1open/syncd/opt lg_dumplv sysdump6 6 1open/syncdN/A scripts jfs2 1 1 1open/syncd/scripts usremc jfs2 8 8 1open/syncd/usr/emc rsp:/tsmdata/tsmoc/config==>lsvg -l vgtsmoc vgtsmoc: LV NAME TYPE LPs PPs PVs LV STATE MOUNT POINT tsmdata jfs2 2 2 1open/syncd/tsmdata tsmscripts jfs2 11 11 1open/syncd /tsmdata/tsm_scripts tsmoc jfs2 325 325 1open/syncd /tsmdata/tsmoc db2activelog1 jfs2 307 307 2open/syncd /tsmdata/tsmoc/db2activelog1 db2activelog2 jfs2 307 307 2open/syncd /tsmdata/tsmoc/db2activelog2 db2archivelog jfs2 122312232open/syncd /tsmdata/tsmoc/db2archivelog db2data1jfs2 128 128 1open/syncd /tsmdata/tsmoc/db2data1 db2data2jfs2 128 128 1open/syncd /tsmdata/tsmoc/db2data2 tsmocinstalljfs2 400 400 2open/syncd /tsmdata/tsmoc/install loglv00 jfs2log1 1 1open/syncdN/A When we lost the rootvg disk, all the TSM/DB2 config was just fine. Interestingly, this was a good exercise. Shortly, we are moving all our TSM instances to a new chassis - all new lpars with AIX7. I can swing the luns with the TSM/DB2 filesystems to the new lpar, but I will have an entirely new rootvg that doesn't have TSM/DB2 installed. What we just did to recover tsmoc is exactly what we will need to do on the new lpars. We just got there a different way! Now, we just have to install OC . . . . (not that we actually use it for much). Thanks! Rick -Original Message- From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of David Ehresman Sent: Wednesday, September 14, 2016 9:25 AM To: ADSM-L@VM.MARIST.EDU Subject: Re: *EXTERNAL* Re: tsm/db2 won't start after boot drive crash/recovery Which leads me to ask. Where (on AIX) does the tsmdb1 instance reside? David -Original Message- From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Rhodes, Richard L. Sent: Wednesday, September 14, 2016 9:00 AM To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] *EXTERNAL* Re: tsm/db2 won't start after boot drive crash/recovery Thanks! I added the lines to /etc/services, and tried db2start, and db2 came up. When I run db2iupdt I get: rssymapi2p:/home/root==>/opt/tivoli/tsm/db2/instance/db2iupdt tsmdb1 DBI1446I The db2iupdt command is running. DB2 installation is being initialized. The specified instance "tsmdb1" does not exist. Specify an existing instance name. Thanks! Rick -Original Message- From: ADSM: Dist Stor
Re: *EXTERNAL* Re: tsm/db2 won't start after boot drive crash/recovery
Which leads me to ask. Where (on AIX) does the tsmdb1 instance reside? David -Original Message- From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Rhodes, Richard L. Sent: Wednesday, September 14, 2016 9:00 AM To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] *EXTERNAL* Re: tsm/db2 won't start after boot drive crash/recovery Thanks! I added the lines to /etc/services, and tried db2start, and db2 came up. When I run db2iupdt I get: rssymapi2p:/home/root==>/opt/tivoli/tsm/db2/instance/db2iupdt tsmdb1 DBI1446I The db2iupdt command is running. DB2 installation is being initialized. The specified instance "tsmdb1" does not exist. Specify an existing instance name. Thanks! Rick -Original Message- From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Paul van Dongen Sent: Wednesday, September 14, 2016 8:30 AM To: ADSM-L@VM.MARIST.EDU Subject: Re: *EXTERNAL* Re: tsm/db2 won't start after boot drive crash/recovery Richard, I have recently moved several TSM servers between AIX systems (without restoring the DBs). Some points of attention: On a system without TSM, you must first install TSM software. You will also need some tweaking of the DB registry. 1. correct hostname in /sqllib/db2nodes.cfg 2. /etc/services must contain: DB2_ 60016/tcp DB2__160017/tcp DB2__260018/tcp DB2__END 60019/tcp Ports can vary, but must be in sequence 3. Instance "update": /opt/tivoli/tsm/db2/instance/db2iupdt 4. As instance owner: ~/sqllib/adm/db2set -g DB2SYSTEM= 5. dsm.sys for DBbackups has to be present (location depends on the TSM server version) If you need more details please PM me. Met vriendelijke groet / With kind regards, Paul van Dongen System Expert Vancis BV Science Park 408 1098 XH Amsterdam W: www.vancis.nl T: 020 560 6600 M: 06 4181 4446 E: paul.vandon...@vancis.nl -Original Message- From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Rhodes, Richard L. Sent: 14 September 2016 13:48 To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] *EXTERNAL* Re: tsm/db2 won't start after boot drive crash/recovery No, DB2 won't start at all. rssymapi2p:/tsmdata/tsmoc/config==>db2start SQL6031N Error in the db2nodes.cfg file at line number "0". Reason code "11". I'm not sure how to state this, but I think there is some configuration in DB2 (that would be in on the boot drive) that points to the TSM database TSMDB1. I think that configuration is missing. For example, I found out about this cmd fighting a db2 problem some time ago. Run on a working TSM system: ./db2ilist tsmuser (our db2 owner) Run on this recovered system: ./db2ilist(no output) Rick -Original Message- From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Lee, Gary Sent: Tuesday, September 13, 2016 3:42 PM To: ADSM-L@VM.MARIST.EDU Subject: *EXTERNAL* Re: tsm/db2 won't start after boot drive crash/recovery Was db2 running for sure? In previous installs I had to modify the startup script to do a db2start then sleep for 10 secs to get tsm to start correctly fron reboot of the system. This was under redhat linux 6. That was the message I would get. -Original Message- From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Rhodes, Richard L. Sent: Tuesday, September 13, 2016 3:29 PM To: ADSM-L@VM.MARIST.EDU Subject: [ADSM-L] tsm/db2 won't start after boot drive crash/recovery Hello, We have a TSM v7.1.4 instance called TSMOC. Its sole purpose in life is to run Operations Center. It runs on an AIX lpar that's used for some other things. Last Friday the AIX rootvg was lost during a live migration to a new storage system. We decided to recover by installing a mksysb from a partner lpar which had the same AIX version and application version, but NOT TSM. So the lpar got back up and running quickly - only took an hour, but it's missing the TSM install. All the TSM instance files (dsmserv.opt, etc) and DB2 filesystems (data, logs, sqllib, etc) exist with all their data. They weren't lost since they were on a different lun and volume group. We installed TSM v7.1.4 and I then created the AIX db2 instance owner and group. We then tried to start TSM. We got msgs below. ANR7801I Subsystem process ID is 16056324. ANR0900I Processing options file /tsmdata/tsmoc/config/dsmserv.opt. ANR7811I Using instance directory /tsmdata/tsmoc/config. ANR4726I The ICC support module has been loaded. ANR0990I Server restart-recovery in progress. ANR0172I rdbinst.c(3942): Error encountered performing action UPDATE DBM CFG. ANR0162W Supplemental database diagnostic information: -6031:**No State Information Available (-2)**:-6031 (SQL6031N Error in the db2nodes.cfg file at line number "0". Reason code "11". ). ANR0171I dbiconn.c(1844): Error detected o
Re: *EXTERNAL* Re: tsm/db2 won't start after boot drive crash/recovery
n 9 started for server TSM8 (AIX) (Tcp/Ip) for remote monitoring. ANR1990I Remote monitoring started for server TSM8. ANR0408I Session 10 started for server TSM4 (AIX) (Tcp/Ip) for remote monitoring. ANR1990I Remote monitoring started for server TSM4. ANR0408I Session 11 started for server TSM7 (AIX) (Tcp/Ip) for remote monitoring. ANR1990I Remote monitoring started for server TSM7. ANR0408I Session 12 started for server TSM6 (AIX) (Tcp/Ip) for remote monitoring. ANR1990I Remote monitoring started for server TSM6. ANR0408I Session 13 started for server TSMAPP (AIX) (Tcp/Ip) for remote monitoring. ANR1990I Remote monitoring started for server TSMAPP. ANR0098W This system does not meet the minimum memory requirements. ANR0993I Server initialization complete. ANR0916I TIVOLI STORAGE MANAGER distributed by Tivoli is now ready for use. TSM:TSMOC> Storage Management Server for AIX - Version 7, Release 1, Level 4.100 TSM:TSMOC> ANR2812W License Audit completed - ATTENTION: Server is NOT in compliance with license terms. ANR1959I Status monitor collecting current data at 09:03:57. ANR1960I Status monitor finished collecting data at 09:04:01 and will sleep for 60 minutes. Storage Management Server for AIX - Version 7, Release 1, Level 4.100 TSM:TSMOC> -Original Message- From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Paul van Dongen Sent: Wednesday, September 14, 2016 8:30 AM To: ADSM-L@VM.MARIST.EDU Subject: Re: *EXTERNAL* Re: tsm/db2 won't start after boot drive crash/recovery Richard, I have recently moved several TSM servers between AIX systems (without restoring the DBs). Some points of attention: On a system without TSM, you must first install TSM software. You will also need some tweaking of the DB registry. 1. correct hostname in /sqllib/db2nodes.cfg 2. /etc/services must contain: DB2_ 60016/tcp DB2__160017/tcp DB2__260018/tcp DB2__END 60019/tcp Ports can vary, but must be in sequence 3. Instance "update": /opt/tivoli/tsm/db2/instance/db2iupdt 4. As instance owner: ~/sqllib/adm/db2set -g DB2SYSTEM= 5. dsm.sys for DBbackups has to be present (location depends on the TSM server version) If you need more details please PM me. Met vriendelijke groet / With kind regards, Paul van Dongen System Expert Vancis BV Science Park 408 1098 XH Amsterdam W: www.vancis.nl T: 020 560 6600 M: 06 4181 4446 E: paul.vandon...@vancis.nl -Original Message- From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Rhodes, Richard L. Sent: 14 September 2016 13:48 To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] *EXTERNAL* Re: tsm/db2 won't start after boot drive crash/recovery No, DB2 won't start at all. rssymapi2p:/tsmdata/tsmoc/config==>db2start SQL6031N Error in the db2nodes.cfg file at line number "0". Reason code "11". I'm not sure how to state this, but I think there is some configuration in DB2 (that would be in on the boot drive) that points to the TSM database TSMDB1. I think that configuration is missing. For example, I found out about this cmd fighting a db2 problem some time ago. Run on a working TSM system: ./db2ilist tsmuser (our db2 owner) Run on this recovered system: ./db2ilist(no output) Rick -Original Message- From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Lee, Gary Sent: Tuesday, September 13, 2016 3:42 PM To: ADSM-L@VM.MARIST.EDU Subject: *EXTERNAL* Re: tsm/db2 won't start after boot drive crash/recovery Was db2 running for sure? In previous installs I had to modify the startup script to do a db2start then sleep for 10 secs to get tsm to start correctly fron reboot of the system. This was under redhat linux 6. That was the message I would get. -Original Message- From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Rhodes, Richard L. Sent: Tuesday, September 13, 2016 3:29 PM To: ADSM-L@VM.MARIST.EDU Subject: [ADSM-L] tsm/db2 won't start after boot drive crash/recovery Hello, We have a TSM v7.1.4 instance called TSMOC. Its sole purpose in life is to run Operations Center. It runs on an AIX lpar that's used for some other things. Last Friday the AIX rootvg was lost during a live migration to a new storage system. We decided to recover by installing a mksysb from a partner lpar which had the same AIX version and application version, but NOT TSM. So the lpar got back up and running quickly - only took an hour, but it's missing the TSM install. All the TSM instance files (dsmserv.opt, etc) and DB2 filesystems (data, logs, sqllib, etc) exist with all their data. They weren't lost since they were on a different lun and volume group. We installed TSM v7.1.4 and I then created the AIX db2 instance owner and group. We then tried to start TSM. We got msgs below. ANR7801I Subsystem process ID is 16056324. ANR0900I Processing o
Re: *EXTERNAL* Re: tsm/db2 won't start after boot drive crash/recovery
Thanks! I added the lines to /etc/services, and tried db2start, and db2 came up. When I run db2iupdt I get: rssymapi2p:/home/root==>/opt/tivoli/tsm/db2/instance/db2iupdt tsmdb1 DBI1446I The db2iupdt command is running. DB2 installation is being initialized. The specified instance "tsmdb1" does not exist. Specify an existing instance name. Thanks! Rick -Original Message- From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Paul van Dongen Sent: Wednesday, September 14, 2016 8:30 AM To: ADSM-L@VM.MARIST.EDU Subject: Re: *EXTERNAL* Re: tsm/db2 won't start after boot drive crash/recovery Richard, I have recently moved several TSM servers between AIX systems (without restoring the DBs). Some points of attention: On a system without TSM, you must first install TSM software. You will also need some tweaking of the DB registry. 1. correct hostname in /sqllib/db2nodes.cfg 2. /etc/services must contain: DB2_ 60016/tcp DB2__160017/tcp DB2__260018/tcp DB2__END 60019/tcp Ports can vary, but must be in sequence 3. Instance "update": /opt/tivoli/tsm/db2/instance/db2iupdt 4. As instance owner: ~/sqllib/adm/db2set -g DB2SYSTEM= 5. dsm.sys for DBbackups has to be present (location depends on the TSM server version) If you need more details please PM me. Met vriendelijke groet / With kind regards, Paul van Dongen System Expert Vancis BV Science Park 408 1098 XH Amsterdam W: www.vancis.nl T: 020 560 6600 M: 06 4181 4446 E: paul.vandon...@vancis.nl -Original Message- From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Rhodes, Richard L. Sent: 14 September 2016 13:48 To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] *EXTERNAL* Re: tsm/db2 won't start after boot drive crash/recovery No, DB2 won't start at all. rssymapi2p:/tsmdata/tsmoc/config==>db2start SQL6031N Error in the db2nodes.cfg file at line number "0". Reason code "11". I'm not sure how to state this, but I think there is some configuration in DB2 (that would be in on the boot drive) that points to the TSM database TSMDB1. I think that configuration is missing. For example, I found out about this cmd fighting a db2 problem some time ago. Run on a working TSM system: ./db2ilist tsmuser (our db2 owner) Run on this recovered system: ./db2ilist(no output) Rick -Original Message- From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Lee, Gary Sent: Tuesday, September 13, 2016 3:42 PM To: ADSM-L@VM.MARIST.EDU Subject: *EXTERNAL* Re: tsm/db2 won't start after boot drive crash/recovery Was db2 running for sure? In previous installs I had to modify the startup script to do a db2start then sleep for 10 secs to get tsm to start correctly fron reboot of the system. This was under redhat linux 6. That was the message I would get. -Original Message- From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Rhodes, Richard L. Sent: Tuesday, September 13, 2016 3:29 PM To: ADSM-L@VM.MARIST.EDU Subject: [ADSM-L] tsm/db2 won't start after boot drive crash/recovery Hello, We have a TSM v7.1.4 instance called TSMOC. Its sole purpose in life is to run Operations Center. It runs on an AIX lpar that's used for some other things. Last Friday the AIX rootvg was lost during a live migration to a new storage system. We decided to recover by installing a mksysb from a partner lpar which had the same AIX version and application version, but NOT TSM. So the lpar got back up and running quickly - only took an hour, but it's missing the TSM install. All the TSM instance files (dsmserv.opt, etc) and DB2 filesystems (data, logs, sqllib, etc) exist with all their data. They weren't lost since they were on a different lun and volume group. We installed TSM v7.1.4 and I then created the AIX db2 instance owner and group. We then tried to start TSM. We got msgs below. ANR7801I Subsystem process ID is 16056324. ANR0900I Processing options file /tsmdata/tsmoc/config/dsmserv.opt. ANR7811I Using instance directory /tsmdata/tsmoc/config. ANR4726I The ICC support module has been loaded. ANR0990I Server restart-recovery in progress. ANR0172I rdbinst.c(3942): Error encountered performing action UPDATE DBM CFG. ANR0162W Supplemental database diagnostic information: -6031:**No State Information Available (-2)**:-6031 (SQL6031N Error in the db2nodes.cfg file at line number "0". Reason code "11". ). ANR0171I dbiconn.c(1844): Error detected on 0:1, database in evaluation mode. ANR0162W Supplemental database diagnostic information: -1:08001:-1032 ([IBM][CLI Driver] SQL1032N No start database manager command was issued. SQLSTATE=57019 I think I've got to tell db2 about the database that exists on disk. We are going to call support, but figure
Re: *EXTERNAL* Re: tsm/db2 won't start after boot drive crash/recovery
Seems to be an issue with the DB2 global registry. To see the content of the registry: db2greg -dump -Original Message- From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Rhodes, Richard L. Sent: mercredi 14 septembre 2016 14:20 To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] *EXTERNAL* Re: tsm/db2 won't start after boot drive crash/recovery I found a db2nodes.cfg in the sqllib dir. The sqllib dir is NOT on rootvg so it wasn't lost. rssymapi2p:/tsmdata/tsmoc/config/sqllib==>cat db2nodes.cfg 0 rssymapi2p 0 The instance was a fully good/running TSM/DB2 system, although all it ever did was run the OC hub. For example, I found out about this cmd fighting a db2 problem some time ago. Running db2ilist returns nothing. ./db2ilist(no output) On other TSM instances db2ilist returns our DB2 owner. The doc you mentioned says to check /etc/services. On a good/running TSM I find these: DB2_tsmuser 6/tcp DB2_tsmuser_1 60001/tcp DB2_tsmuser_2 60002/tcp DB2_tsmuser_END 60003/tcp They are missing on this system we recovered rootvg. Will try adding them back in. Rick -Original Message- From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Loon, Eric van (ITOPT3) - KLM Sent: Wednesday, September 14, 2016 7:42 AM To: ADSM-L@VM.MARIST.EDU Subject: *EXTERNAL* Re: tsm/db2 won't start after boot drive crash/recovery Hi Richard! Did you check the contents of the db2nodes.cfg file? It should contain the local host name of the TSM server. You should also check if the instance is created successfully using the db2ilist command and also take a look at the following technote: http://www-01.ibm.com/support/docview.wss?uid=swg1IC67141 Kind regards, Eric van Loon Air France/KLM Storage Engineering -Original Message- From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Rhodes, Richard L. Sent: dinsdag 13 september 2016 21:29 To: ADSM-L@VM.MARIST.EDU Subject: tsm/db2 won't start after boot drive crash/recovery Hello, We have a TSM v7.1.4 instance called TSMOC. Its sole purpose in life is to run Operations Center. It runs on an AIX lpar that's used for some other things. Last Friday the AIX rootvg was lost during a live migration to a new storage system. We decided to recover by installing a mksysb from a partner lpar which had the same AIX version and application version, but NOT TSM. So the lpar got back up and running quickly - only took an hour, but it's missing the TSM install. All the TSM instance files (dsmserv.opt, etc) and DB2 filesystems (data, logs, sqllib, etc) exist with all their data. They weren't lost since they were on a different lun and volume group. We installed TSM v7.1.4 and I then created the AIX db2 instance owner and group. We then tried to start TSM. We got msgs below. ANR7801I Subsystem process ID is 16056324. ANR0900I Processing options file /tsmdata/tsmoc/config/dsmserv.opt. ANR7811I Using instance directory /tsmdata/tsmoc/config. ANR4726I The ICC support module has been loaded. ANR0990I Server restart-recovery in progress. ANR0172I rdbinst.c(3942): Error encountered performing action UPDATE DBM CFG. ANR0162W Supplemental database diagnostic information: -6031:**No State Information Available (-2)**:-6031 (SQL6031N Error in the db2nodes.cfg file at line number "0". Reason code "11". ). ANR0171I dbiconn.c(1844): Error detected on 0:1, database in evaluation mode. ANR0162W Supplemental database diagnostic information: -1:08001:-1032 ([IBM][CLI Driver] SQL1032N No start database manager command was issued. SQLSTATE=57019 I think I've got to tell db2 about the database that exists on disk. We are going to call support, but figured I'd ask here first! Any thought/comments are appreciated! Rick -The information contained in this message is intended only for the personal and confidential use of the recipient(s) named above. If the reader of this message is not the intended recipient or an agent responsible for delivering it to the intended recipient, you are hereby notified that you have received this document in error and that any review, dissemination, distribution, or copying of this message is strictly prohibited. If you have received this communication in error, please notify us immediately, and delete the original message. For information, services and offers, please visit our web site: http://www.klm.com. This e-mail and any attachment may contain confidential and privileged material intended for the addressee only. If you are not the addressee, you are notified that no part of the e-mail or any attachment may be disclosed, copied or distributed, and that any other action related to this e-mail or attachment is strictly prohibited, and may be unlawful. If you have received this e-mail
Re: *EXTERNAL* Re: tsm/db2 won't start after boot drive crash/recovery
Richard, I have recently moved several TSM servers between AIX systems (without restoring the DBs). Some points of attention: On a system without TSM, you must first install TSM software. You will also need some tweaking of the DB registry. 1. correct hostname in /sqllib/db2nodes.cfg 2. /etc/services must contain: DB2_ 60016/tcp DB2__160017/tcp DB2__260018/tcp DB2__END 60019/tcp Ports can vary, but must be in sequence 3. Instance "update": /opt/tivoli/tsm/db2/instance/db2iupdt 4. As instance owner: ~/sqllib/adm/db2set -g DB2SYSTEM= 5. dsm.sys for DBbackups has to be present (location depends on the TSM server version) If you need more details please PM me. Met vriendelijke groet / With kind regards, Paul van Dongen System Expert Vancis BV Science Park 408 1098 XH Amsterdam W: www.vancis.nl T: 020 560 6600 M: 06 4181 4446 E: paul.vandon...@vancis.nl -Original Message- From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Rhodes, Richard L. Sent: 14 September 2016 13:48 To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] *EXTERNAL* Re: tsm/db2 won't start after boot drive crash/recovery No, DB2 won't start at all. rssymapi2p:/tsmdata/tsmoc/config==>db2start SQL6031N Error in the db2nodes.cfg file at line number "0". Reason code "11". I'm not sure how to state this, but I think there is some configuration in DB2 (that would be in on the boot drive) that points to the TSM database TSMDB1. I think that configuration is missing. For example, I found out about this cmd fighting a db2 problem some time ago. Run on a working TSM system: ./db2ilist tsmuser (our db2 owner) Run on this recovered system: ./db2ilist(no output) Rick -Original Message- From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Lee, Gary Sent: Tuesday, September 13, 2016 3:42 PM To: ADSM-L@VM.MARIST.EDU Subject: *EXTERNAL* Re: tsm/db2 won't start after boot drive crash/recovery Was db2 running for sure? In previous installs I had to modify the startup script to do a db2start then sleep for 10 secs to get tsm to start correctly fron reboot of the system. This was under redhat linux 6. That was the message I would get. -Original Message- From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Rhodes, Richard L. Sent: Tuesday, September 13, 2016 3:29 PM To: ADSM-L@VM.MARIST.EDU Subject: [ADSM-L] tsm/db2 won't start after boot drive crash/recovery Hello, We have a TSM v7.1.4 instance called TSMOC. Its sole purpose in life is to run Operations Center. It runs on an AIX lpar that's used for some other things. Last Friday the AIX rootvg was lost during a live migration to a new storage system. We decided to recover by installing a mksysb from a partner lpar which had the same AIX version and application version, but NOT TSM. So the lpar got back up and running quickly - only took an hour, but it's missing the TSM install. All the TSM instance files (dsmserv.opt, etc) and DB2 filesystems (data, logs, sqllib, etc) exist with all their data. They weren't lost since they were on a different lun and volume group. We installed TSM v7.1.4 and I then created the AIX db2 instance owner and group. We then tried to start TSM. We got msgs below. ANR7801I Subsystem process ID is 16056324. ANR0900I Processing options file /tsmdata/tsmoc/config/dsmserv.opt. ANR7811I Using instance directory /tsmdata/tsmoc/config. ANR4726I The ICC support module has been loaded. ANR0990I Server restart-recovery in progress. ANR0172I rdbinst.c(3942): Error encountered performing action UPDATE DBM CFG. ANR0162W Supplemental database diagnostic information: -6031:**No State Information Available (-2)**:-6031 (SQL6031N Error in the db2nodes.cfg file at line number "0". Reason code "11". ). ANR0171I dbiconn.c(1844): Error detected on 0:1, database in evaluation mode. ANR0162W Supplemental database diagnostic information: -1:08001:-1032 ([IBM][CLI Driver] SQL1032N No start database manager command was issued. SQLSTATE=57019 I think I've got to tell db2 about the database that exists on disk. We are going to call support, but figured I'd ask here first! Any thought/comments are appreciated! Rick - The information contained in this message is intended only for the personal and confidential use of the recipient(s) named above. If the reader of this message is not the intended recipient or an agent responsible for delivering it to the intended recipient, you are hereby notified that you have received this document in error and that any review, dissemination, distribution, or copying of this message is strictly prohibited. If you have received this communication in error, please notify us immediately, and delete the original message. -The in
Re: *EXTERNAL* Re: tsm/db2 won't start after boot drive crash/recovery
I found a db2nodes.cfg in the sqllib dir. The sqllib dir is NOT on rootvg so it wasn't lost. rssymapi2p:/tsmdata/tsmoc/config/sqllib==>cat db2nodes.cfg 0 rssymapi2p 0 The instance was a fully good/running TSM/DB2 system, although all it ever did was run the OC hub. For example, I found out about this cmd fighting a db2 problem some time ago. Running db2ilist returns nothing. ./db2ilist(no output) On other TSM instances db2ilist returns our DB2 owner. The doc you mentioned says to check /etc/services. On a good/running TSM I find these: DB2_tsmuser 6/tcp DB2_tsmuser_1 60001/tcp DB2_tsmuser_2 60002/tcp DB2_tsmuser_END 60003/tcp They are missing on this system we recovered rootvg. Will try adding them back in. Rick -Original Message- From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Loon, Eric van (ITOPT3) - KLM Sent: Wednesday, September 14, 2016 7:42 AM To: ADSM-L@VM.MARIST.EDU Subject: *EXTERNAL* Re: tsm/db2 won't start after boot drive crash/recovery Hi Richard! Did you check the contents of the db2nodes.cfg file? It should contain the local host name of the TSM server. You should also check if the instance is created successfully using the db2ilist command and also take a look at the following technote: http://www-01.ibm.com/support/docview.wss?uid=swg1IC67141 Kind regards, Eric van Loon Air France/KLM Storage Engineering -Original Message- From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Rhodes, Richard L. Sent: dinsdag 13 september 2016 21:29 To: ADSM-L@VM.MARIST.EDU Subject: tsm/db2 won't start after boot drive crash/recovery Hello, We have a TSM v7.1.4 instance called TSMOC. Its sole purpose in life is to run Operations Center. It runs on an AIX lpar that's used for some other things. Last Friday the AIX rootvg was lost during a live migration to a new storage system. We decided to recover by installing a mksysb from a partner lpar which had the same AIX version and application version, but NOT TSM. So the lpar got back up and running quickly - only took an hour, but it's missing the TSM install. All the TSM instance files (dsmserv.opt, etc) and DB2 filesystems (data, logs, sqllib, etc) exist with all their data. They weren't lost since they were on a different lun and volume group. We installed TSM v7.1.4 and I then created the AIX db2 instance owner and group. We then tried to start TSM. We got msgs below. ANR7801I Subsystem process ID is 16056324. ANR0900I Processing options file /tsmdata/tsmoc/config/dsmserv.opt. ANR7811I Using instance directory /tsmdata/tsmoc/config. ANR4726I The ICC support module has been loaded. ANR0990I Server restart-recovery in progress. ANR0172I rdbinst.c(3942): Error encountered performing action UPDATE DBM CFG. ANR0162W Supplemental database diagnostic information: -6031:**No State Information Available (-2)**:-6031 (SQL6031N Error in the db2nodes.cfg file at line number "0". Reason code "11". ). ANR0171I dbiconn.c(1844): Error detected on 0:1, database in evaluation mode. ANR0162W Supplemental database diagnostic information: -1:08001:-1032 ([IBM][CLI Driver] SQL1032N No start database manager command was issued. SQLSTATE=57019 I think I've got to tell db2 about the database that exists on disk. We are going to call support, but figured I'd ask here first! Any thought/comments are appreciated! Rick -The information contained in this message is intended only for the personal and confidential use of the recipient(s) named above. If the reader of this message is not the intended recipient or an agent responsible for delivering it to the intended recipient, you are hereby notified that you have received this document in error and that any review, dissemination, distribution, or copying of this message is strictly prohibited. If you have received this communication in error, please notify us immediately, and delete the original message. For information, services and offers, please visit our web site: http://www.klm.com. This e-mail and any attachment may contain confidential and privileged material intended for the addressee only. If you are not the addressee, you are notified that no part of the e-mail or any attachment may be disclosed, copied or distributed, and that any other action related to this e-mail or attachment is strictly prohibited, and may be unlawful. If you have received this e-mail by error, please notify the sender immediately by return e-mail, and delete this message. Koninklijke Luchtvaart Maatschappij NV (KLM), its subsidiaries and/or its employees shall not be liable for the incorrect or incomplete transmission of this e-mail or any attachments, nor responsible for any delay in receipt. Koninklijke Luchtvaart Maatschappij N.V. (also known as KL
Re: *EXTERNAL* Re: tsm/db2 won't start after boot drive crash/recovery
No, DB2 won't start at all. rssymapi2p:/tsmdata/tsmoc/config==>db2start SQL6031N Error in the db2nodes.cfg file at line number "0". Reason code "11". I'm not sure how to state this, but I think there is some configuration in DB2 (that would be in on the boot drive) that points to the TSM database TSMDB1. I think that configuration is missing. For example, I found out about this cmd fighting a db2 problem some time ago. Run on a working TSM system: ./db2ilist tsmuser (our db2 owner) Run on this recovered system: ./db2ilist(no output) Rick -Original Message- From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Lee, Gary Sent: Tuesday, September 13, 2016 3:42 PM To: ADSM-L@VM.MARIST.EDU Subject: *EXTERNAL* Re: tsm/db2 won't start after boot drive crash/recovery Was db2 running for sure? In previous installs I had to modify the startup script to do a db2start then sleep for 10 secs to get tsm to start correctly fron reboot of the system. This was under redhat linux 6. That was the message I would get. -Original Message- From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Rhodes, Richard L. Sent: Tuesday, September 13, 2016 3:29 PM To: ADSM-L@VM.MARIST.EDU Subject: [ADSM-L] tsm/db2 won't start after boot drive crash/recovery Hello, We have a TSM v7.1.4 instance called TSMOC. Its sole purpose in life is to run Operations Center. It runs on an AIX lpar that's used for some other things. Last Friday the AIX rootvg was lost during a live migration to a new storage system. We decided to recover by installing a mksysb from a partner lpar which had the same AIX version and application version, but NOT TSM. So the lpar got back up and running quickly - only took an hour, but it's missing the TSM install. All the TSM instance files (dsmserv.opt, etc) and DB2 filesystems (data, logs, sqllib, etc) exist with all their data. They weren't lost since they were on a different lun and volume group. We installed TSM v7.1.4 and I then created the AIX db2 instance owner and group. We then tried to start TSM. We got msgs below. ANR7801I Subsystem process ID is 16056324. ANR0900I Processing options file /tsmdata/tsmoc/config/dsmserv.opt. ANR7811I Using instance directory /tsmdata/tsmoc/config. ANR4726I The ICC support module has been loaded. ANR0990I Server restart-recovery in progress. ANR0172I rdbinst.c(3942): Error encountered performing action UPDATE DBM CFG. ANR0162W Supplemental database diagnostic information: -6031:**No State Information Available (-2)**:-6031 (SQL6031N Error in the db2nodes.cfg file at line number "0". Reason code "11". ). ANR0171I dbiconn.c(1844): Error detected on 0:1, database in evaluation mode. ANR0162W Supplemental database diagnostic information: -1:08001:-1032 ([IBM][CLI Driver] SQL1032N No start database manager command was issued. SQLSTATE=57019 I think I've got to tell db2 about the database that exists on disk. We are going to call support, but figured I'd ask here first! Any thought/comments are appreciated! Rick - The information contained in this message is intended only for the personal and confidential use of the recipient(s) named above. If the reader of this message is not the intended recipient or an agent responsible for delivering it to the intended recipient, you are hereby notified that you have received this document in error and that any review, dissemination, distribution, or copying of this message is strictly prohibited. If you have received this communication in error, please notify us immediately, and delete the original message. - The information contained in this message is intended only for the personal and confidential use of the recipient(s) named above. If the reader of this message is not the intended recipient or an agent responsible for delivering it to the intended recipient, you are hereby notified that you have received this document in error and that any review, dissemination, distribution, or copying of this message is strictly prohibited. If you have received this communication in error, please notify us immediately, and delete the original message.
Re: tsm/db2 won't start after boot drive crash/recovery
Hi Richard! Did you check the contents of the db2nodes.cfg file? It should contain the local host name of the TSM server. You should also check if the instance is created successfully using the db2ilist command and also take a look at the following technote: http://www-01.ibm.com/support/docview.wss?uid=swg1IC67141 Kind regards, Eric van Loon Air France/KLM Storage Engineering -Original Message- From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Rhodes, Richard L. Sent: dinsdag 13 september 2016 21:29 To: ADSM-L@VM.MARIST.EDU Subject: tsm/db2 won't start after boot drive crash/recovery Hello, We have a TSM v7.1.4 instance called TSMOC. Its sole purpose in life is to run Operations Center. It runs on an AIX lpar that's used for some other things. Last Friday the AIX rootvg was lost during a live migration to a new storage system. We decided to recover by installing a mksysb from a partner lpar which had the same AIX version and application version, but NOT TSM. So the lpar got back up and running quickly - only took an hour, but it's missing the TSM install. All the TSM instance files (dsmserv.opt, etc) and DB2 filesystems (data, logs, sqllib, etc) exist with all their data. They weren't lost since they were on a different lun and volume group. We installed TSM v7.1.4 and I then created the AIX db2 instance owner and group. We then tried to start TSM. We got msgs below. ANR7801I Subsystem process ID is 16056324. ANR0900I Processing options file /tsmdata/tsmoc/config/dsmserv.opt. ANR7811I Using instance directory /tsmdata/tsmoc/config. ANR4726I The ICC support module has been loaded. ANR0990I Server restart-recovery in progress. ANR0172I rdbinst.c(3942): Error encountered performing action UPDATE DBM CFG. ANR0162W Supplemental database diagnostic information: -6031:**No State Information Available (-2)**:-6031 (SQL6031N Error in the db2nodes.cfg file at line number "0". Reason code "11". ). ANR0171I dbiconn.c(1844): Error detected on 0:1, database in evaluation mode. ANR0162W Supplemental database diagnostic information: -1:08001:-1032 ([IBM][CLI Driver] SQL1032N No start database manager command was issued. SQLSTATE=57019 I think I've got to tell db2 about the database that exists on disk. We are going to call support, but figured I'd ask here first! Any thought/comments are appreciated! Rick -The information contained in this message is intended only for the personal and confidential use of the recipient(s) named above. If the reader of this message is not the intended recipient or an agent responsible for delivering it to the intended recipient, you are hereby notified that you have received this document in error and that any review, dissemination, distribution, or copying of this message is strictly prohibited. If you have received this communication in error, please notify us immediately, and delete the original message. For information, services and offers, please visit our web site: http://www.klm.com. This e-mail and any attachment may contain confidential and privileged material intended for the addressee only. If you are not the addressee, you are notified that no part of the e-mail or any attachment may be disclosed, copied or distributed, and that any other action related to this e-mail or attachment is strictly prohibited, and may be unlawful. If you have received this e-mail by error, please notify the sender immediately by return e-mail, and delete this message. Koninklijke Luchtvaart Maatschappij NV (KLM), its subsidiaries and/or its employees shall not be liable for the incorrect or incomplete transmission of this e-mail or any attachments, nor responsible for any delay in receipt. Koninklijke Luchtvaart Maatschappij N.V. (also known as KLM Royal Dutch Airlines) is registered in Amstelveen, The Netherlands, with registered number 33014286
Re: tsm/db2 won't start after boot drive crash/recovery
Was db2 running for sure? In previous installs I had to modify the startup script to do a db2start then sleep for 10 secs to get tsm to start correctly fron reboot of the system. This was under redhat linux 6. That was the message I would get. -Original Message- From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Rhodes, Richard L. Sent: Tuesday, September 13, 2016 3:29 PM To: ADSM-L@VM.MARIST.EDU Subject: [ADSM-L] tsm/db2 won't start after boot drive crash/recovery Hello, We have a TSM v7.1.4 instance called TSMOC. Its sole purpose in life is to run Operations Center. It runs on an AIX lpar that's used for some other things. Last Friday the AIX rootvg was lost during a live migration to a new storage system. We decided to recover by installing a mksysb from a partner lpar which had the same AIX version and application version, but NOT TSM. So the lpar got back up and running quickly - only took an hour, but it's missing the TSM install. All the TSM instance files (dsmserv.opt, etc) and DB2 filesystems (data, logs, sqllib, etc) exist with all their data. They weren't lost since they were on a different lun and volume group. We installed TSM v7.1.4 and I then created the AIX db2 instance owner and group. We then tried to start TSM. We got msgs below. ANR7801I Subsystem process ID is 16056324. ANR0900I Processing options file /tsmdata/tsmoc/config/dsmserv.opt. ANR7811I Using instance directory /tsmdata/tsmoc/config. ANR4726I The ICC support module has been loaded. ANR0990I Server restart-recovery in progress. ANR0172I rdbinst.c(3942): Error encountered performing action UPDATE DBM CFG. ANR0162W Supplemental database diagnostic information: -6031:**No State Information Available (-2)**:-6031 (SQL6031N Error in the db2nodes.cfg file at line number "0". Reason code "11". ). ANR0171I dbiconn.c(1844): Error detected on 0:1, database in evaluation mode. ANR0162W Supplemental database diagnostic information: -1:08001:-1032 ([IBM][CLI Driver] SQL1032N No start database manager command was issued. SQLSTATE=57019 I think I've got to tell db2 about the database that exists on disk. We are going to call support, but figured I'd ask here first! Any thought/comments are appreciated! Rick - The information contained in this message is intended only for the personal and confidential use of the recipient(s) named above. If the reader of this message is not the intended recipient or an agent responsible for delivering it to the intended recipient, you are hereby notified that you have received this document in error and that any review, dissemination, distribution, or copying of this message is strictly prohibited. If you have received this communication in error, please notify us immediately, and delete the original message.
tsm/db2 won't start after boot drive crash/recovery
Hello, We have a TSM v7.1.4 instance called TSMOC. Its sole purpose in life is to run Operations Center. It runs on an AIX lpar that's used for some other things. Last Friday the AIX rootvg was lost during a live migration to a new storage system. We decided to recover by installing a mksysb from a partner lpar which had the same AIX version and application version, but NOT TSM. So the lpar got back up and running quickly - only took an hour, but it's missing the TSM install. All the TSM instance files (dsmserv.opt, etc) and DB2 filesystems (data, logs, sqllib, etc) exist with all their data. They weren't lost since they were on a different lun and volume group. We installed TSM v7.1.4 and I then created the AIX db2 instance owner and group. We then tried to start TSM. We got msgs below. ANR7801I Subsystem process ID is 16056324. ANR0900I Processing options file /tsmdata/tsmoc/config/dsmserv.opt. ANR7811I Using instance directory /tsmdata/tsmoc/config. ANR4726I The ICC support module has been loaded. ANR0990I Server restart-recovery in progress. ANR0172I rdbinst.c(3942): Error encountered performing action UPDATE DBM CFG. ANR0162W Supplemental database diagnostic information: -6031:**No State Information Available (-2)**:-6031 (SQL6031N Error in the db2nodes.cfg file at line number "0". Reason code "11". ). ANR0171I dbiconn.c(1844): Error detected on 0:1, database in evaluation mode. ANR0162W Supplemental database diagnostic information: -1:08001:-1032 ([IBM][CLI Driver] SQL1032N No start database manager command was issued. SQLSTATE=57019 I think I've got to tell db2 about the database that exists on disk. We are going to call support, but figured I'd ask here first! Any thought/comments are appreciated! Rick - The information contained in this message is intended only for the personal and confidential use of the recipient(s) named above. If the reader of this message is not the intended recipient or an agent responsible for delivering it to the intended recipient, you are hereby notified that you have received this document in error and that any review, dissemination, distribution, or copying of this message is strictly prohibited. If you have received this communication in error, please notify us immediately, and delete the original message.