IO09906: Support for DB2 v9.1 FP5+ and v9.5 FP2+

Direct links to fixes

APAR status

Closed as program error.

Error description

DB2 v9.1 FP5+ and v9.5 FP2+ require DB2INTANCE variable to be
set before using the instance from TDS server or TDS db utils
calling sqlepstart under covers to start db2instance.

This problem is first introduced by DB2 v9.1 FP5 and v9.5 FP2.
Before this the TDS server and tools work fine in a system where
two or more instances (TDS/db2) exist. This problem do not occur
on systems with only one TDS / db2 instance.

The global DB2INSTDEF gets set to the first instance by DB2.
When the second db2 instance gets started it gets affected by
the global DB2INSTDEF.

In the db2cli.log file, you will see messages similar to the
following :

2008-07-24-21:19:28.native retcode = -1652; state = " ";
 message = "SQL1652N File I/O error occurred."
07/24/08 21:19:28 native retcode = -1013; state = "08001";
 message = "[IBM][CLI Driver] SQL1013N The database alias name
 or database name "LDAPDB2B" could not be found. SQLSTATE=42705"
2008-07-24-21:24:52.native retcode = -1652; state = " ";
 message = "SQL1652N File I/O error occurred."
07/24/08 21:24:52 native retcode = -1013; state = "08001";
 message = "[IBM][CLI Driver] SQL1013N The database alias name
 or database name "LDAPDB2B" could not be found. SQLSTATE=42705"
2008-07-24-21:26:34.native retcode = -1652; state = " ";
 message = "SQL1652N File I/O error occurred."

Local fix

Refer the following technote:
http://www-01.ibm.com/support/docview.wss?rs=767&uid=swg21314966

Problem summary

All TDS commands which use DB2 now call db2set -g to unset the
global DB2INSTDEF for DB2 9 instances before running so that the
correct instance is used.

Problem conclusion

The fix for this APAR will be contained in the following
maintenance packages:
| interim fix | 6.2.0.0-TIV-ITDS-IF0002 |

Temporary fix

Comments

APAR Information

APAR number
IO09906
Reported component name
IBM TIV DIR SER
Reported component ID
5724J3960
Reported release
620
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2009-01-22
Closed date
2009-01-22
Last modified date
2009-01-22

APAR is sysrouted FROM one or more of the following:

IO09826
APAR is sysrouted TO one or more of the following:

Fix information

Fixed component name
IBM TIV DIR SER
Fixed component ID
5724J3960

Applicable component levels

[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSVJJU","label":"IBM Security Directory Server"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"620","Line of Business":{"code":"LOB24","label":"Security Software"}}]

Document Information

Modified date:
15 February 2024

Tips

IO09906: Support for DB2 v9.1 FP5+ and v9.5 FP2+

Direct links to fixes

Subscribe

APAR status

Closed as program error.

Error description

Local fix

Problem summary

Problem conclusion

Temporary fix

Comments

APAR Information

APAR number

Reported component name

Reported component ID

Reported release

Status

PE

HIPER

Special Attention

Submitted date

Closed date

Last modified date

APAR is sysrouted FROM one or more of the following:

APAR is sysrouted TO one or more of the following:

Fix information

Fixed component name

Fixed component ID

Applicable component levels

Document Information

Share your feedback

Need support?