EHPI Installation Error in CHECKS phase - Insuffient space in the database

[Former Member]

Hi gurus , i am trying to upgrade to EHP4 component but i had stuck with an error at the CHECKS phase. I am using DB2 database 9.7 FP2 , in windows server 2008. I have follow the prerequites as per the guide. Everything went on smooth then i hit with this error. I also check the installation guide and advice to refer Note :18606. In that note there is no steps how to increase or solve this problem. I am very new to db2 database . Please help me step by step to solve this. i will paste the error below.

ERROR> Insufficient free space in the database as follows:

Please refer to file E:\usr\sap\EHPI\abap\log\DBFPLUSCL.RES for more details and additional

information about the results of the free space check on DB6 !!!

ERROR> Create tablespace DEV#EL701DX with 780 MB

ERROR> Create tablespace DEV#EL701IX with 400 MB

ERROR> Create tablespace DEV#ES701DX with 39990 MB

ERROR> Create tablespace DEV#ES701IX with 10430 MB

[Former Member]

Hi Gurus, Thanks for everyone for helping me. I solved the problem above.

I just run a script file which is DB6TBSXT.CLP. this file located in the upgrade directory.

In CMD

i just run the command as below. The script executed successfully.

E:\usr\sap\EHPI\abap\log>db2 -tvf DB6TBSXT.CLP

Thanks everyone for the help.

[Former Member]

Hi gurus, can someone provide me the steps for creating the table spaces for the error message above. in db2cmd command prompt what should i type.

[Former Member]

Hi gurus, can someone please guide me or provide steps how to create these table spaces please . I was looking at the IBM db2 but I am not very sure . Highly appreciate your help .

[Former Member]

you can use create tablespace command

[Former Member]

Thank you all for the reply . I Am sorry . How do I need to create the table spaces . Do I need to do it In db2cmd ? Please guide me through.

[JPReyes]

I don't understand what the issue?... System needs to create those 4 tablespaces.

Find the space required, create the tablespaces and move on.

Regards

Juan

[Former Member]

Hi gurus, This would be the Error Log File

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

*

• 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 E:\usr\sap\EHPI\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.

*

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

INSUFFICIENT FREE SPACE: ERROR> Create tablespace DEV#EL701DX with 780 MB

INSUFFICIENT FREE SPACE: ERROR> Create tablespace DEV#EL701IX with 400 MB

INSUFFICIENT FREE SPACE: ERROR> Create tablespace DEV#ES701DX with 39990 MB

INSUFFICIENT FREE SPACE: ERROR> Create tablespace DEV#ES701IX with 10430 MB

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

*

• 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

• =============================================================================

• DEV#BTABD 224314 4570 H:\db2\DEV\sapdata1\DB2DEV\NODE0000\DEV\T0000012\C0000000.LRG

• DEV#BTABI 224314 2040 H:\db2\DEV\sapdata1\DB2DEV\NODE0000\DEV\T0000012\C0000000.LRG

• DEV#CLUD 224314 20 H:\db2\DEV\sapdata1\DB2DEV\NODE0000\DEV\T0000012\C0000000.LRG

• DEV#DDICD 224314 4850 H:\db2\DEV\sapdata1\DB2DEV\NODE0000\DEV\T0000012\C0000000.LRG

• DEV#DDICI 224314 1560 H:\db2\DEV\sapdata1\DB2DEV\NODE0000\DEV\T0000012\C0000000.LRG

• DEV#DOCUD 224314 70 H:\db2\DEV\sapdata1\DB2DEV\NODE0000\DEV\T0000012\C0000000.LRG

• DEV#DOCUI 224314 60 H:\db2\DEV\sapdata1\DB2DEV\NODE0000\DEV\T0000012\C0000000.LRG

• DEV#LOADD 224314 640 H:\db2\DEV\sapdata1\DB2DEV\NODE0000\DEV\T0000012\C0000000.LRG

• DEV#LOADI 224314 290 H:\db2\DEV\sapdata1\DB2DEV\NODE0000\DEV\T0000012\C0000000.LRG

• DEV#POOLD 224314 3620 H:\db2\DEV\sapdata1\DB2DEV\NODE0000\DEV\T0000012\C0000000.LRG

• DEV#POOLI 224314 4960 H:\db2\DEV\sapdata1\DB2DEV\NODE0000\DEV\T0000012\C0000000.LRG

• DEV#PROTD 224314 150 H:\db2\DEV\sapdata1\DB2DEV\NODE0000\DEV\T0000012\C0000000.LRG

• DEV#PROTI 224314 90 H:\db2\DEV\sapdata1\DB2DEV\NODE0000\DEV\T0000012\C0000000.LRG

• DEV#SOURCED 224314 2660 H:\db2\DEV\sapdata1\DB2DEV\NODE0000\DEV\T0000012\C0000000.LRG

• DEV#SOURCEI 224314 230 H:\db2\DEV\sapdata1\DB2DEV\NODE0000\DEV\T0000012\C0000000.LRG

• DEV#STABD 224314 3040 H:\db2\DEV\sapdata1\DB2DEV\NODE0000\DEV\T0000012\C0000000.LRG

• DEV#STABI 224314 4850 H:\db2\DEV\sapdata1\DB2DEV\NODE0000\DEV\T0000012\C0000000.LRG

• DEV#USER1D 224314 70 H:\db2\DEV\sapdata1\DB2DEV\NODE0000\DEV\T0000012\C0000000.LRG

• DEV#USER1I 224314 70 H:\db2\DEV\sapdata1\DB2DEV\NODE0000\DEV\T0000012\C0000000.LRG

• SYSCATSPACE 224314 6280 H:\db2\DEV\sapdata1\DB2DEV\NODE0000\DEV\T0000012\C0000000.LRG

• =============================================================================

*

[nirmal_konchada]

Hi,

You can manually create those tablespaces and proceed.

Nirmal.