Skip to Content
0
Aug 08, 2015 at 06:01 PM

Insufficient free space in the database during ERP6 upgrade in checks phase

297 Views

Dear Experts,

We are upgrading R/3 4.7 system to ECC6.0 EHP7, stuck with an error at the CHECKS phase. OS is AIX 6.1 & DAtabase is DB2 9.7 FP10. Got below error message in Checks phase.

ERROR: Insufficient free space in the database as follows. Please refer to file /usr/sap/OS2/SUM/abap/log/DBFPLUSD.RES for more details and additional information about the results of the free space check.

ERROR: Extend file systems containing/db2/OS2/sapdata1/NODE0000/OP2#BTABD.container000 /db2/OS2/sapdata2/NODE0000/OP2#BTABD.container001 /db2/OS2/sapdata3/NODE0000/OP2#BTABD.container002 /db2/OS2/sapdata4/NODE0000/OP2#BTABD.container003 /db2/OS2/sapdata5/NODE0000/OP2#BTABD.container004 /db2/OS2/sapdata1/NODE0000/OP2#BTABD.container000 /db2/OS2/sapdata2/NODE0000/OP2#BTABD.container001 /db2/OS2/sapdata3/NODE0000/OP2#BTABD.container002 /db2/OS2/sapdata4/NODE0000/OP2#BTABD.container003 /db2/OS2/sapdata5/NODE0000/OP2#BTABD.container004 /db2/OS2/sapdata5/NODE0000/OP2#BTABD.container004 /db2/OS2/sapdata5/NODE0000/OP2#BTABD.container004 /db2/OS2/sapdata1/NODE0000/OP2#BTABD.container000 /db2/OS2/sapdata2/NODE0000/OP2#BTABD.container001 /db2/OS2/sapdata3/NODE0000/OP2#BTABD.container002 /db2/OS2/sapdata4/NODE0000/OP2#BTABD.container003 /db2/OS2/sapdata4/NODE0000/OP2#BTABD.container003 /db2/OS2/sapdata5/NODE0000/OP2#BTABD.container004 /db2/OS2/sapdata5/NODE0000/OP2#BTABD.container004 /db2/OS2/sapdata3/NODE0000/OP2#BTABD.container002 /db2/OS2/sapdata1/NODE0000/OP2#BTABD.container000 /db2/OS2/sapdata1/NODE0000/OP2#BTABD.container000 /db2/OS2/sapdata2/NODE0000/OP2#BTABD.container001 /db2/OS2/sapdata5/NODE0000/OP2#BTABD.container004 /db2/OS2/sapdata5/NODE0000/OP2#BTABD.container004 /db2/OS2/sapdata1/NODE0000/OP2#BTABD.container000 /db2/OS2/sapdata2/NODE0000/OP2#BTABD.container001 /db2/OS2/sapdata3/NODE0000/OP2#BTABD.container002 /db2/OS2/sapdata4/NODE0000/OP2#BTABD.container003 /db2/OS2/sapdata5/NODE0000/OP2#BTABD.container004 /db2/OS2/sapdata1/NODE0000/OP2#BTABD.container000 /db2/OS2/sapdata2/NODE0000/OP2#BTABD.container001 /db2/OS2/sapdata3/NODE0000/OP2#BTABD.container002 /db2/OS2/sapdata4/NODE0000/OP2#BTABD.container003 /db2/OS2/sapdata5/NODE0000/OP2#BTABD.container004 /db2/OS2/sapdata1/NODE0000/OP2#BTABD.container000 /db2/OS2/sapdata2/NODE0000/OP2#BTABD.container001 /db2/OS2/sapdata3/NODE0000/OP2#BTABD.container002 /db2/OS2/sapdata4/NODE0000/OP2#BTABD.container003 /db2/OS2/sapdata5/NODE0000/OP2#BTABD.container004 /db2/OS2/sapdata4/NODE0000/OP2#BTABD.container003 /db2/OS2/sapdata3/NODE0000/OP2#BTABD.container002 /db2/OS2/sapdata4/NODE0000/OP2#BTABD.container003 /db2/OS2/sapdata1/NODE0000/OP2#BTABD.container000 /db2/OS2/sapdata2/NODE0000/OP2#BTABD.container001 /db2/OS2/sapdata3/NODE0000/OP2#BTABD.container002 /db2/OS2/sapdata4/NODE0000/OP2#BTABD.container003 /db2/OS2/sapdata5/NODE0000/OP2#BTABD.container004 /db2/OS2/sapdata1/NODE0000/OP2#BTABD.container000 /db2/OS2/sapdata2/NODE0000/OP2#BTABD.container001 /db2/OS2/sapdata3/NODE0000/OP2#BTABD.container002 /db2/OS2/sapdata4/NODE0000/OP2#BTABD.container003 /db2/OS2/sapdata5/NODE0000/OP2#BTABD.container004 /db2/OS2/sapdata4/NODE0000/OP2#BTABD.container003 /db2/OS2/sapdata4/NODE0000/OP2#BTABD.container003 /db2/OS2/sapdata1/NODE0000/OP2#BTABD.container000

