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 AT VM.MARIST DOT EDU] On Behalf Of
David Ehresman
Sent: 14 September 2016 15:25
To: ADSM-L AT VM.MARIST DOT 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 AT VM.MARIST DOT EDU] On Behalf Of
Rhodes, Richard L.
Sent: Wednesday, September 14, 2016 9:00 AM
To: ADSM-L AT VM.MARIST DOT 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 AT VM.MARIST DOT EDU] On Behalf Of
Paul van Dongen
Sent: Wednesday, September 14, 2016 8:30 AM
To: ADSM-L AT VM.MARIST DOT 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 <instance home dir>/sqllib/db2nodes.cfg 2. /etc/services
must contain:
DB2_<instance name> 60016/tcp
DB2_<instance name>_1 60017/tcp
DB2_<instance name>_2 60018/tcp
DB2_<instance name>_END 60019/tcp
Ports can vary, but must be in sequence
3. Instance "update": /opt/tivoli/tsm/db2/instance/db2iupdt <instance name> 4.
As instance owner: ~/sqllib/adm/db2set -g DB2SYSTEM=<hostname> 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.vanDongen AT vancis DOT nl
-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of
Rhodes, Richard L.
Sent: 14 September 2016 13:48
To: ADSM-L AT VM.MARIST DOT 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 AT VM.MARIST DOT EDU] On Behalf Of
Lee, Gary
Sent: Tuesday, September 13, 2016 3:42 PM
To: ADSM-L AT VM.MARIST DOT 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 AT VM.MARIST DOT EDU] On Behalf Of
Rhodes, Richard L.
Sent: Tuesday, September 13, 2016 3:29 PM
To: ADSM-L AT VM.MARIST DOT 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.
-----------------------------------------
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.
|