SQL7008 after terminating ENDJRNPF process

[Former Member]

Hi All,

I'm a newbie in DB2. In an attempt to disable journaling to prepare for a client copy, I executed:

ENDJRNPF FILE(R3<SID>DATA/<file name>) JRN(*FILE)

However the process took a long time, so I kill the pid for ENDJRNPF.

Now I'm getting SQL7008 abap dumps indicating some tables are not journaled. It is difficult to tell which table is not journaled unless an abap dump is triggered whenever certain SAP transaction is run. When I manage to identify certain tables, I would enable journaling for them and the SAP transaction will work again.

Is it possible to use AS4FIXFILE command to enable journaling for all tables to resolve my issue? Would there be any impact to tables that already have their journaling turned on if I use the AS4FIXFILE command?

Rdgs,

WS Lim

[Former Member]

Hi Lim,

as you are turning off the journaling, the system is unsable as commit control can no longer work ;-((((

=> you need to turn on journaling again - and if you like, set the journal receivers to *AUTODELETE ...

Regards

Volker Gueldenpfennig, consolut international ag

http://www.consolut.com http://www.4soi.de http://www.easymarketplace.de

[Former Member]

Hi Volker,

Thanks for the advice. I know I need to turn on journaling again, but is there a faster way to turn on journaling for tables with missing journal instead of turning them one by one?

Rdgs,

Lim

[Former Member]

Hi Lim,

no, you have to use as4fixfile again ...

Regards

Volker Gueldenpfennig, consolut international ag

http://www.consolut.com http://www.4soi.de http://www.easymarketplace.de

[Former Member]

Hi Volker,

Can I submit ASFIXFILE as a background job like this:

SBMJOB CMD(AS4FIXFILE DBLIB(R3<SID>DATA) CHGOWN(YES) ENDJRN(YES) STRJRN(*YES)) JOB(AS4FIXFILE)

Rdgs,

Lim

[Former Member]

Hi Lim,

that's what I do ...

Regards

Volker Gueldenpfennig, consolut international ag

http://www.consolut.com http://www.4soi.de http://www.easymarketplace.de

[Former Member]

Hi Volker,

I tried running AS4FIXFILE as a background job but the tables remain unjournaled. Is it because I run the program with SIDADM instead of QSECOFR account?

Rdgs,

Lim

Edited by: limws1 on Nov 9, 2010 7:52 AM

[Former Member]

Hi Lim,

Please check note 1387754

Best Regards,

[Former Member]

Hi Volker,

I patch the AS4FIXFILE program to the latest ILE kernel 116. The program is still not having any effect on the journaling. Worst, now the new program give me zero runtime after submitting the job. The previous version still is able to run for an hour or so. There is no joblog to refer to for AS4FIXFILE, so I don't know what is the problem here. Hope you can help.

Rdgs,

Lim

[Former Member]

Hi Lim,

so, you want to tell me, that the old AS4FIXFILE and the new AS$FIXFILE do not work on your DB ? (for strjrnpf)

... and you are sure, to have remove the following dtaara already ?

DLTDTAARA R3<sid>DATA/QDFTJRN

(if it has the wrong contents it kills you ...)

I cannot believe that ...

Regards

Volker Gueldenpfennig, consolut international ag

http://www.consolut.com http://www.4soi.de http://www.easymarketplace.de

[Former Member]

Dear Lim,

Did you use the modified command from note 1387754? It's necessary to add the parameter CHGFILE(YES), so the command should be: AS4FIXFILE DBLIB(<lib>) ENDJRN(YES) STRJRN(YES) CHGFILE(YES)

Regards,

Sally Power

Development Support for SAP on IBM i

[Former Member]

Hi Volker,

Yes both version of AS4FIXFILE don't start journaling for my tables.

Sorry, what is this 'remove data area'? So far, I didn't read anything about this step in any of the oss notes.

[Former Member]

Hi Sally,

Yes I did use the CHGFILE(*YES) option. AS4FIXFILE doesn't seem to run after I patched it.

In the end, I just use STRJRNPF FILE(R3<SID>DATA/ALL) JRN(R3<SID>DATA/QSQJRN) IMAGES(BOTH) OMTJRNE(*OPNCLO) to startup all my tables and it seems to work cause I don't get abap dump anymore.

I also need to highlight that I didn't apply the full ILE kernel. Instead, I follow the steps from note 1296624 and just replace APYR3FIX with AS4FIXFILE so that I can have the latest AS4FIXFILE from ILE 116.

Rdgs,

Lim