WDI z/OS Error occurs 11041 - A database error occurred while attempting to open table "EDIENU32.EDIPSBI"

Technote (troubleshooting)


Problem(Abstract)

When exporting the trading partner profile from WDI 3.2.1 z/OS, error occurs 11041 - A database error occurred while attempting to open table "EDIENU32.EDIPSBI". ODBC return code is -1. Description: SQL0204N "EDIENU32.EDIPSBI" is an undefined name SQLSTATE=42704. Internal Codes: State: S0002,Native:-204, Origin:[IBM][CLI Driver][DB2]

Cause

Hold actions were not run after applying PTFs to WDI z/OS host system.

Resolving the problem

Check to see if all the hold actions were done that were required for any PTF's that were applied to the z/OS host system. Specifically check UK05042 where the table EDIPSBI needs to be created.


    HOLDDATA for PTF:
    If this PTF is being applied as part of a new product
    installation, the standard install process using EDISDB2
    should be followed.
    If this PTF is being applied as part of an incremental
    update, the customer should run the new DDL to update the
    WDI V3.2 DB2 Database. Follow the directions below:
    - edit the new member EDISDD13 in EDI.V3R2M0.SEDISQL1
    - modify EDIENU32 to your appropriate site database name
    - use the DB2 Interactive Functions (SPUFI) to run this DDL
    - run, via SPUFI, member EDISGRNT from EDI.V3R2M0.SEDISQL1.

Once the hold actions were done for PTF UK05042 and the EDIENU32.EDIPSBI table was created, the error was corrected.

Rate this page:

(0 users)Average rating

Document information


More support for:

WebSphere Data Interchange
WDI 3.2 for z/OS

Software version:

3.2.1

Operating system(s):

z/OS

Software edition:

All Editions

Reference #:

1235621

Modified date:

2013-04-16

Translate my page

Machine Translation

Content navigation