Ansicht
Dokumentation
02630 - Forcing DB2/400 to use an index ?
General Material Data Fill RESBD Structure from EBP Component StructureThis documentation is copyright by SAP AG.
Forcing DB2/400 to use an index ?
Hello Jim!I DID see locks on the *SQLPKG objects.
But you have to find them using the statement name in the right library.
And the package name differs from the table name...
And there are several packagages per table in different libraries...
Kind regards
Rudi
-----Ursprüngliche Nachricht-----
Von: Jim Doll [mailto:JDOLLZp...]
Gesendet: Montag, 9. Juli 2001 14:44
An: rudolf.wiesmayrZm...
Betreff: Re: AW: Forcing DB2/400 to use an index ?
Rudi: I'm just getting back from vacation and catching up with my email.
Please note that in the past, locks didn't show on the SQL package. I know
because I used your logic about 4:30 one Friday afternoon and spent about 2
hours fixing it. The lock was on the table, not the SQL package. When I
deleted the SQL package, suddenly the work processes that had the file open
lost their access to it. I tracked down each work process and restarted it,
which forced a rebuild of the SQL package.
If there are no locks on the file, the SQL package can be deleted safely.
If there are only one or two locks, the work process can be restarted, which
will close the file and release the lock. You risk cancelling someone's
task, but if the system isn't busy, you should be OK.
Jim Doll, Perrigo
>>> rudolf.wiesmayrZm... 07/03 4:30 AM >>>
Hi SAPlings!
According to my recent experiences and this discussion
I just decided the following:
When I have to fight a DB performance problem, I will
1. Look at the optimizers decision
2. Identify the *SQLPKG involved
3. WrkObjLck <lib>/<package> *SQLPKG
4. Wait for the package to be free of locks
or force this by restarting the locking WPs
5. DltSQLPkg <lib>/<package>
Note: This has been ONE SINGLE SQLPKG and this is really
no state affair
6. Look if the optimizer makes a different decision now
after R/3 has rebuilt the package
7. Proceed with normal DB optimization procedures
BTW: Does anyone know how to gracefully restart a WP
when the system is busy so that noone gets harmed
by the "look-klick-delay" for the restart?
Kind regards
Rudi
-----Ursprüngliche Nachricht-----
Von: Gueldenpfennig, Volker [mailto:volker.gueldenpfennigZs...]
Gesendet: Dienstag, 3. Juli 2001 8:36
An: 'Betsy Strebe'
Cc: sap400Zm...
Betreff: RE: Forcing DB2/400 to use an index ?
To unsubscribe from this group, send an email to:
SAP on System i-unsubscribeZegroups.com
Your use of consolut is subject to http://www.consolut.net
Durban Tours - Südafrika Safari
BAL_S_LOG - Application Log: Log header data CL_GUI_FRONTEND_SERVICES - Frontend Services
This documentation is copyright by SAP AG.
Length: 3927 Date: 20240602 Time: 063942 sap01-206 ( 2 ms )
