You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
DSPJRN with the FILE parameter requires the table to exist, currently be attached to the journal, etc. This can make it difficult to dump journal transactions when the table has changed, if the analysis is being done on another server, etc.
Workaround:
Two ways:
(a) Leave the FILE parameter blank & dump all transactions, then go back and filter out the ones you don't need.
(b) Perform journal analysis on the same system as where the transactions happen.
(c) Use the Display_Journal UDTF
Proposal:
If FILE is specified on DSPJRN, do not check for it's existence or any properties of it. This is just like the behavior when FILE is not provided, or when using the UDTF.
The text was updated successfully, but these errors were encountered:
SELECT*FROM TABLE (Display_Journal('TSTLIB', 'QSQJRN')) AS x
WHERE OBJECT_TYPE IN('*FILE','*QDDS') AND SUBSTR(object,1,10) ='TBL1'AND SUBSTR(object,11,10) ='TSTLIB'ORDER BY entry_timestamp
DSPJRN with the FILE parameter requires the table to exist, currently be attached to the journal, etc. This can make it difficult to dump journal transactions when the table has changed, if the analysis is being done on another server, etc.
Workaround:
Two ways:
(a) Leave the FILE parameter blank & dump all transactions, then go back and filter out the ones you don't need.
(b) Perform journal analysis on the same system as where the transactions happen.
(c) Use the Display_Journal UDTF
Proposal:
If FILE is specified on DSPJRN, do not check for it's existence or any properties of it. This is just like the behavior when FILE is not provided, or when using the UDTF.
The text was updated successfully, but these errors were encountered: