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.