DB2 Knowledge Summary

1. Recovery data error: sql1005n the database alias "Lygyzx" already exists in the local database directory or system database directory.

sqlstate=00000

Answer: Deleting a database with the quest for DB2 tool

2. When restoring the database, the SQL0294N container is already in use. sqlstate=42730

Answer: Delete all folders that contain "space" under the DB2 directory, or delete all the databases and restore them again.

Delete the DB folder of the D-Disk Gjyw folder

3. Stop database before restoring database

4.

Today in the company continue to SuSE 10 on the installation of DB2 v9.5, encountered two errors: sql6031n and sql1032n

1.SQL6031N cannot create an instance after the installation completes, and the command is entered in the terminal./db2icrt-u db2fenc1 Db2inst1 after the error

In the terminal with the command "uname-a", "hostname" To view the host name, and/etc/hosts file hostname is consistent, my error is/etc/hosts within the hostname default is localhost (127.0.0.1 localhost), change it to a host name that is consistent with the results of the command query.

another./db2icrt-u db2fenc1 db2inst1 command time-consuming, so be sure to have patience, I was impatient n times in the execution of the command CTRL + C canceled, the result of wasting more time.

2.SQL1032N No Start Database Manager command was issued. sqlstate=57019

Enter the/opt/ibm/db2/v9.5/adm directory and use the DB2LICM-L command to check whether the licence expires. If expired, use DB2LICM-A to import license;

After reboot login db2inst1 into the DB2 command set, if there is a sql1032n error, then use the Terminate interrupt service, and then use Db2start restart DB2 service.

DB2 database Server V8 (Linux) after changing the machine name, the database service exception is the symptom when the DB2 List DB Directory command or other command is used to prompt for the following error message:

SQL6031N An error occurred on the line number ' 1 ' of the Db2nodes.cfg file. The reason code is "10".

Solution: Open the file in the Sqllib subdirectory under the DB2 instance owner's home directory db2nodes.cfg modify the machine name in which the localhost is saved and start DB2 instance.

DB2 version 8, the original DB2 Enterprise and Enterprise Extensions merged into the Enterprise Server Edition, regardless of the partitioned database and the non-partitioned database, there will be db2nodes.cfg files in the instance directory, which records the server node information.

For the Windows platform example, the following line is recorded in the Db2nodes.cfg file in the "Sqllib" DB2 directory for a single partitioned database instance DB2 on the machine name TSSTEST1:

0 TSSTEST1 TSSTEST1 0

If you modify the machine name of the machine, you need to modify the file. For example, if you modify the machine name test, the file above needs to be modified to

0 test Test 0

Otherwise, the sql6031n error is reported when the evidence library instance is started, with the reason code 10.

The reason code 10 is explained by ensuring that the hostname values defined in the Db2nodes.cfg < line > line are defined on the system and can be manipulated.

In the Windows platform, you need to pay special attention to this problem if you define an instance to start automatically, or if you are accustomed to starting an instance in a service.

Source Documents

5. Length of the Extended data field

Answer:

ALTER TABLE bu_acctlisttmp

ALTER COLUMN "Acctno"

SET DATA TYPE VARCHAR (40);