First timer in IBM for i: Disable transactional log for SP Stack update?

[martimmendes]

Dear Experts,

    As the tittle says, i am a first timer on this platform (already posted some threads), like in MaxDB, Oracle and SQL, is there any transactional log i should change or disable before updating SAP Support Packages? If so, how and where should i do it?

This is kinda urgente, since i will need to do this in about 5 to 6 hours.

Thanks in advance for you kind responses.

Best regards,

Martim

[Sriram2009 · Accepted solution]

Hi Martim

I think it's not possible to disable the transaction log (On IBM i transaction log = journal receiver)in IBM i system. During the upgrade you have to keep eye on journal receivers. before starting the upgrade clear the Sql package and check the Spool DB inconsistency check by using transaction SPAD.

BR

SS

[martimmendes]

Thank you very much and S Sriram

[volker_gldenpfennig]

Hi Martim,

you can change the journal receivers to autodelete with CHGJRN r3siddata/qsqjrn

This only works fine, when only one receiver is attached.

Regards,

Volker Gueldenpfennig, consolut international ag