This is part of the larger task of customizing your z/OS environment.
WebSphere Business Integration Event Broker for z/OS accesses DB2 tables using ODBC. To connect to DB2 using ODBC, the location name of the DB2 subsystem is used. See the DB2 UDB for OS/390® and z/OS V7 Data Sharing: Planning and Administration manual for more details.
When your DB2 system starts up there should be a message DSNL004I DDF START COMPLETE. The location name is displayed just after this message.
WebSphere Business Integration Event Broker for z/OS customization creates an ODBC initialization file, DSNAOINI. It contains necessary information to establish the ODBC connection. See the DB2 UDB for OS/390 and z/OS V7 ODBC Guide and Reference manual for more details.
You should avoid using a data source name that is the same as the subsystem ID or data sharing ID. If the same name is used, this might affect the granularity of directives on connection with the database.
If you choose to use the same value for the data source name and subsystem ID, you must edit DSNAOINI in the broker directory so the Datasource and Subsystem keywords are in one section.
See the DB2 UDB for OS/390 and z/OS V7 ODBC Guide and Reference manual for more information on customizing this file.
select * from SYSIBM.SYSPACKLIST where planname ='DSNACLI';You should rebind if the location column is blank and not '*'.
You should also check that DSNACLI is in the SYSIBM.SYSPLAN table.
You will get significant performance benefits from using the CACHE DYNAMIC SQL facility of DB2, because this eliminates the need to reprocess DB2 statements. See CACHEDYN=YES in the DB2 UDB for OS/390 and z/OS V7 Installation Guide.
Notices |
Trademarks |
Downloads |
Library |
Support |
Feedback
![]() ![]() |
ae22130_ |