Problem with UTB after iSeries hardware Upgrade

bukosknr

Well Known Member
I am unable to use UTB after doing our iSeries upgrade. Everything else seems to be working fine. I have two iSeries boxes one that has PD another that has all other environments. I am using DBDR to connect. I cannot open up a table in any environment (Including PD). I get the following error(s) in my JDE Log. Any ideas?

5908/4612 Mon May 16 10:13:11 2005 JDBODBC.C3646
ODB0000025 - SQLTables failed

5908/4612 Mon May 16 10:13:11 2005 jdb_drvm.c1538
JDB9900189 - Failed to verify that table exists in Business Data - PROD

5908/4612 Mon May 16 10:13:11 2005 B9861110.c131
FD3N010 not found in Business Data - PROD.
 
Nick,

Just a hunch...but why don't you and rixone talk about this off-list. The devleopers here think you two may be experiencing similar issues.

Jen
 
Update on my issue. UTB only does not work in Production, our PD7333 environment. This is the only environment on the new hardware. We went from V5R2 to V5R3. We have all the correct PTF's. Evertthing else seems to work fine, like jobs running sales order entry etc.

Nick
 
I had the same issue. Here is some info on the resolution

Interacative apps were fine. UTB was not.
We deleted all non-IBM *SQLPKG's - no change
Checked authority to the QZDAPKG *SQLPKG
Checjked they had all PTF's applied - they did
Asked them to do a RCLSTG *DBXREF (I saw this in KG) but they had already done this.

Turned on ODBC trace:


oexplore 40c-54c ENTER SQLTablesW
HSTMT 044236E0
WCHAR * 0x00000000
SWORD 0
WCHAR * 0x04421BB8 [ -3] "CRP"
SWORD -3
WCHAR * 0x044227F8 [ -3] "F90"
SWORD -3
WCHAR * 0x04427B40 [ -3] "TABLE"
SWORD -3

oexplore 40c-54c EXIT SQLTablesW with return code -1 (SQL_ERROR)
HSTMT 044236E0
WCHAR * 0x00000000
SWORD 0
WCHAR * 0x04421BB8 [ -3] "CRP"
SWORD -3
WCHAR * 0x044227F8 [ -3] "F90"
SWORD -3
WCHAR * 0x04427B40 [ -3] "TABLE"
SWORD -3

DIAG [S1000] [IBM][Client Access Express ODBC Driver
(32-bit)][DB2/400 SQL]SQL0901 - SQL system error. (29986)

oexplore 40c-54c ENTER SQLErrorW
HENV 04421520
HDBC 04422400
HSTMT 044236E0
WCHAR * 0x0012CE10 (NYI)
SDWORD * 0x0012D4B4
WCHAR * 0x0012CA10
SWORD 325
SWORD * 0x0012D4AC

oexplore 40c-54c EXIT SQLErrorW with return code 0 (SQL_SUCCESS)
HENV 04421520
HDBC 04422400
HSTMT 044236E0
WCHAR * 0x0012CE10 (NYI)
SDWORD * 0x0012D4B4 (29986)
WCHAR * 0x0012CA10 [ 89] "[IBM][Client Access
Express ODBC Driver (32-"
SWORD 325
SWORD * 0x0012D4AC (89)

In the end we found a procedure to recreate the QZDAPKG *SQLPKG on IBM which resolved the issue
 
Fixed the problem by contacting peoplesoft support and getting the attached two documents (they will be in two post).
 

Attachments

  • 90992-OTI-99-0072 SQL Packages and AS400.doc
    74.5 KB · Views: 6,673
Other Document attached
 

Attachments

  • 90995-oti-03-0157 performance problems AS400 after upgrading OS.doc
    30.5 KB · Views: 1,240
Back
Top