ERROR: to fulfil the following free space requirements:

ERROR: OP2#BTABD : 0 (MB)

ERROR: OP2#BTABI : 2510 (MB)

ERROR: OP2#CLUD : 0 (MB)

ERROR: OP2#CLUI : 0 (MB)

ERROR: OP2#DDICD : 3250 (MB)

ERROR: OP2#DDICI : 1450 (MB)

ERROR: OP2#DOCUD : 50 (MB)

ERROR: OP2#DOCUI : 30 (MB)

ERROR: OP2#EL740D : 0 (MB)

ERROR: OP2#EL740I : 0 (MB)

ERROR: OP2#ES740D : 0 (MB)

ERROR: OP2#ES740I : 0 (MB)

ERROR: OP2#LOADD : 70 (MB)

ERROR: OP2#LOADI : 0 (MB)

ERROR: OP2#POOLD : 4700 (MB)

ERROR: OP2#POOLI : 3090 (MB)

ERROR: OP2#PROTD : 0 (MB)

ERROR: OP2#PROTI : 0 (MB)

ERROR: OP2#SOURCED : 2700 (MB)

ERROR: OP2#SOURCEI : 230 (MB)

ERROR: OP2#STABD : 4890 (MB)

ERROR: OP2#STABI : 4900 (MB)

ERROR: OP2#USER1D : 1500 (MB)

ERROR: OP2#USER1I : 1510 (MB)

ERROR: SYSCATSPACE : 5300 (MB)

ERROR: the minimum extension size for the listed file systems can in general not be determined exactly.

ERROR: the following maximum extensions fulfil the requirements but may include large overhead:

ERROR: MAX: extend file system containing /db2/OS2/sapdata2/NODE0000/OP2#BTABD.container001 by 10835 MB

ERROR: MAX: extend file system containing /db2/OS2/sapdata3/NODE0000/OP2#BTABD.container002 by 14320 MB

ERROR: MAX: extend file system containing /db2/OS2/sapdata4/NODE0000/OP2#BTABD.container003 by 7966 MB

You must fulfill these requirements first before you continue with the procedure!

We have enough space in the respective file systems. We ran the script /usr/sap/OS2/SUM/abap/log/DB6TBSXT.CLt as mentioned in the log /usr/sap/OS2/SUM/abap/log/DBFPLUSD.RES

Filesystem GB blocks Free %Used Iused %Iused Mounted on

/dev/OS2_sapdata1_lv 100.00 32.41 68% 29 1% /db2/OS2/sapdata1

/dev/OS2_sapdata2_lv 70.00 12.21 83% 32 1% /db2/OS2/sapdata2

/dev/OS2_sapdata3_lv 70.00 11.45 84% 24 1% /db2/OS2/sapdata3

/dev/OS2_sapdata4_lv 60.00 19.59 68% 52 1% /db2/OS2/sapdata4

/dev/OS2_sapdata5_lv 60.00 20.19 67% 47 1% /db2/OS2/sapdata5

Here is the log DBFPLUSD.RES

*************************************************************************

*

* DB2 UDB for Unix, Windows (DB6)

* Comparing Free Space Requirements of SAPup

* with Free Space on Database

*

* THIS FILE CONTAINS INFO- AND ERROR-MESSAGES ONLY!

* TABLESPACES OR FILE SYSTEMS WITH ENOUGH FREE SPACE ARE NOT LISTED HERE!

*

* Messages and actions listed in this file can be assigned

* to the following categories:

*

* 1. Non-existing tablespaces &

* tablespaces with insufficient free space of type 'DMS without autoresize':

*

* ERROR: messages are listed here.

* To solve all problems of this type marked with 'ERROR:'

* file /usr/sap/OS2/SUM/abap/log/DB6TBSXT.CLP was created by SAPup as a template

