| View previous topic :: View next topic |
| Author |
Message |
Consultant
Beginner
Joined: 21 Jan 2008
Posts: 5
Topics: 3
|
 Posted: Fri Feb 15, 2008 8:28 am Post subject: -805 how to get 2 timestamps with SYSIBM.SYS* queries? |
 |
|
I am getting the -805 error when I moved a program to production environment.Is there anyway to resolve this without recompiling this..If I recompile also at our site IMS Switch occurs weekly once only..The change goes with IMS Switch after a week..
And what timestamps I need to cross check..DBRM and Package timestamps??..I want to get the 2 timestamps from SYSIBM.SYS* queries how to get that???Our shop is using packages..Can anybody provide the exact queries and if there is any resolution without compiling again?? |
|
| Back to top |
|
 |
kolusu
Site Admin
Joined: 26 Nov 2002
Posts: 12375
Topics: 75
Location: San Jose
|
| Posted: Fri Feb 15, 2008 11:56 am Post subject: |
|
|
| Quote: | | Is there anyway to resolve this without recompiling this..If I recompile also at our site IMS Switch occurs weekly once only..The change goes with IMS Switch after a week.. |
NO you have to recompile.
To get the timestamps execute the following query
| Code: |
SELECT * FROM SYSIBM.SYSPLAN WHERE NAME = 'plan name';
SELECT * FROM SYSIBM.SYSDBRM WHERE PLNAME = 'plan name';
|
These two queries will give you the BIND and PRECOMP date/time which you can use to compare with the load modules
_________________
Kolusu
www.linkedin.com/in/kolusu |
|
| Back to top |
|
|
Consultant
Beginner
Joined: 21 Jan 2008
Posts: 5
Topics: 3
|
| Posted: Sun Feb 17, 2008 6:15 pm Post subject: |
|
|
| We are using packages in this case I am checking in SYSIBM.SYSPACKAGES here it exists with NAME(dbrm-name as |
|
| Back to top |
|
|
videlord
Beginner
Joined: 09 Dec 2004
Posts: 147
Topics: 19
|
| Posted: Tue Feb 19, 2008 7:41 pm Post subject: |
|
|
setlect hex(contoken) from sysibm.syspackage where...
compare the contoken with your load module
(search the first 8 hex digit and then next 8 hex digit; depend on the program laguage, the token may swtich the 8 digit) |
|
| Back to top |
|
|
|
|
|
FAQ
Search
Quick Manuals
Register
Profile
Log in to check your private messages
Log in
