MVSFORUMS.com

[Daya]

Dear Experts,
In our shop we are using DB2 V6.1 with dual logging facility, I recently added an extra active log dataset to increase the number of log datasets.
The problem here is the offload task is not happening automatically for example after using the 4th log datasets, db2 simply starts using the first log dataset and re-writing the same, its not requesting the operator for any tapes, I can very well use the -ARC LOG command, but normally it will request the operator to put tapes to finish the offload task which is not happening.

1) Should I manually start the offload task for first time or
2) should I change any parameter in DSNZPARM member

Please help me!!

Daya

[kolusu]

Daya,

When DB2 is initialized, the active log data sets named in the BSDS are dynamically allocated for exclusive use by DB2 and remain allocated exclusively to DB2 (the data sets were allocated as DISP=OLD) until DB2 terminates.Those active log data sets cannot be replaced, nor can new ones be added, without terminating and restarting DB2. The size and number of log data sets is indicated by what was specified by installation panel DSNTIPL.

So follow these steps to add new active log datasets.

Use DSNJLOGF to preformat the new active log data sets.

Use DSNJU003 to register the new data sets in the BSDS.

Kolusu

Hope this helps...

cheers

kolusu

[Daya]

Hi Kolusu,

I clearly understood your explanation, as i already said I have no problem in adding fourth active log datasets, but normally db2 should go for offloading task right after all its active log dataset get full it should switch over to offloading archive log datasets right?? that switch over task of offloading is not happening in my shop, i tried manually to offload the log it happens, but my question is what should be enable to activate the auto offloading task of archive when all active log datasets get full.

Hope i am clear

Daya