Skip to main content
Announcements
UPGRADE ADVISORY for Qlik Replicate 2024.5: Read More
cancel
Showing results for 
Search instead for 
Did you mean: 
DeniseJeffers
Contributor
Contributor

ATYLOGR - doesn't specify how many deleted when DELETE REQUESTED - should provide statistics when job completed

I ran the ATYLOGR with the following:
// 'DELETE TO 2023-06-23,18:24:45.016108')
 
Why doesn't the report report on how many records were deleted?
Logstream name=TSI.QLIK.G2W2DATA
Maxlen=1024
To-date-time =2023-06-23,18:24:45.016108
DELETE RANGE function has been specified
ATYLOGR is ending successfully
 
Not providing us a count is of little value. This now forces your customers to print the records - delete records - and then reprint to determine how many were deleted?

the ATYLOGR PRINT function with from/to range does not limit to the range selected.

As a customer we should not have to PRINT records - DELETE records - PRINT records to confirm how many were deleted.  This is unacceptable from a customer perspective.
 

From a CUSTOMER perspective we'd like to see:

Logstream name=TSI.QLIK.G2W2DATA
Maxlen=1024
To-date-time =2023-06-23,18:24:45.016108
DELETE RANGE function has been specified

NUMBER OF RECORDS DELETED == xxxxx
ATYLOGR is ending successfully

 

3 Replies
john_wang
Support
Support

Hello Denise @DeniseJeffers ,

Thank you for opening the article.

You are right, the behavior can be reproduced in our labs. We also noticed the support ticket (00096393). Before we get a fix, maybe change the function code from MAXLEN 1024 to MAXLEN 1 in PRINT JCL could mitigate the JES SPOOL full up.

The piece of code sample:

000001 //RUNLOGR JOB 'RR','TTT',MSGLEVEL=(1,1),CLASS=A,
000002 // MSGCLASS=X,NOTIFY=&SYSUID,REGION=8M
000003 //*
000004 //LOGR EXEC PGM=ATYLOGR,
000005 // PARM=('/NAME ATTUNITY.CDC.VSAMBTCH MAXLEN 1 ',
000006 // 'PRINT FROM 2022-10-28,02:13:57 TO 2027-10-27,02:38:23')

 

Hope this helps a bit.

Regards,

John.

Help users find answers! Do not forget to mark a solution that worked for you! If already marked, give it a thumbs up!
DeniseJeffers
Contributor
Contributor
Author

I modified to MAX-LEN=1 but still had to cancel the job for JES
SYSPRINT LOGR 102 TDLM A LOCAL 106M
09.30.13 JOB43234 $HASP375 TDLMLGW3 ESTIMATE EXCEEDED BY 104,500,000 LINES 2 % SPOOL
09.30.15 JOB43234 IEF450I TDLMLGW3 LOGR - ABEND=S222 U0000 REASON=00000000 188
188 TIME=09.30.15

john_wang
Support
Support

Hello @DeniseJeffers ,

For a brief summary I'm pasting the FR link here.

Regards,

John.

Help users find answers! Do not forget to mark a solution that worked for you! If already marked, give it a thumbs up!