AS/400 -Missing SQL PKG?

cdawes

VIP Member
[blush]I've got an issue on a AS/400 where I'm getting the following error in the client jde log:

2940/800 Wed Jul 30 10:22:50 2003 JDBODBC.C5439
ODB0000071 - SQLPrepare failed

2940/800 Wed Jul 30 10:22:50 2003 JDBODBC.C5439
[IBM][iSeries Access ODBC Driver][DB2 UDB]SQL0516 - Prepared statement QZ8¶67FFB09013430A not found. - SQLSTATE: S1000

2940/800 Wed Jul 30 10:22:50 2003 jdb_drvm.c938
JDB9900401 - Failed to execute db request

2940/800 Wed Jul 30 10:22:50 2003 ODBC_P1.C1490
ODB0000095 - SQLFetch failed in Table(1st) F98221
Database System - B7334

Does anyone know what this is? I'm just guessing that it's an SQL package but who knows?

Thanks

Colin
 
There are 3 system required SQLPKGs required to run OneWorld:

QZDAPKG, QSQLPKG2, QSQXDPKG

All the others application SQLPKGS can be deleted and will be recreated on the fly when a process needs them. Prior to applying a SP, you should delete them. Maybe one of the
SQLPKGs got corrupted if it is a SQLPKG problem. You can try closing down OneWorld and deleting all the SQLPKGs.

Grant
 
Bearing in mind of course that you have to IPL the AS/400 for the deletion
of SQL packages to take effect or the corrupted SQL packages get recreated
as they were.








MagarG
<[email protected] To: Gerald Kastanek/Toronto/IBM@IBMCA
G> cc:
Sent by: Subject: Re: AS/400 -Missing SQL PKG?
owner-jdelist@jde
list.com


07/31/2003 03:50
PM
Please respond to
jdelist





There are 3 system required SQLPKGs required to run OneWorld:QZDAPKG,
QSQLPKG2, QSQXDPKGAll the others application SQLPKGS can be deleted and
will be recreated on the fly when a process needs them. Prior to applying
a SP, you should delete them. Maybe one of the SQLPKGs got corrupted if it
is a SQLPKG problem. You can try closing down OneWorld and deleting all
the SQLPKGs.Grant
AS400 V5R1 Coexist Xe XU5 SP21(F1) CO-Win2000 SP3
--------------------------
To view this thread, go to:
http://www.jdelist.com/ubb/showthreaded.php?Cat=&Board=OW&Number=59181
+ - - - - - - - - - - - - - - - - - - - - - - - -+
This is the JDEList One World® / XE mailing list/forum.
Archives and information on how to SUBSCRIBE, and
UNSUBSCRIBE can be found on the JDEList Forum at
http://www.JDEList.com

JDEList is not affiliated with JDEdwards®

+ - - - - - - - - - - - - - - - - - - - - - - - -+
 
Actually,

it's not the SQLpackages - I checked so it's something else. I've IPL'ed since I did put on the Dtabase, Group and SUME PTF's. Still the error is there.

If that doesn't work then I'll borrow a page from the Microsoft manual and just IPL again and again.

Anyone have any other ideas?
 
Can you give us more information on why you say you have to IPL to remove
SQL packages completely?

In our experience, the SQL package is deleted and recreated correctly, at
least in this scenario: You make a programming change on say, a UBE, and it
does not work on the server. You then delete the SQL packages and let them
recreate and all is well (without an IPL). Would this work differently if
the SQL package were corrupt?

In addition, when we apply a service pack, we delete the B7334SYS SQL
packages before applying the SP, but I do not IPL after doing so. Do you
think there is a danger there?

Thanks...we're always learning.



Xe, SP 22_D1, Update 6, ES=AS/400 V5R1, CO=AS/400, Thick & Citrix Clients
 
Grant,

Actually you don't have to IPL for SQL package deletion to take effect. You can't delete packages that are in use, and if they aren't in use they will re-create when needed. We do this all the time.

We discovered this when we changed a file (deleted fields) and found out that this was not enough of a change to force thte access plan to be rebuilt. We brought down services, deleted the package and brought OW back up.

FWIW.

Tom Davidson
 
FYI...We also delete our SQL packages on the AS400. We delete all the SQL packages that do not begin with a 'Q' on a monthly basis since they are known to get corrupt and cause problems.
 
Hi Colin,

I have in the past seen similar 'odd' issues on occasions that have been resolved by upgrading the Client Access version being used on the client PC. Ensure the recommended level and Service pack is installed. There is an APAR link on the IBM website which will list the recommended PTFs, CA version etc. for a particular release of OS/400.

I hope this helps.

Regards,

Sanjeev
 
Hi,

You should only have to stop and restart services on OneWorld. Not IPL the
box. Some SQL packages require that the services be off before you can
delete them.

Xe, SP21_E1, Update 7, AS400 V5R2
 
When is this message being generated. IS the client already signed on, are they trying to execute an application?... the F98221 is an OMW file, are they trying to check out a ube version?
 
I know it's not missing packages as I've checked and all the IBM packages are there. I've also updated the Client Access Service pack for V5R2 to SI8894 and put on the fix for cwbodbc.dll. Stillt the issue is there.

All other things in OneWorld seem to function fine. Queries and batch processing work normally.

The issue only occurs in BV and OMW with the F98221. I've checked the table by doing selects from Operations Navigator. I've run all the statements from the debug log against the AS/400 and they all return rows.

Anyone have any ideas?

Colin
 
What operation is being executed when the message appears. Is this stopping the client from performing any specific operations? I found this on the IBM APARs, although it relates to a much earlier operating system, maybe caching is the issue. There used to be a cache option in the ODBC driver. If you can determine which QZDASOINIT job is processing for this user, you may find more information in that joblog or even in QEZDEBUG output queue. Those are the first places I look:

Using the local caching option for packaging in the DSN, the
customer's application failed and they received MSGSQL0516
f/QSQDESC x/1948 t/QSQDESC x/1948 in the QZDASOINIT joblog.
.
The msg disappears, when they disable the local caching option
in the
DSN.



Jean Driscoll
AS/400 Co-existent Xe 17.1, Update 4/A73Cum12
WWW.JDETips.com
 
Back
Top