RABNSIZE from 3 to 4

system · January 24, 2012, 5:57pm

Hello Fellows,

I would like to know if I can modify the RABNSIZE from 3 to 4 without to define the data base again.
Thanks in advanced

My best Regards,

system · January 24, 2012, 7:54pm

Unfortunately no, ADADEF DEFINE is the only way to change the RABNSIZE.

Best regards,

Wolfgang

system · January 24, 2012, 8:05pm

Wolfgang, Thank you very much indeed!

My best regards,

Kugh · February 22, 2013, 10:43am

Hello,

I just want to confirm the procedure to change the database from 3 to 4 rabn. Is ADADEF the only utility required to perform this exercise or are there other steps that need to be followed except taking the full backup?

Will appreciate your help.

Regards

system · February 25, 2013, 2:35am

Hi Kugh

No, ADADEF is not all you will need. You need to:

use the ADAORD RESTRUCTUREDB utility to offload all of the data to a dataset with ddname DDFILEA
define the database with ADADEF (use OVERWRITE)
put all the data back in using the ADAORD STORE.

Goodluck!
Frances