Skip to Content
0
Jul 16, 2012 at 06:55 PM

Table space requirements and automatic storage

268 Views

I am upgrading my Solution Manager system to version 7.1 using SOLMANUP. During the "Checks phase" I get error messages about increasing tables spaces. I am running DB2 version 9.7.0.3. My tablesspaces are defined as DMS with automatic storage enabled. The SOLMANUP process stopped and generated a DBFPLUSD.RES file that contains errors. I would like to know what needs to be done to resolve these errors. The DBFPLUSD.RES file is show below. I've added comments in red font.

*************************************************************************
INSUFFICIENT FREE SPACE: ERROR> Create tablespace DS4#EL702D with 10230 MB ==> I understand this one - This table does not exist and it needs to be created

INSUFFICIENT FREE SPACE: ERROR> Create tablespace DS4#EL702I with 7490 MB ==> I understand this one - This table does not exist and it needs to be created

*******************************************************************************
*
* all INFO> and/or ERROR> messages for autostorage or auto-resize enabled tablespaces listed below are based on the following information: (if no INFO> or ERROR> message is listed sufficient free space exists)
*
* TABLESPACE FREE NEEDED IN_MOUNT_CONTAINING_FILE

* NAME MB MB
* ====================================================================================
* DS4#BTABD 2440 1440 /db2/DS4/sapdata1/db2ds4/NODE0000/DS4/T0000012/C0000000.LRG <== What does this mean ? Won't automatic storage resolve

