Data inconsistent when running runqry and strsql

[gregmonay]

Hi all,

I have this strange problem when I run a runqry on my pf, data is being returned and display but when I use Strsql and select records to the same pf, there is no data returned. What could be the possible reason for this? The PF have multiple LFs. I tried to run DSPOBJD and checked on ODOBDM and its 0.

I was thinking of executing RCLSTG on the machine but was not sure if it will take long. We havent run RCLSTG on our machine since we use it. For those who have tried RCLSTG, what could be the down time running it? This is our system status:

System ASP . . . . . . . : 4325 G
% system ASP used . . . : 52.3368
Total aux stg . . . . . : 4325 G

Thanks,
Greg

[MichaelCatalani]

Re: Data inconsistent when running runqry and strsql

Its likely a library list issue, possibly a member. Are you sure that ODOBDM is zero? Maybe you meant ODOBSZ?

Can you post both the runqry statement and sql statement you used?

[gregmonay]

Re: Data inconsistent when running runqry and strsql

Thanks Michael,
Im sure that it is the same PF that I am querying because I explicitly input the pf and library during runqry and strsql

runqry *n mylib/myfile rcdslt(*yes)
select * from mylib/myfile where condition

I checked on ODOBDM because I was thinking that the object is damaged.
ODOBDM Object damaged: 0=Not damaged, 1=Full, 2=Partial

Is this has something to do with damaged access path? Any thoughts?
Thanks,
Greg

[MichaelCatalani]

Re: Data inconsistent when running runqry and strsql

hmmmm, post your record selection and full sql statement. It shouldnt be a damaged object, as that should affect both methods.

[gregmonay]

Re: Data inconsistent when running runqry and strsql

Michael,

It is only a simple record selection on a JDA table INVMST:

using runqry - with records returned

RUNQRY QRYFILE((MM4R6LIB/INVMST)) RCDSLT(*YES)

AND/OR Field Test Value (Field, Number, 'Characters', or ...)
INUMBR LIST 3835853 3835857

and using strsql - no records returned
select * from mm4r6lib/invmst where inumbr in (3835853 , 3835857)

By the way, I was informed by our operator that during the system backup, when the process asked for the next tape, he terminated the session thinking that the system is no longer responding causing abnormal termination. He then proceed to re IPL the machine.

These are the logs:
Load next tape volume on device TAP01. (C G)
Device DSP01 no longer communicating.
Load next tape volume on device TAP01. (C G)
C
Error occurred while processing object QSZPAVLI in library QUSRSYS.
Unattended IPL in progress after abnormal system end.
IPL from machine area ##MACH#B.
.
.
System value QIPLSTS changed from *N to 0.
Previous ending abnormal, reason code 9.
IPL options used.
Journal receiver QSJJRN0030 created in library QSRVAGT.
Damage was detected but has been ignored.
Journal receivers QSJJRN0029 and *N detached.
Journal receiver QYPSDB0030 created in library QMGTC.
Damage was detected but has been ignored.

I think this could have caused the issue.

Thanks,
Greg

[gcraill]

Re: Data inconsistent when running runqry and strsql

Operators eh!
The bane of systems integrity ...