Troubleshooting
Problem
dsmserv format command fails to create the Tivoli Storage Manager server instance. The command fails with db2 sqlcode = -968
Symptom
An example of the error message follows
#dsmserv format dbdir=/home/dbdir1 activelogsize=2048 activelogdir=/tsmserver/activelog archlogdir=/tsmserver/archivelog
ANR7801I Subsystem process ID is 618620.
ANR0900I Processing options file /home/tsminst2/dsmserv.opt.
ANR7811I Using instance directory /home/tsminst2.
ANR4726I The ICC support module has been loaded.
ANR0152I Database manager successfully started.
ANR0152I Database manager successfully started.
ANR0172I rdbdb.c(1145): Error encountered performing action CreateDatabase.
ANR0162W Supplemental database diagnostic information: -968:**No State
Information Available (71)**:-968 (**No Other Information Available (51)**).
Failed (sqlca.sqlcode = -968 ) to create database TSMDB1
Error 2158 initializing the database
ANR2678E Server database format failed.
In the above messages, the SQL error code is 968
Cause
One of the file systems containing the database directory is full
Diagnosing The Problem
To get the explanation of the db2 return code, run the help command:
db2 ? SQL0968
Explanation: One of the file systems containing the database is full. This file system may contain the database directory, the database log files, or a table space container.
User response: Free system space by erasing unwanted files. Do not erase database files. If additional space is required, it may be necessary to drop tables and indexes identified as not required.
On unix-based systems, this disk full condition may be due to exceeding the maximum file size allowed for the current userid. Use the chuser command to update fsize. A reboot may be necessary.
This disk full condition may be caused when containers are of varying sizes. If there is sufficient space in the file system, drop the table space and recreate it with containers of equal size.
Resolving The Problem
In this example dsmserv format command failed due to filesystem /home was full. On AIX use the "df -m" command to check the space on file system:
.
| # df -m /home | ||||||
| Filesystem | MB blocks | Free | %Used | Iused | %Iused | Mounted on |
| /dev/hd1 | 3072.00 | 84.80 | 98% | 10965 | 36% | /home |
To resolve this problem create database directories where the filesystem has sufficient space available.
Product Synonym
TSM
Was this topic helpful?
Document Information
Modified date:
17 June 2018
UID
swg21428272