* 2440 /db2/DS4/sapdata2/db2ds4/NODE0000/DS4/T0000012/C0000001.LRG this type of issue?
* 2440 /db2/DS4/sapdata3/db2ds4/NODE0000/DS4/T0000012/C0000002.LRG
* 2440 /db2/DS4/sapdata4/db2ds4/NODE0000/DS4/T0000012/C0000003.LRG
* 2440 /db2/DS4/sapdata5/db2ds4/NODE0000/DS4/T0000012/C0000004.LRG
* 2440 /db2/DS4/sapdata6/db2ds4/NODE0000/DS4/T0000012/C0000005.LRG
* 2440 /db2/DS4/sapdata7/db2ds4/NODE0000/DS4/T0000012/C0000006.LRG
* 2440 /db2/DS4/sapdata8/db2ds4/NODE0000/DS4/T0000012/C0000007.LRG
* 2440 /db2/DS4/sapdata9/db2ds4/NODE0000/DS4/T0000012/C0000008.LRG
* DS4#BTABI 2440 300 /db2/DS4/sapdata1/db2ds4/NODE0000/DS4/T0000012/C0000000.LRG
* 2440 /db2/DS4/sapdata2/db2ds4/NODE0000/DS4/T0000012/C0000001.LRG
* 2440 /db2/DS4/sapdata3/db2ds4/NODE0000/DS4/T0000012/C0000002.LRG
* 2440 /db2/DS4/sapdata4/db2ds4/NODE0000/DS4/T0000012/C0000003.LRG
* 2440 /db2/DS4/sapdata5/db2ds4/NODE0000/DS4/T0000012/C0000004.LRG
* 2440 /db2/DS4/sapdata6/db2ds4/NODE0000/DS4/T0000012/C0000005.LRG
* 2440 /db2/DS4/sapdata7/db2ds4/NODE0000/DS4/T0000012/C0000006.LRG
* 2440 /db2/DS4/sapdata8/db2ds4/NODE0000/DS4/T0000012/C0000007.LRG
* 2440 /db2/DS4/sapdata9/db2ds4/NODE0000/DS4/T0000012/C0000008.LRG
* DS4#DDICD 2440 1550 /db2/DS4/sapdata1/db2ds4/NODE0000/DS4/T0000012/C0000000.LRG
* 2440 /db2/DS4/sapdata2/db2ds4/NODE0000/DS4/T0000012/C0000001.LRG
* 2440 /db2/DS4/sapdata3/db2ds4/NODE0000/DS4/T0000012/C0000002.LRG
* 2440 /db2/DS4/sapdata4/db2ds4/NODE0000/DS4/T0000012/C0000003.LRG
* 2440 /db2/DS4/sapdata5/db2ds4/NODE0000/DS4/T0000012/C0000004.LRG
* 2440 /db2/DS4/sapdata6/db2ds4/NODE0000/DS4/T0000012/C0000005.LRG
* 2440 /db2/DS4/sapdata7/db2ds4/NODE0000/DS4/T0000012/C0000006.LRG
* 2440 /db2/DS4/sapdata8/db2ds4/NODE0000/DS4/T0000012/C0000007.LRG
* 2440 /db2/DS4/sapdata9/db2ds4/NODE0000/DS4/T0000012/C0000008.LRG
* DS4#DDICI 2440 730 /db2/DS4/sapdata1/db2ds4/NODE0000/DS4/T0000012/C0000000.LRG
* 2440 /db2/DS4/sapdata2/db2ds4/NODE0000/DS4/T0000012/C0000001.LRG
* 2440 /db2/DS4/sapdata3/db2ds4/NODE0000/DS4/T0000012/C0000002.LRG
* 2440 /db2/DS4/sapdata4/db2ds4/NODE0000/DS4/T0000012/C0000003.LRG
* 2440 /db2/DS4/sapdata5/db2ds4/NODE0000/DS4/T0000012/C0000004.LRG
* 2440 /db2/DS4/sapdata6/db2ds4/NODE0000/DS4/T0000012/C0000005.LRG
* 2440 /db2/DS4/sapdata7/db2ds4/NODE0000/DS4/T0000012/C0000006.LRG
* 2440 /db2/DS4/sapdata8/db2ds4/NODE0000/DS4/T0000012/C0000007.LRG
* 2440 /db2/DS4/sapdata9/db2ds4/NODE0000/DS4/T0000012/C0000008.LRG
* DS4#DOCUD 2440 130 /db2/DS4/sapdata1/db2ds4/NODE0000/DS4/T0000012/C0000000.LRG
* 2440 /db2/DS4/sapdata2/db2ds4/NODE0000/DS4/T0000012/C0000001.LRG
* 2440 /db2/DS4/sapdata3/db2ds4/NODE0000/DS4/T0000012/C0000002.LRG
* 2440 /db2/DS4/sapdata4/db2ds4/NODE0000/DS4/T0000012/C0000003.LRG
* 2440 /db2/DS4/sapdata5/db2ds4/NODE0000/DS4/T0000012/C0000004.LRG
* 2440 /db2/DS4/sapdata6/db2ds4/NODE0000/DS4/T0000012/C0000005.LRG
* 2440 /db2/DS4/sapdata7/db2ds4/NODE0000/DS4/T0000012/C0000006.LRG
* 2440 /db2/DS4/sapdata8/db2ds4/NODE0000/DS4/T0000012/C0000007.LRG
* 2440 /db2/DS4/sapdata9/db2ds4/NODE0000/DS4/T0000012/C0000008.LRG
* DS4#DOCUI 2440 50 /db2/DS4/sapdata1/db2ds4/NODE0000/DS4/T0000012/C0000000.LRG
* 2440 /db2/DS4/sapdata2/db2ds4/NODE0000/DS4/T0000012/C0000001.LRG
* 2440 /db2/DS4/sapdata3/db2ds4/NODE0000/DS4/T0000012/C0000002.LRG
* 2440 /db2/DS4/sapdata4/db2ds4/NODE0000/DS4/T0000012/C0000003.LRG
* 2440 /db2/DS4/sapdata5/db2ds4/NODE0000/DS4/T0000012/C0000004.LRG
* 2440 /db2/DS4/sapdata6/db2ds4/NODE0000/DS4/T0000012/C0000005.LRG
* 2440 /db2/DS4/sapdata7/db2ds4/NODE0000/DS4/T0000012/C0000006.LRG
* 2440 /db2/DS4/sapdata8/db2ds4/NODE0000/DS4/T0000012/C0000007.LRG
* 2440 /db2/DS4/sapdata9/db2ds4/NODE0000/DS4/T0000012/C0000008.LRG
* DS4#LOADD 2440 12050 /db2/DS4/sapdata1/db2ds4/NODE0000/DS4/T0000012/C0000000.LRG
* 2440 /db2/DS4/sapdata2/db2ds4/NODE0000/DS4/T0000012/C0000001.LRG
* 2440 /db2/DS4/sapdata3/db2ds4/NODE0000/DS4/T0000012/C0000002.LRG
* 2440 /db2/DS4/sapdata4/db2ds4/NODE0000/DS4/T0000012/C0000003.LRG
* 2440 /db2/DS4/sapdata5/db2ds4/NODE0000/DS4/T0000012/C0000004.LRG
* 2440 /db2/DS4/sapdata6/db2ds4/NODE0000/DS4/T0000012/C0000005.LRG
* 2440 /db2/DS4/sapdata7/db2ds4/NODE0000/DS4/T0000012/C0000006.LRG
* 2440 /db2/DS4/sapdata8/db2ds4/NODE0000/DS4/T0000012/C0000007.LRG
* 2440 /db2/DS4/sapdata9/db2ds4/NODE0000/DS4/T0000012/C0000008.LRG
* DS4#LOADI 2440 6020 /db2/DS4/sapdata1/db2ds4/NODE0000/DS4/T0000012/C0000000.LRG
* 2440 /db2/DS4/sapdata2/db2ds4/NODE0000/DS4/T0000012/C0000001.LRG
* 2440 /db2/DS4/sapdata3/db2ds4/NODE0000/DS4/T0000012/C0000002.LRG
* 2440 /db2/DS4/sapdata4/db2ds4/NODE0000/DS4/T0000012/C0000003.LRG
* 2440 /db2/DS4/sapdata5/db2ds4/NODE0000/DS4/T0000012/C0000004.LRG
* 2440 /db2/DS4/sapdata6/db2ds4/NODE0000/DS4/T0000012/C0000005.LRG
* 2440 /db2/DS4/sapdata7/db2ds4/NODE0000/DS4/T0000012/C0000006.LRG
* 2440 /db2/DS4/sapdata8/db2ds4/NODE0000/DS4/T0000012/C0000007.LRG
* 2440 /db2/DS4/sapdata9/db2ds4/NODE0000/DS4/T0000012/C0000008.LRG
* DS4#POOLD 2440 2220 /db2/DS4/sapdata1/db2ds4/NODE0000/DS4/T0000012/C0000000.LRG
* 2440 /db2/DS4/sapdata2/db2ds4/NODE0000/DS4/T0000012/C0000001.LRG
* 2440 /db2/DS4/sapdata3/db2ds4/NODE0000/DS4/T0000012/C0000002.LRG
* 2440 /db2/DS4/sapdata4/db2ds4/NODE0000/DS4/T0000012/C0000003.LRG
* 2440 /db2/DS4/sapdata5/db2ds4/NODE0000/DS4/T0000012/C0000004.LRG
* 2440 /db2/DS4/sapdata6/db2ds4/NODE0000/DS4/T0000012/C0000005.LRG
* 2440 /db2/DS4/sapdata7/db2ds4/NODE0000/DS4/T0000012/C0000006.LRG
* 2440 /db2/DS4/sapdata8/db2ds4/NODE0000/DS4/T0000012/C0000007.LRG
* 2440 /db2/DS4/sapdata9/db2ds4/NODE0000/DS4/T0000012/C0000008.LRG
* DS4#POOLI 2440 700 /db2/DS4/sapdata1/db2ds4/NODE0000/DS4/T0000012/C0000000.LRG
* 2440 /db2/DS4/sapdata2/db2ds4/NODE0000/DS4/T0000012/C0000001.LRG
* 2440 /db2/DS4/sapdata3/db2ds4/NODE0000/DS4/T0000012/C0000002.LRG
* 2440 /db2/DS4/sapdata4/db2ds4/NODE0000/DS4/T0000012/C0000003.LRG
* 2440 /db2/DS4/sapdata5/db2ds4/NODE0000/DS4/T0000012/C0000004.LRG
* 2440 /db2/DS4/sapdata6/db2ds4/NODE0000/DS4/T0000012/C0000005.LRG
* 2440 /db2/DS4/sapdata7/db2ds4/NODE0000/DS4/T0000012/C0000006.LRG
* 2440 /db2/DS4/sapdata8/db2ds4/NODE0000/DS4/T0000012/C0000007.LRG
* 2440 /db2/DS4/sapdata9/db2ds4/NODE0000/DS4/T0000012/C0000008.LRG
* DS4#PROTD 2440 150 /db2/DS4/sapdata1/db2ds4/NODE0000/DS4/T0000012/C0000000.LRG
* 2440 /db2/DS4/sapdata2/db2ds4/NODE0000/DS4/T0000012/C0000001.LRG
* 2440 /db2/DS4/sapdata3/db2ds4/NODE0000/DS4/T0000012/C0000002.LRG
* 2440 /db2/DS4/sapdata4/db2ds4/NODE0000/DS4/T0000012/C0000003.LRG
* 2440 /db2/DS4/sapdata5/db2ds4/NODE0000/DS4/T0000012/C0000004.LRG
* 2440 /db2/DS4/sapdata6/db2ds4/NODE0000/DS4/T0000012/C0000005.LRG
* 2440 /db2/DS4/sapdata7/db2ds4/NODE0000/DS4/T0000012/C0000006.LRG
* 2440 /db2/DS4/sapdata8/db2ds4/NODE0000/DS4/T0000012/C0000007.LRG
* 2440 /db2/DS4/sapdata9/db2ds4/NODE0000/DS4/T0000012/C0000008.LRG
* DS4#PROTI 2440 60 /db2/DS4/sapdata1/db2ds4/NODE0000/DS4/T0000012/C0000000.LRG
* 2440 /db2/DS4/sapdata2/db2ds4/NODE0000/DS4/T0000012/C0000001.LRG
* 2440 /db2/DS4/sapdata3/db2ds4/NODE0000/DS4/T0000012/C0000002.LRG
* 2440 /db2/DS4/sapdata4/db2ds4/NODE0000/DS4/T0000012/C0000003.LRG
* 2440 /db2/DS4/sapdata5/db2ds4/NODE0000/DS4/T0000012/C0000004.LRG
* 2440 /db2/DS4/sapdata6/db2ds4/NODE0000/DS4/T0000012/C0000005.LRG
* 2440 /db2/DS4/sapdata7/db2ds4/NODE0000/DS4/T0000012/C0000006.LRG
* 2440 /db2/DS4/sapdata8/db2ds4/NODE0000/DS4/T0000012/C0000007.LRG
* 2440 /db2/DS4/sapdata9/db2ds4/NODE0000/DS4/T0000012/C0000008.LRG
* DS4#SOURCED 2440 440 /db2/DS4/sapdata1/db2ds4/NODE0000/DS4/T0000012/C0000000.LRG
* 2440 /db2/DS4/sapdata2/db2ds4/NODE0000/DS4/T0000012/C0000001.LRG
* 2440 /db2/DS4/sapdata3/db2ds4/NODE0000/DS4/T0000012/C0000002.LRG
* 2440 /db2/DS4/sapdata4/db2ds4/NODE0000/DS4/T0000012/C0000003.LRG
* 2440 /db2/DS4/sapdata5/db2ds4/NODE0000/DS4/T0000012/C0000004.LRG
* 2440 /db2/DS4/sapdata6/db2ds4/NODE0000/DS4/T0000012/C0000005.LRG
* 2440 /db2/DS4/sapdata7/db2ds4/NODE0000/DS4/T0000012/C0000006.LRG
* 2440 /db2/DS4/sapdata8/db2ds4/NODE0000/DS4/T0000012/C0000007.LRG
* 2440 /db2/DS4/sapdata9/db2ds4/NODE0000/DS4/T0000012/C0000008.LRG
* DS4#SOURCEI 2440 160 /db2/DS4/sapdata1/db2ds4/NODE0000/DS4/T0000012/C0000000.LRG
* 2440 /db2/DS4/sapdata2/db2ds4/NODE0000/DS4/T0000012/C0000001.LRG
* 2440 /db2/DS4/sapdata3/db2ds4/NODE0000/DS4/T0000012/C0000002.LRG
* 2440 /db2/DS4/sapdata4/db2ds4/NODE0000/DS4/T0000012/C0000003.LRG
* 2440 /db2/DS4/sapdata5/db2ds4/NODE0000/DS4/T0000012/C0000004.LRG
* 2440 /db2/DS4/sapdata6/db2ds4/NODE0000/DS4/T0000012/C0000005.LRG
* 2440 /db2/DS4/sapdata7/db2ds4/NODE0000/DS4/T0000012/C0000006.LRG
* 2440 /db2/DS4/sapdata8/db2ds4/NODE0000/DS4/T0000012/C0000007.LRG
* 2440 /db2/DS4/sapdata9/db2ds4/NODE0000/DS4/T0000012/C0000008.LRG
* DS4#STABD 2440 3400 /db2/DS4/sapdata1/db2ds4/NODE0000/DS4/T0000012/C0000000.LRG
* 2440 /db2/DS4/sapdata2/db2ds4/NODE0000/DS4/T0000012/C0000001.LRG
* 2440 /db2/DS4/sapdata3/db2ds4/NODE0000/DS4/T0000012/C0000002.LRG
* 2440 /db2/DS4/sapdata4/db2ds4/NODE0000/DS4/T0000012/C0000003.LRG
* 2440 /db2/DS4/sapdata5/db2ds4/NODE0000/DS4/T0000012/C0000004.LRG
* 2440 /db2/DS4/sapdata6/db2ds4/NODE0000/DS4/T0000012/C0000005.LRG
* 2440 /db2/DS4/sapdata7/db2ds4/NODE0000/DS4/T0000012/C0000006.LRG
* 2440 /db2/DS4/sapdata8/db2ds4/NODE0000/DS4/T0000012/C0000007.LRG
* 2440 /db2/DS4/sapdata9/db2ds4/NODE0000/DS4/T0000012/C0000008.LRG
* DS4#STABI 2440 850 /db2/DS4/sapdata1/db2ds4/NODE0000/DS4/T0000012/C0000000.LRG
* 2440 /db2/DS4/sapdata2/db2ds4/NODE0000/DS4/T0000012/C0000001.LRG
* 2440 /db2/DS4/sapdata3/db2ds4/NODE0000/DS4/T0000012/C0000002.LRG
* 2440 /db2/DS4/sapdata4/db2ds4/NODE0000/DS4/T0000012/C0000003.LRG
* 2440 /db2/DS4/sapdata5/db2ds4/NODE0000/DS4/T0000012/C0000004.LRG
* 2440 /db2/DS4/sapdata6/db2ds4/NODE0000/DS4/T0000012/C0000005.LRG
* 2440 /db2/DS4/sapdata7/db2ds4/NODE0000/DS4/T0000012/C0000006.LRG
* 2440 /db2/DS4/sapdata8/db2ds4/NODE0000/DS4/T0000012/C0000007.LRG
* 2440 /db2/DS4/sapdata9/db2ds4/NODE0000/DS4/T0000012/C0000008.LRG
* SYSCATSPACE 2440 560 /db2/DS4/sapdata1/db2ds4/NODE0000/DS4/T0000012/C0000000.LRG
* 2440 /db2/DS4/sapdata2/db2ds4/NODE0000/DS4/T0000012/C0000001.LRG
* 2440 /db2/DS4/sapdata3/db2ds4/NODE0000/DS4/T0000012/C0000002.LRG
* 2440 /db2/DS4/sapdata4/db2ds4/NODE0000/DS4/T0000012/C0000003.LRG
* 2440 /db2/DS4/sapdata5/db2ds4/NODE0000/DS4/T0000012/C0000004.LRG
* 2440 /db2/DS4/sapdata6/db2ds4/NODE0000/DS4/T0000012/C0000005.LRG
* 2440 /db2/DS4/sapdata7/db2ds4/NODE0000/DS4/T0000012/C0000006.LRG
* 2440 /db2/DS4/sapdata8/db2ds4/NODE0000/DS4/T0000012/C0000007.LRG
* 2440 /db2/DS4/sapdata9/db2ds4/NODE0000/DS4/T0000012/C0000008.LRG
* =============================================================================
*
*******************************************************************************

