KMoody
Member
Progress: 10.2b SP7
OS: SUSE Linux Enterprise Server 11
This is a followup a previous post of mine.
I'm converting our databases to Type II. Our old database preference files used a block size of 20000 and the following data structure:
db.st
d [DIR]/db.d1 f 500000
d [DIR]/db.d2 f 500000
d [DIR]/db.d3 f 500000
d [DIR]/db.d4 f 500000
d [DIR]/db.d5
b [DIR]/db.b1
I've changed the block size to 1000. Here's our new structure file:
db.st
#
b [DIR]/db.b1 #before-image
a [DIR]/db.a1 #after-image
a [DIR]/db.a2
a [DIR]/db.a3
#
d "Schema Area":6,64 [DIR]/db.d1
d "Data Area":7,64,8 [DIR]/db_7.d1
d "AuditData Area":8,64,8 [DIR]/db_8.d1
d "AuditIndex Area":9,64,8 [DIR]/db_9.d1
Before making these changes, I dumped the data. After making these changes, I loaded the data back in.
OS: SUSE Linux Enterprise Server 11
This is a followup a previous post of mine.
I'm converting our databases to Type II. Our old database preference files used a block size of 20000 and the following data structure:
db.st
d [DIR]/db.d1 f 500000
d [DIR]/db.d2 f 500000
d [DIR]/db.d3 f 500000
d [DIR]/db.d4 f 500000
d [DIR]/db.d5
b [DIR]/db.b1
I've changed the block size to 1000. Here's our new structure file:
db.st
#
b [DIR]/db.b1 #before-image
a [DIR]/db.a1 #after-image
a [DIR]/db.a2
a [DIR]/db.a3
#
d "Schema Area":6,64 [DIR]/db.d1
d "Data Area":7,64,8 [DIR]/db_7.d1
d "AuditData Area":8,64,8 [DIR]/db_8.d1
d "AuditIndex Area":9,64,8 [DIR]/db_9.d1
Before making these changes, I dumped the data. After making these changes, I loaded the data back in.
- How can I confirm that my database is Type II after loading?
- How do I ensure that the right information goes to the right .d file? I'm not sure where this should be done during dump and load. Do I need to place the Data Area in a separate directory and move to that directory when loading?
- Do you see any problems with this setup?