1827671 Members
3419 Online
109967 Solutions
New Discussion

Extending AIJ files

 
Jim Lahman_1
Advisor

Extending AIJ files

Last year, I created an Rdb database with 14 after-image journal (AIJ) files whose sizes are 500 blocks apiece. Now, I need to make these AIJ files larger?

Can I just extend the existing AIJ files are do I need to recreate new AIJ files?

Attached is the command I used to create the AIJ files.

Thanks, Jim
Cheers!
5 REPLIES 5
Hoff
Honored Contributor

Re: Extending AIJ files

The versions of Rdb I've seen can use multiple static-sized files, or can use an extensible AIJ file. I've tended to use the extensible AIJ file, and to add and drop and cycle through additional AIJ files as and when needed.

While you're at it, I'd look at what disk activity was present, and quite possibly at spreading the database files (RDA and RDB, SNP, AIJ, etc) around, and onto different disk spindles, too. Where this can be reasonably managed.

It would not surprise me that you could perform this change-over entirely on-line and entirely safely, but I've tended to be paranoid when working with the local databases and have quiesced and performed an RMU BACKUP of before hacking around inside RMU or SQL. And only then after practicing on another testing database. Paranoid? Me?

Check the Rdb manuals for details.

Stephen Hoffman
HoffmanLabs
Karl Rohwedder
Honored Contributor

Re: Extending AIJ files

If the AIJ files are static (and switched in a round robin fashion by RDB), they cannot be enlarged on the fly. You may add addtional AIJ files online, if there a free slots in the database (check with RMU/DUMP/HEADER).

To make the space inside the AIJ files available again, you should perform an AIJ backup (using RMU), This AIJ backup can be made automatic, so the whole AIJ handling becomes transparent). For help see HELP RMU.

The RMU/SHO STAT has some nice AIJ displays also.

regards Kalle
Jim Lahman_1
Advisor

Re: Extending AIJ files

Yes, I have the .SNP files on its own RAID, the RDB and RDA files on another RAID and the AIJ, AIJBCK files on a third raid.

I have four available AIJ slots.

Jim
Cheers!
Jan van den Ende
Honored Contributor

Re: Extending AIJ files

Jim,

on issues like this, I tend to look at the Oracle site first.
Although Rdb ( & DBMS) info can be relatively hidden (sounds familiar, considering VMS at HP site, eh?)

hth

Proost.

Have one on me.

jpe
Don't rust yours pelled jacker to fine doll missed aches.
Jeff Bath
Advisor

Re: Extending AIJ files

Jim,

Since you have 4 available slots you can add 4 more journals of whatever size you like. For the existing journals if they are backed up and are not the current journal you can drop them and add new ones of the appropriate sizes. To switch from the current active journal (so you can back it up and drop it to create a larger one) you would issue rmu/set after_journal/switch db-name.

You can use rmu and/or sql to add and drop aijs.

Jeff