INSUFFICIENT FREE SPACE: ERROR> Extend file systems containing

/db2/DS4/sapdata1/db2ds4/NODE0000/DS4/T0000012/C0000000.LRG

/db2/DS4/sapdata2/db2ds4/NODE0000/DS4/T0000012/C0000001.LRG

/db2/DS4/sapdata3/db2ds4/NODE0000/DS4/T0000012/C0000002.LRG

/db2/DS4/sapdata4/db2ds4/NODE0000/DS4/T0000012/C0000003.LRG

/db2/DS4/sapdata5/db2ds4/NODE0000/DS4/T0000012/C0000004.LRG

/db2/DS4/sapdata6/db2ds4/NODE0000/DS4/T0000012/C0000005.LRG

/db2/DS4/sapdata7/db2ds4/NODE0000/DS4/T0000012/C0000006.LRG

/db2/DS4/sapdata8/db2ds4/NODE0000/DS4/T0000012/C0000007.LRG

/db2/DS4/sapdata9/db2ds4/NODE0000/DS4/T0000012/C0000008.LRG IN TOTAL by at least 8850 MB <== Does this means I need to add 8850Mb to each file system

<== Or add 1000Mb to each of the 9 file system?

INSUFFICIENT FREE SPACE: ERROR> Extend all storage paths of your database by at least 26579 <== How is this different from the error above (other than the size requirement)?