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

[former_member138885]

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

[former_member138885 · Accepted solution]

Issue resolved after creating containers manually for the mentioned tablespaces with specified sizes.

Thanks,

Vinay