Technical Blog Post
Abstract
50 DB2 Nuggets #11 : Resource Info - Knowledge Collection of DB2 for Linux, Unix and Windows Technotes for Q1 2014
Body
Hello DB2 Readers!
Looking for useful tips to solve some DB2 for Linux, Unix and Windows common problems. Here is a knowledge Collection of new DB2 Technotes published in Q1 2014 organized under different categories. Please review.
DB2 CORE:
"The registry does not exist" error messages in db2diag.log for file global.reg
/support/pages/node/242031
db2pd errors out with 'Failure: pdRememberInstanceOwnerID, rc: 0x870F00B4'
/support/pages/node/236677
SQL1051N, SQL2036N, or SQL1174N errors when using partition expressions in commands on DPF
/support/pages/node/240039
SQL0551N error when issuing 'REFRESH TABLE <table name>' command
/support/pages/node/239935
"DBI1060E Invalid package name ESE" error during db2_install
/support/pages/node/237015
DB2 installation on Linux fails with DBI1189E error even though the image is for the correct platform
/support/pages/node/236345
Function LISTAGG fails with SQL0440N after upgrade to DB2 V9.7 Fixpack 4 or higher
/support/pages/node/470179
DB2 Command Window and CLP hang when being started
/support/pages/node/128477
How to determine the tables responsible for a phantom quiesce on a tablespace
/support/pages/node/501529
What's the relationship between FCM_NUM_BUFFERS in dbm cfg and "Total Buffers" in "db2pd -fcm" output
http://www-01.ibm.com/support/docview.wss?uid=swg21398725
DAS Timeout messages filling up db2dasdiag.log
/support/pages/node/624655
db2 migration from older version fails with SQL2514N error during restore operation
/support/pages/node/235713
IBM DB2 Commands may fail with SQL1092N when executed from db2cmd.exe on Microsoft® Windows
/support/pages/node/236551
BACKUP & RECOVERY:
Error SQL0818N occurs when performing rollforward of a tablespace
/support/pages/node/345975
INTERNAL ARCHITECTURE:
DB2 reorganizes LOB data even though LONGLOBDATA clause is not specified in the 'REORG' command.
/support/pages/node/236187
A clarification on INDEXREC=RESTART behaviour
/support/pages/node/238761
PERFORMANCE:
Learning more about DB2 LUW Abend (crash)
/support/pages/node/404019
PURESCALE:
CF trace in DB2 pureScale environment
/support/pages/node/239269
uDAPL Version Verification on DB2 pureScale
http://www.ibm.com/support/docview.wss?uid=swg21648980
Setup HADR on PureScale
/support/pages/node/238653
OPTIMIZER:
Query Re-write generally does no matching for OUTER JOIN
/support/pages/node/237299
Design advisor hangs
http://www-01.ibm.com/support/docview.wss?uid=swg21381845
SECURITY:
DB2 crashes on Vintella Authentication Services function
/support/pages/node/240903
DB2 Audit operations may fail with DIA8506C error in db2diag.log
/support/pages/node/501683
Getting SQL1092N error when running any DB2 commands as a domain id
/support/pages/node/416083
Grant DB2 SECADM to userid from an existing LocalSystem (Windows) SECADM account
/support/pages/node/488993
COMMUNICATION:
Connection to DB2 may fail with SQL1248N error message after calling xa_close()
/support/pages/node/235809
Non-Java Applications receive SQL1034C (-1034) for connections to DB2 for z/OS V10 while Java Applications receive SQL0902C (-902)
/support/pages/node/502683
STORED PROCEDURE:
DB2 Java routine may fail with SQL1646N error on AIX and db2fmp process killed with signal 4
/support/pages/node/241437
How to map stored procedure names to packages after upgrading to DB2 UDB Version 8.2 or higher
/support/pages/node/83213
Collecting data: DB2 Stored Procedures Problems
/support/pages/node/625227
SQL1131N when invoking Micro Focus COBOL stored procedures
/support/pages/node/660465
CLI:
DB2 v10.5 Bind File and Package Name List
/support/pages/node/232365
The DB2Parameter with ParameterName 'paramname' is already contained by this DB2ParameterCollection from .Net application
/support/pages/node/498151
-525 error on NULLID.SYSSTAT package when trying to set CURRENT SCHEMA against a DB2 for z/OS database
/support/pages/node/213639
CLI0199E - "Invalid connection string attribute" when running CLI/ODBC application
/support/pages/node/236775
Thank you for your interest! We hope that you find our information relevant and helpful.
UID
ibm11141570