× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



Dave

How about taking a look at the plan cache? If running interactively and you have a fairly recent version of ACS, you have SQL Performance Center in the Actions menu of the emulator - here you can get to almost any statement that was run - not sure if it shows those that were attempted and failed somehow.

HTH
Vern

On 3/5/2018 3:01 PM, dlclark@xxxxxxxxxxxxxxxx wrote:
"MIDRANGE-L" <midrange-l-bounces@xxxxxxxxxxxx> wrote on 03/05/2018
03:29:49 PM:
We may also need a working and a failing example of &SQLSTMT, as shown
by
the debugger.

Don't need the debugger, I think, because I've written the CL to
write the SQL statement variable content to the joblog before executing
it. The following is what I see in the joblog when I run it interactively
(i.e., by itself). The one after that is what I see in the joblog when I
invoke the CL from within another CL running in batch on our separate test
LPAR. In this case, though, it is working in both. The problem situation
occurred last week when trying to run this in production.

IMLFBACKUP TYPE(IMLFBACKUP) TABLE(*ALL) COMPANY(00110)
CALL IM_LIFO_BACKUP ( 'IMLFBACKUP', '*ALL', '00110', NULL )
Object LF_COMPANY in IMLFBACKUP type *FILE deleted.
Object LF_COMPANY in IMLFBACKUP type *FILE created.
1 objects duplicated.
Object LFADJ00110 in QTEMP type *FILE created.
1 objects duplicated.
Object LFADJ00110 in IMLFBACKUP type *FILE deleted.
Object LFADJ00110 in QTEMP type *FILE moved to library IMLFBACKUP.
Object LFDTL00110 in QTEMP type *FILE created.
1 objects duplicated.
Object LFDTL00110 in IMLFBACKUP type *FILE deleted.
Object LFDTL00110 in QTEMP type *FILE moved to library IMLFBACKUP.
Object LFDVW00110 in QTEMP type *FILE created.
1 objects duplicated.
14931 records copied from member IMLFDTLV02.
Object LFDVW00110 in IMLFBACKUP type *FILE deleted.
Object LFDVW00110 in QTEMP type *FILE moved to library IMLFBACKUP.
Backup completed.


...snip...
Evaluating data library: DTA110
CALL IM_LIFO_BACKUP ( 'IMLFBEFORE', '*ALL', '00110', NULL )
Object LF_COMPANY in IMLFBEFORE type *FILE deleted.
Object LF_COMPANY in IMLFBEFORE type *FILE created.
1 objects duplicated.
Object LFADJ00110 in QTEMP type *FILE created.
1 objects duplicated.
Object LFADJ00110 in QTEMP type *FILE moved to library IMLFBEFORE.
Object LFDTL00110 in QTEMP type *FILE created.
1 objects duplicated.
Object LFDTL00110 in IMLFBEFORE type *FILE deleted.
Object LFDTL00110 in QTEMP type *FILE moved to library IMLFBEFORE.
Object LFDVW00110 in QTEMP type *FILE created.
1 objects duplicated.
14931 records copied from member IMLFDTLV02.
Object LFDVW00110 in QTEMP type *FILE moved to library IMLFBEFORE.
Backup completed.
...snip...


Sincerely,

Dave Clark


As an Amazon Associate we earn from qualifying purchases.

This thread ...

Follow-Ups:
Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.