* DB2 CLP script containing the SQL-statements to create new tablespaces

* and/or to enlarge the tablespaces with insufficient free space.

*

* 2. Tablespaces with insufficient free space of type 'DMS with automatic storage':

*

* These kind of tablespaces can grow until all storage paths defined for the

* database are full. If all storage paths defined for the database together have

* insufficient free space, an 'ERROR:' message is listed here.

*

* 3. Tablespaces with insufficient free space of type 'SMS' &

* tablespaces with insufficient free space of type 'DMS with autoresize':

*

* These kinds of tablespaces can grow until the filesystems containing them are full.

* If the filesystems containing one or more tablespaces have insufficient free space,

* an 'ERROR:' message is listed here.

* Depending on the database layout it is not always possible to determine if the

* free space on file system level meets the space requirements of SAPup.

* In these cases a detailed 'INFO:' message is generated. Please make sure manually

* that enough free space on file system level is provided to meet

* the space requirements of SAPup.

*

*************************************************************************

*

* all INFO: and/or ERROR: messages for autostorage or auto-resize enabled

* tablespaces listed below are based of the following information:

* (if no INFO: or ERROR: message is listed sufficient free space exists)

*

* TABLESPACE_NAME FREE_MB MB_NEEDED IN_MOUNT_CONTAINING_FILE

* =============================================================================

* OP2#BTABI 33193 2510 /db2/OS2/sapdata1/NODE0000/OP2#BTABD.container000

* 12505 /db2/OS2/sapdata2/NODE0000/OP2#BTABD.container001

* 11720 /db2/OS2/sapdata3/NODE0000/OP2#BTABD.container002

* 20064 /db2/OS2/sapdata4/NODE0000/OP2#BTABD.container003

* 20678 /db2/OS2/sapdata5/NODE0000/OP2#BTABD.container004

* OP2#DDICD 33193 3250 /db2/OS2/sapdata1/NODE0000/OP2#BTABD.container000

* 12505 /db2/OS2/sapdata2/NODE0000/OP2#BTABD.container001

* 11720 /db2/OS2/sapdata3/NODE0000/OP2#BTABD.container002

* 20064 /db2/OS2/sapdata4/NODE0000/OP2#BTABD.container003

* OP2#DDICI 20064 1450 /db2/OS2/sapdata4/NODE0000/OP2#BTABD.container003

* OP2#DOCUD 20678 50 /db2/OS2/sapdata5/NODE0000/OP2#BTABD.container004

* OP2#DOCUI 20678 30 /db2/OS2/sapdata5/NODE0000/OP2#BTABD.container004

* OP2#LOADD 20678 70 /db2/OS2/sapdata5/NODE0000/OP2#BTABD.container004

* OP2#POOLD 33193 4700 /db2/OS2/sapdata1/NODE0000/OP2#BTABD.container000

* 12505 /db2/OS2/sapdata2/NODE0000/OP2#BTABD.container001

* 11720 /db2/OS2/sapdata3/NODE0000/OP2#BTABD.container002

* 20064 /db2/OS2/sapdata4/NODE0000/OP2#BTABD.container003

* 20678 /db2/OS2/sapdata5/NODE0000/OP2#BTABD.container004

* OP2#POOLI 33193 3090 /db2/OS2/sapdata1/NODE0000/OP2#BTABD.container000

* 12505 /db2/OS2/sapdata2/NODE0000/OP2#BTABD.container001

* 11720 /db2/OS2/sapdata3/NODE0000/OP2#BTABD.container002

* 20064 /db2/OS2/sapdata4/NODE0000/OP2#BTABD.container003

* 20678 /db2/OS2/sapdata5/NODE0000/OP2#BTABD.container004

* OP2#SOURCED 11720 2700 /db2/OS2/sapdata3/NODE0000/OP2#BTABD.container002

* OP2#SOURCEI 20064 230 /db2/OS2/sapdata4/NODE0000/OP2#BTABD.container003

* OP2#STABD 33193 4890 /db2/OS2/sapdata1/NODE0000/OP2#BTABD.container000

* 12505 /db2/OS2/sapdata2/NODE0000/OP2#BTABD.container001

* 11720 /db2/OS2/sapdata3/NODE0000/OP2#BTABD.container002

* 20064 /db2/OS2/sapdata4/NODE0000/OP2#BTABD.container003

* 20678 /db2/OS2/sapdata5/NODE0000/OP2#BTABD.container004

* OP2#STABI 33193 4900 /db2/OS2/sapdata1/NODE0000/OP2#BTABD.container000

