The developerWorks Connections platform will be sunset on December 31, 2019. On January 1, 2020, this blog will no longer be available. More details available on our FAQ.
All posts
- Sort by:
- Date
- Title
- Likes
- Comments ▼
- Views
SQL0204N when accessing tables in Microsoft SQL Server through Db2 Federation
You may receive the following error when accessing tables in Microsoft SQL Server: SELECT count(*) FROM SRV1.DB1.TAB1 "DB1.TAB1 is an undefined name.. SQLCODE=-204, SQLSTATE=42704, DRIVER=4.19.56 In db2diag.log, the following messages reveal the actual error happens on Db2 server: EDUID : 12345 EDUNAME: db2agent (SAMPLE) 0 FUNCTION: DB2 UDB, mssql wrapper, Mssql_Server::get_error_info, probe:7 MESSAGE : ODBC error txt: DATA #1 : Hexdump, 796 bytes 0x000000011E21E920 : 5B46 6C75 6964 5175 6572 795D 5B4F 4442 ... [More]
|
Accessing a tablespace returns SQL0290N "Table space access is not allowed" even no container errors
Error SQL0290N may return when accessing a tablespace. For example, db2 reorg table DB2INST1.TAB1 SQL0290N Table space access is not allowed. SQLSTATE=55039 In db2diag.log, the following messages are logged: ... EDUID : 108 EDUNAME: db2agent (MYDB) 2 FUNCTION: DB2 UDB, base sys utilities, sqeAgent::AgentBreathingPoint, probe:16 CALLSTCK: (Static functions may not be resolved correctly, as they are resolved to the nearest symbol) [0] 0x00007F2FE024E6D5 _ZN8sqeAgent19AgentBreathingPointEi + 0x4D5 [1]... [More]
|
Error "DB2 in your environment should only be started by TSA" in IOC environment
In IOC( Intelligent Operations Center ) environment, you may receive error "DB2 in your environment should only be started by TSA" if you try to run db2start. Please note this is not a message generated by the usual db2start command from Db2, but rather IOC overloaded script db2start provided by IOC. This is due to IOC has a high availability environment managed by TSA(Tivoli System Automation) and you are not supposed to start/stop Db2 in the same way of non-HA envionment. If you need to manually start/stop Db2 in IOC for some reason,... [More]
|
db2egcf may return error SQLO_ADDR_CONFLICT on Linux
The following is an example of the error dumped in db2diag.log: PID : 12345 TID : xxx PROC : db2egcf INSTANCE: db2inst` NODE : 000 HOSTNAME: host1 FUNCTION: <0>, <0>, <0>, probe:100 MESSAGE : ZRC=0x850F00C4=-2062614332=SQLO_ADDR_CONFLICT "An address space conflict was detected attaching to shared memory." DATA #1 : String, 22 bytes sqlocshr.-2062614332.. CALLSTCK: (Static functions may not be resolved correctly, as they are resolved to the nearest symbol) [0]... [More]
|
db2move import fails with SQL3201N due to foreign key definitions
After using "db2move mydb export", running command "db2move mydb import" returns error SQL3201N. The following is an example from the output : * IMPORT: table "DB2INST1"."TAB1" ***ERROR -3201. Check message file tab59.msg! *** SQLCODE: -3201 - SQLSTATE: *** SQL3201N The specified table cannot be replaced because another table is dependent on it. * IMPORT: table "DB2INST1"."TAB2" WARNING 3107. Check message file tab60.msg! *** SQL Warning! SQLCODE is 3107 *** SQL3107W At least one warning... [More]
|
Getting Error code: -551 (CDJSN1156E failed to execute function 'Enable') when enabling JSON environment
We are seeing multiple reports of this issue so trying to document the behavior here. Here is the repro on Db2 11.1 Mod 4 Fix Pack 4 db2inst1@machine007:~/sqllib/json/bin> ./db2nosql.sh -p 50001 -db primet01 JSON Command Shell Setup and Launcher.
This batch script assumes your JRE is 1.5 and higher. 1.6 will mask your password.
Type db2nosql.sh -help to see options
IBM DB2 NoSQL JSON API 1.1.0.0 build 1.4.246
Licensed Materials - Property of IBM
(c) Copyright IBM Corp. 2013 All Rights Reserved. nosql>Type your JSON query and hit... [More]
Tags: error -551 code: json |
PROBEVUE: DETECT FILE DESCRIPTORS LEAK
This small script will keep a list of file descriptors obtained by calls like 'open()', accept(), socket() and store them in an associative array. When a given fd is closed it will be marked 'closed' in the array. Every few seconds (1h by default) the script will output the list of file descriptors in use by the process. Note that IOCP (IO Completion Port) related file descriptors are not handled as probevue doesn't have access to those calls. Some examples of output: -- open_files array (pid 11403730) [END PROBE]: key ... [More]
|
Why the Db2LUW Recover Database is not being able to pickup latest backup image
The simplest form of recover database command, db2 recover database <db-name> recover the latest backup image and rollforward to the end of logs using all default settings. The complain is why this command is not picking up the latest backup image. The reason is mostly on history file as recover database depend on history file to pickup the backup images. In this specific customer... [More]
Tags: history database db2luw recover ibm-blog |
How to debug the reason of a gpfs install failure during the installation of pureScale
This is a simple case demonstrating how to find out the reason of a gpfs installation failure during setting up a pureScale environment. It is a Redhat Linux 7.4 server, I was trying to install pureScale v11.1.4.4 on it. However, I saw this error and db2_install aborted: <skipped> Task #27 start Description: General Parallel File System (GPFS) Estimated time 100 second(s) Task #27 end DB2 Setup is undoing the changes made to your computer during this installation. Undo complete. A major error occurred while installing "DB2 Server... [More]
Tags: ibm-blog |
Many 'sqlpshrScanClose, probe:90444' db2diag.log message on v11.1m3fp3 and v11.1m3if1
Symptom If you are using v11.1m3fp3 and v11.1m3if1, you might have lots of the following error message in your db2diag.log 2019-04-07-15.17.39.594893+480 I24726862E574 LEVEL: Error PID : 6975 TID : 47284876207872 PROC : db2sysc 0 INSTANCE: xxxxxxx NODE : 000 DB : XX APPHDL : 0-37450 APPID: xxx.xxx.xxx.xxx.xxxxx.xxxxxxxxxxx AUTHID : xxxxxx HOSTNAME: xxxxx EDUID : 250 EDUNAME: db2agent (XX) 0 FUNCTION: DB2 UDB, recovery manager,... [More]
|
