----- SET AE RESTART POINT
SELECT to_char(ae_run_data), dump(to_char(ae_run_data))
FROM PS_AERUNCONTROL WHERE PROCESS_INSTANCE = 3766254
AE_PROG = 12 bytes
AE_SECTION = 8
AE_STEP =8
-- this must be the step before Abend
UPDATE PS_AERUNCONTROL
SET ae_run_data = to_clob(rpad('PROG',12,' ')||rpad('SECT',8,' ')||rpad('SETP',8,' ')||rpad('PROG',12,' ')||rpad('SECT',8,' ')||rpad('SETP',8,' '))
where PROCESS_INSTANCE = 3766254
----- SET UP AE FOR RESTART: set up a test area for debugging, need to bring data from original db
Using INTFAPAM as example:
1. state recs (select 'PS_'||AE_STATE_RECNAME from PSAEAPPLSTATE where AE_APPLID=' INTFAPAM' ):
PS_AP_VCHR_AUD_AET
PS_INTFC_APAM0_AET
PS_INTFC_APAM1_AET
PS_INTFC_APAM2_AET
PS_INTFC_AP_AM_AET
2. temp recs: (select * from PS_AETEMPTBLMGR where PRocess_INSTANCE = 3766254):
PS_INTFC_AP_AM_TAO
PS_VCHR_APAM_TAO1
::::
3. staging recs:
PS_PRE_AM_STG
PS_INTFC_PRE_AM
3. AE control:
PS_AERUNCONTROL
PS_AETEMPTBLMGR
PS_AEREQUESTTBL
4. PRCS:
PSPRCSPARMS
PSPRCSQUE
PSPRCSRQST
5. Message:
PS_MESSAGE_LOG
PS_MESSAGE_LOGPARM
analyze _trc to get the recs used