* 12505 /db2/OS2/sapdata2/NODE0000/OP2#BTABD.container001

* 11720 /db2/OS2/sapdata3/NODE0000/OP2#BTABD.container002

* 20064 /db2/OS2/sapdata4/NODE0000/OP2#BTABD.container003

* 20678 /db2/OS2/sapdata5/NODE0000/OP2#BTABD.container004

* OP2#USER1D 20064 1500 /db2/OS2/sapdata4/NODE0000/OP2#BTABD.container003

* OP2#USER1I 20064 1510 /db2/OS2/sapdata4/NODE0000/OP2#BTABD.container003

* SYSCATSPACE 33193 5300 /db2/OS2/sapdata1/NODE0000/OP2#BTABD.container000

* =============================================================================

*

*******************************************************************************

INSUFFICIENT FREE SPACE: ERROR: Extend file systems containing/db2/OS2/sapdata1/NODE0000/OP2#BTABD.container000 /db2/OS2/sapdata2/NODE0000/OP2#BTABD.container001 /db2/O

S2/sapdata3/NODE0000/OP2#BTABD.container002 /db2/OS2/sapdata4/NODE0000/OP2#BTABD.container003 /db2/OS2/sapdata5/NODE0000/OP2#BTABD.container004 /db2/OS2/sapdata1/NODE00

00/OP2#BTABD.container000 /db2/OS2/sapdata2/NODE0000/OP2#BTABD.container001 /db2/OS2/sapdata3/NODE0000/OP2#BTABD.container002 /db2/OS2/sapdata4/NODE0000/OP2#BTABD.conta

iner003 /db2/OS2/sapdata5/NODE0000/OP2#BTABD.container004 /db2/OS2/sapdata5/NODE0000/OP2#BTABD.container004 /db2/OS2/sapdata5/NODE0000/OP2#BTABD.container004 /db2/OS2/s

apdata1/NODE0000/OP2#BTABD.container000 /db2/OS2/sapdata2/NODE0000/OP2#BTABD.container001 /db2/OS2/sapdata3/NODE0000/OP2#BTABD.container002 /db2/OS2/sapdata4/NODE0000/O

P2#BTABD.container003 /db2/OS2/sapdata4/NODE0000/OP2#BTABD.container003 /db2/OS2/sapdata5/NODE0000/OP2#BTABD.container004 /db2/OS2/sapdata5/NODE0000/OP2#BTABD.container

004 /db2/OS2/sapdata3/NODE0000/OP2#BTABD.container002 /db2/OS2/sapdata1/NODE0000/OP2#BTABD.container000 /db2/OS2/sapdata1/NODE0000/OP2#BTABD.container000 /db2/OS2/sapda

ta2/NODE0000/OP2#BTABD.container001 /db2/OS2/sapdata5/NODE0000/OP2#BTABD.container004 /db2/OS2/sapdata5/NODE0000/OP2#BTABD.container004 /db2/OS2/sapdata1/NODE0000/OP2#B

TABD.container000 /db2/OS2/sapdata2/NODE0000/OP2#BTABD.container001 /db2/OS2/sapdata3/NODE0000/OP2#BTABD.container002 /db2/OS2/sapdata4/NODE0000/OP2#BTABD.container003

/db2/OS2/sapdata5/NODE0000/OP2#BTABD.container004 /db2/OS2/sapdata1/NODE0000/OP2#BTABD.container000 /db2/OS2/sapdata2/NODE0000/OP2#BTABD.container001 /db2/OS2/sapdata3/

NODE0000/OP2#BTABD.container002 /db2/OS2/sapdata4/NODE0000/OP2#BTABD.container003 /db2/OS2/sapdata5/NODE0000/OP2#BTABD.container004 /db2/OS2/sapdata1/NODE0000/OP2#BTABD

.container000 /db2/OS2/sapdata2/NODE0000/OP2#BTABD.container001 /db2/OS2/sapdata3/NODE0000/OP2#BTABD.container002 /db2/OS2/sapdata4/NODE0000/OP2#BTABD.container003 /db2

/OS2/sapdata5/NODE0000/OP2#BTABD.container004 /db2/OS2/sapdata4/NODE0000/OP2#BTABD.container003 /db2/OS2/sapdata3/NODE0000/OP2#BTABD.container002 /db2/OS2/sapdata4/NODE

