Good day,
I tried the prostrct command, and here(SEE BELOW) is what I could get, which helped me alot. I monitored it for the past week or so, and it didnt grow by much.
Now my question is; how can I reduce the size of the extents?
Or can I set the data retention date lower?
Thank you and regards,
Charl
Area Name: Control Area, Type 6, Block Size 1024, Extents 1, Records/Block 32
Ext # 1, Type VARIABLE, Size 32 KByte, Name: /u1/mdsdat/automate.db
Area Name: Primary Recovery Area, Type 3, Block Size 8192, Extents 1
Ext # 1, Type VARIABLE, Size 3712 KByte, Name: /u1/mdsdat/automate.b1
Area Name: Schema Area, Type 6, Block Size 1024, Extents 1, Records/Block 32
Ext # 1, Type VARIABLE, Size 2656 KByte, Name: /u1/mdsdat/automate.d1
Area Name: Index Area, Type 6, Block Size 1024, Extents 1, Records/Block 32
Ext # 1, Type VARIABLE, Size 455776 KByte, Name: /u1/mdsdat/automate_7.d1
Area Name: Data Area, Type 6, Block Size 1024, Extents 1, Records/Block 32
Ext # 1, Type VARIABLE, Size 1315680 KByte, Name: /u1/mdsdat/automate_8.d1
AND
Area Name: Control Area, Type 6, Block Size 1024, Extents 1, Records/Block 32
Ext # 1, Type VARIABLE, Size 32 KByte, Name: /u1/mdstoy/automate.db
Area Name: Primary Recovery Area, Type 3, Block Size 8192, Extents 1
Ext # 1, Type VARIABLE, Size 2688 KByte, Name: /u1/mdstoy/automate.b1
Area Name: Schema Area, Type 6, Block Size 1024, Extents 1, Records/Block 32
Ext # 1, Type VARIABLE, Size 2544 KByte, Name: /u1/mdstoy/automate.d1
Area Name: Index Area, Type 6, Block Size 1024, Extents 1, Records/Block 32
Ext # 1, Type VARIABLE, Size 554688 KByte, Name: /u1/mdstoy/automate_7.d1
Area Name: Data Area, Type 6, Block Size 1024, Extents 1, Records/Block 32
Ext # 1, Type VARIABLE, Size 1627136 KByte, Name: /u1/mdstoy/automate_8.d1
I tried the prostrct command, and here(SEE BELOW) is what I could get, which helped me alot. I monitored it for the past week or so, and it didnt grow by much.
Now my question is; how can I reduce the size of the extents?
Or can I set the data retention date lower?
Thank you and regards,
Charl
Area Name: Control Area, Type 6, Block Size 1024, Extents 1, Records/Block 32
Ext # 1, Type VARIABLE, Size 32 KByte, Name: /u1/mdsdat/automate.db
Area Name: Primary Recovery Area, Type 3, Block Size 8192, Extents 1
Ext # 1, Type VARIABLE, Size 3712 KByte, Name: /u1/mdsdat/automate.b1
Area Name: Schema Area, Type 6, Block Size 1024, Extents 1, Records/Block 32
Ext # 1, Type VARIABLE, Size 2656 KByte, Name: /u1/mdsdat/automate.d1
Area Name: Index Area, Type 6, Block Size 1024, Extents 1, Records/Block 32
Ext # 1, Type VARIABLE, Size 455776 KByte, Name: /u1/mdsdat/automate_7.d1
Area Name: Data Area, Type 6, Block Size 1024, Extents 1, Records/Block 32
Ext # 1, Type VARIABLE, Size 1315680 KByte, Name: /u1/mdsdat/automate_8.d1
AND
Area Name: Control Area, Type 6, Block Size 1024, Extents 1, Records/Block 32
Ext # 1, Type VARIABLE, Size 32 KByte, Name: /u1/mdstoy/automate.db
Area Name: Primary Recovery Area, Type 3, Block Size 8192, Extents 1
Ext # 1, Type VARIABLE, Size 2688 KByte, Name: /u1/mdstoy/automate.b1
Area Name: Schema Area, Type 6, Block Size 1024, Extents 1, Records/Block 32
Ext # 1, Type VARIABLE, Size 2544 KByte, Name: /u1/mdstoy/automate.d1
Area Name: Index Area, Type 6, Block Size 1024, Extents 1, Records/Block 32
Ext # 1, Type VARIABLE, Size 554688 KByte, Name: /u1/mdstoy/automate_7.d1
Area Name: Data Area, Type 6, Block Size 1024, Extents 1, Records/Block 32
Ext # 1, Type VARIABLE, Size 1627136 KByte, Name: /u1/mdstoy/automate_8.d1