AIX 6.1 and TSM/SPECTRUM 7.1.6 problem

[mapple]

Hello to everyone.

Currently have an issue with installation,

https://www.ibm.com/support/knowledgecenter/SSGSG7_7.1.6/srv.install/t_srv_1ststeps-aix.html

this guide was used.

I was able to go through with manual steps - because dsmicfgx didn't work - he didn't even care about -i console switch so went with manual steps.

And currently when I do run :

dsmserv format dbdir=/tsmdb001 activelogsize=15768 activelogdirectory=/tsmlog archlogdirectory=/tsmarchlog archfailoverlogdirectory=/tsmarchlogfailover mirrorlogdirectory=/tsmlogmirror

I got

exec(): 0509-036 Cannot load program dsmserv because of the following errors:
0509-150 Dependent module libdb2.a(shr_64.o) could not be loaded.
0509-022 Cannot load module libdb2.a(shr_64.o).
0509-026 System error: A file or directory in the path name does not exist.

I'm pretty sure that I'm good user :
$ whoami
tsminst1
and that I also have all paths :
$ echo $LIBPATH
/usr/opt/ibm/gsksa/lib64:server_bin_directory/dbbkapi:/usr/opt/ibm/gsk8_64/lib64:server_bin_directory/dbbkapi:/usr/opt/ibm/gsk8_64/lib64:

am I missing something or another feature of IBM installation?

 

[marclant]

dsmserv format dbdir=/tsmdb001 activelogsize=15768 activelogdirectory=/tsmlog archlogdirectory=/tsmarchlog archfailoverlogdirectory=/tsmarchlogfailover mirrorlogdirectory=/tsmlogmirror

Try the full path of the executable instead and from the user's home directory:

$ cd /home/tsminst1
$ /opt/tivoli/tsm/server/bin/dsmserv format dbdir=/tsmdb001 activelogsize=15768 activelogdirectory=/tsmlog archlogdirectory=/tsmarchlog archfailoverlogdirectory=/tsmarchlogfailover mirrorlogdirectory=/tsmlogmirror

source: http://www-01.ibm.com/support/docview.wss?uid=swg21589521

 

[mapple]

Try the full path of the executable instead and from the user's home directory:

$ cd /home/tsminst1
$ /opt/tivoli/tsm/server/bin/dsmserv format dbdir=/tsmdb001 activelogsize=15768 activelogdirectory=/tsmlog

Sir thank you for you time I did try to follow your guidance :

$ cd /home/tsminst1
$ dsmserv format dbdir=/tsmdb001 activelogsize=15768 activelogdirectory=/tsmlog archlogdirectory=/tsmarchlog archfailoverlogdirectory=/tsmarchlogfailover mirrorlogdirectory=/tsmlogmirror
ANR7800I DSMSERV generated at 16:31:17 on Jun  8 2016.

IBM Tivoli Storage Manager for AIX
Version 7, Release 1, Level 6.000

Licensed Materials - Property of IBM

(C) Copyright IBM Corporation 1990, 2016.
All rights reserved.
U.S. Government Users Restricted Rights - Use, duplication or disclosure
restricted by GSA ADP Schedule Contract with IBM Corporation.

ANR7801I Subsystem process ID is 18612256.
ANR0900I Processing options file /tsminst1/dsmserv.opt.
ANR7811I Using instance directory /tsminst1.
ANR4726I The ICC support module has been loaded.
ANR0152I Database manager successfully started.
ANR0172I rdbdb.c(1955): Error encountered performing action CreateDatabase.
ANR0162W Supplemental database diagnostic information:  -1043:**No State
Information Available (-2)**:-1043 (SQL1043C  Database Services could not
initialize the system catalogs.  Error "-289" was returned.
).
Failed (sqlca.sqlcode = -1043 ) to create database TSMDB1
ANR2678E Server database format failed.
$


other than time issue which I see right now anything else which might be wrong?

ML: fixed quotes

 

[marclant]