0000/OP2#BTABD.container003 /db2/OS2/sapdata1/NODE0000/OP2#BTABD.container000 /db2/OS2/sapdata2/NODE0000/OP2#BTABD.container001 /db2/OS2/sapdata3/NODE0000/OP2#BTABD.con

tainer002 /db2/OS2/sapdata4/NODE0000/OP2#BTABD.container003 /db2/OS2/sapdata5/NODE0000/OP2#BTABD.container004 /db2/OS2/sapdata1/NODE0000/OP2#BTABD.container000 /db2/OS2

/sapdata2/NODE0000/OP2#BTABD.container001 /db2/OS2/sapdata3/NODE0000/OP2#BTABD.container002 /db2/OS2/sapdata4/NODE0000/OP2#BTABD.container003 /db2/OS2/sapdata5/NODE0000

/OP2#BTABD.container004 /db2/OS2/sapdata4/NODE0000/OP2#BTABD.container003 /db2/OS2/sapdata4/NODE0000/OP2#BTABD.container003 /db2/OS2/sapdata1/NODE0000/OP2#BTABD.contain

er000

INSUFFICIENT FREE SPACE: ERROR: to fulfil the following free space requirements:

INSUFFICIENT FREE SPACE: ERROR: OP2#BTABD : 0 (MB)

INSUFFICIENT FREE SPACE: ERROR: OP2#BTABI : 2510 (MB)

INSUFFICIENT FREE SPACE: ERROR: OP2#CLUD : 0 (MB)

INSUFFICIENT FREE SPACE: ERROR: OP2#CLUI : 0 (MB)

INSUFFICIENT FREE SPACE: ERROR: OP2#DDICD : 3250 (MB)

INSUFFICIENT FREE SPACE: ERROR: OP2#DDICI : 1450 (MB)

INSUFFICIENT FREE SPACE: ERROR: OP2#DOCUD : 50 (MB)

INSUFFICIENT FREE SPACE: ERROR: OP2#DOCUI : 30 (MB)

INSUFFICIENT FREE SPACE: ERROR: OP2#EL740D : 0 (MB)

INSUFFICIENT FREE SPACE: ERROR: OP2#EL740I : 0 (MB)

INSUFFICIENT FREE SPACE: ERROR: OP2#ES740D : 0 (MB)

INSUFFICIENT FREE SPACE: ERROR: OP2#ES740I : 0 (MB)

INSUFFICIENT FREE SPACE: ERROR: OP2#LOADD : 70 (MB)

INSUFFICIENT FREE SPACE: ERROR: OP2#LOADI : 0 (MB)

INSUFFICIENT FREE SPACE: ERROR: OP2#POOLD : 4700 (MB)

INSUFFICIENT FREE SPACE: ERROR: OP2#POOLI : 3090 (MB)

INSUFFICIENT FREE SPACE: ERROR: OP2#PROTD : 0 (MB)

INSUFFICIENT FREE SPACE: ERROR: OP2#PROTI : 0 (MB)

INSUFFICIENT FREE SPACE: ERROR: OP2#SOURCED : 2700 (MB)

INSUFFICIENT FREE SPACE: ERROR: OP2#SOURCEI : 230 (MB)

INSUFFICIENT FREE SPACE: ERROR: OP2#STABD : 4890 (MB)

INSUFFICIENT FREE SPACE: ERROR: OP2#STABI : 4900 (MB)

INSUFFICIENT FREE SPACE: ERROR: OP2#USER1D : 1500 (MB)

INSUFFICIENT FREE SPACE: ERROR: OP2#USER1I : 1510 (MB)

INSUFFICIENT FREE SPACE: ERROR: SYSCATSPACE : 5300 (MB)

INSUFFICIENT FREE SPACE: ERROR: the minimum extension size for the listed file systems can in general not be determined exactly.

INSUFFICIENT FREE SPACE: ERROR: the following maximum extensions fulfil the requirements but may include large overhead:

INSUFFICIENT FREE SPACE: ERROR: MAX: extend file system containing /db2/OS2/sapdata2/NODE0000/OP2#BTABD.container001 by 10835 MB

INSUFFICIENT FREE SPACE: ERROR: MAX: extend file system containing /db2/OS2/sapdata3/NODE0000/OP2#BTABD.container002 by 14320 MB

INSUFFICIENT FREE SPACE: ERROR: MAX: extend file system containing /db2/OS2/sapdata4/NODE0000/OP2#BTABD.container003 by 7966 MB

Can someone please help to resolve the issue?

Thanks,

Vinay