ANR0162W Supplemental database diagnostic information: -1043:**No State Information Available (-2)**:-1043 (SQL1043C Database Services could not initialize the system catalogs. Error "-289" was returned.

I Googled that and got: http://www-01.ibm.com/support/docview.wss?uid=swg21969159 (don't use the solution in that technote, it was just do demonstrate what error 289 meant)
Essentially not enough space.

How big is /tsmdb001?

 

[mapple]

right now it's :

# df -k /tsmdb001
Filesystem 1024-blocks Free %Used Iused %Iused Mounted on
/dev/hd4 393216 173884 56% 13166 23% /
# cd /tsmdb001
# ls


but I can assign more but how much is required? they didn't mentioned that. I got enough space for sure in installation path /opt/...... in /usr /home & /tmp

 

[marclant]

Well, it's best to start with the amount YOU will need. Did you go through the planning exercise to estimate the size of the database you will need?
https://www.ibm.com/support/knowled....srv.install.doc/t_srv_inst_db_space-aix.html

The reason to estimate the DB size before hand and giving it all the space on day 1 is you get better performance and the data is spread evenly. If you add other database directories later, it takes a while before the data is evenly distributed and get performance gain from added directories.

 

[marclant]

# df -k /tsmdb001
Filesystem 1024-blocks Free %Used Iused %Iused Mounted on
/dev/hd4 393216 173884 56% 13166 23% /
# cd /tsmdb001
# ls

I see that /tsmdb001 is not a filesystem, it's a directory in root. That's a big no no. Each of the directories that you specify in the format command need to be dedicated filesystems. And ideally, if your server will end up being large, you want 4 to 8 database directories (filesystems).

 

[mapple]

ls -ltr
total 12352
drwx------ 2 root system 256 Jan 01 1970 .ssh
lrwxrwxrwx 1 bin bin 8 Jan 01 1970 lib -> /usr/lib
lrwxrwxrwx 1 bin bin 5 Jan 01 1970 u -> /home
lrwxrwxrwx 1 bin bin 8 Jan 01 1970 bin -> /usr/bin
drwxrwxr-x 2 root system 256 Jan 01 1970 tftpboot
drwxr-xr-x 4 root system 256 Jan 01 1970 admin
drwxr-xr-x 2 root system 256 Jan 01 1970 data
lrwxrwxrwx 1 root system 20 Jan 01 1970 cfmroot -> /etc/opt/csm/cfmroot
drwxr-xr-x 3 root system 256 Jan 01 1970 csminstall
drwxr-xr-x 3 bin bin 256 Jan 01 1970 sbin
lrwxrwxrwx 1 root system 21 Jan 01 1970 unix -> /usr/lib/boot/unix_64
-rw------- 1 root system 1024 Jan 01 1970 .rnd
drwxr-xr-x 16 esaadmin system 4096 Jan 01 1970 esa
drwxr-xr-x 3 root system 256 Jan 01 1970 .java
drwxr-xr-x 2 root system 256 Jan 01 1970 cdrom
drwxr-xr-x 4 pconsole pconsole 256 Jan 01 1970 pconsole
drwxrwxr-x 3 root system 256 Aug 28 2010 export
drwxr-x--- 2 root audit 256 Aug 31 2010 audit
drwxr-xr-x 2 bin bin 256 Aug 31 2010 mnt
drwx------ 2 root system 256 Aug 31 2010 lost+found
drwxr-xr-x 26 root system 4096 Sep 30 22:46 opt
drwxr-xr-x 3 root system 256 Oct 03 22:18 .swt
drwxr-xr-x 62 bin bin 4096 Oct 03 22:34 usr
drwxr-xr-x 48 bin bin 4096 Oct 04 14:21 var
drwxr-xr-x 348 bin bin 20480 Oct 04 14:52 lpp
drwxr-xr-x 8 bin bin 256 Oct 04 14:59 home
drwxrwxrwx 2 tsminst1 tsmsrvrs 256 Oct 04 16:34 tsmdb002
drwxrwxrwx 2 tsminst1 tsmsrvrs 256 Oct 04 16:34 tsmdb003
drwxrwxrwx 2 tsminst1 tsmsrvrs 256 Oct 04 16:34 tsmdb004
drwxrwxr-x 2 root system 256 Oct 04 16:37 .InstallAnywhere
-rw------- 1 root system 152 Oct 06 17:36 .vi_history
-rw------- 1 root system 2848 Oct 06 18:01 .bash_history
drwxrwxrwx 3 tsminst1 tsmsrvrs 256 Oct 06 19:59 tsmarchlogfailover
drwxrwxrwx 3 tsminst1 tsmsrvrs 256 Oct 06 19:59 tsmlogmirror
drwxr-sr-x 2 tsminst1 tsmsrvrs 512 Oct 06 20:00 tsmlog
drwxrwxrwx 2 tsminst1 tsmsrvrs 256 Oct 06 20:01 tsmarchlog
drwxr-xr-x 47 root system 20480 Oct 06 20:07 etc
drwxr-xr-x 3 tsminst1 tsmsrvrs 256 Oct 06 20:23 tsminst1
drwxr-xr-x 3 tsminst1 tsmsrvrs 256 Oct 06 20:52 tsmdb001
drwxrwxr-x 5 root system 8192 Oct 06 20:52 dev
-rw-r--r-- 1 root system 115957 Oct 06 20:57 smit.transaction
-rw-r--r-- 1 root system 80249 Oct 06 20:57 smit.script
-rw-r--r-- 1 root system 6010856 Oct 06 20:57 smit.log
drwxrwxrwt 28 bin bin 4096 Oct 06 21:00 tmp
dr-xr-xr-x 1 root system 0 Oct 06 21:00 proc
-rw------- 1 root system 8908 Oct 06 21:00 .sh_history

# df -k
Filesystem 1024-blocks Free %Used Iused %Iused Mounted on
/dev/hd4 393216 169616 57% 13285 23% /
/dev/hd2 36700160 20008040 46% 205339 5% /usr
/dev/hd9var 1572864 1182924 25% 9260 4% /var
/dev/hd3 5242880 3824912 28% 3132 1% /tmp
/dev/fwdump 131072 130724 1% 4 1% /var/adm/ras/platform
/dev/hd1 2097152 2039600 3% 170 1% /home
/proc - - - - - /proc
/dev/hd10opt 21757952 16665188 24% 30512 1% /opt
/dev/lv00 131072 126912 4% 18 1% /var/adm/csd
/dev/hd11admin 131072 130692 1% 5 1% /admin
/dev/livedump 262144 261776 1% 4 1% /var/adm/ras/livedump
/dev/lv01 17825792 17266240 4% 16 1% /tsmlog
/dev/fslv00 10485760 10483832 1% 4 1% /tsminst1
/dev/fslv01 10485760 10483832 1% 4 1% /tsmdb001


that's all right then now or still need to change fs for each arch/other logs and db00x paths?

 

[marclant]

that's all right then now or still need to change fs for each arch/other logs and db00x paths?

Yes

 

[mapple]

Thank you again, as you said created a filesystems for each of folders and it's all right. Currently only small issue where about entry within /etc/inittab don't start process as it should - doesn't really start at all but that's very minor issue (works started manually). Thank you again for help and your time.