Solved: Old DB2 tablespace name during SP update ( SUM ), ...

Hi All

We are doing a SP update on a sandbox system ( ERP600 EHP6 SP06 -> SP13, Using SUM
). The sandbox system is a system copy ( refresh/Database-Specific, DMD->ZMD).

We see similar issue that is described in http://scn.sap.com/thread/619392. Unfortunately no final solution is add to that thread.

After the system copy all tablespace names were changed and tables TADB6, TSDB6 and IADB6
were updated, ref system copy guide/Database-Specific System Copy, 5.4 IBM DB2
for Linux, UNIX, and Windows Specific.

The SUM process stops in “tp” step during preparation phase, referring to old
tablespace name,

Step executed:

"/usr/sap/ZMD/DVEBMGS00/exe/tp

pf=/usr/sap/ZMD/SUM/abap/var/MVNTTOOL.TPP

mvntabs ZMD"

From "SUM" logs

2EETP345
16:08:01: Retcode 512: SQL-error "-204-SQL0204N "DMD#BTABD"
is an undefined name. SQLSTA

2EETP345 TE=42704" in DDL statement for "PUTTB_SHD_1 "

DDL statements shows in table TATAF, and we see statements including the old
tablespace name in that table.

If we manually change the tablespace name in table TATAF ( SE38, report: RUTTATAF )
from DMD# to ZMD#, the SUM process continue few steps, but then again stops due
to same issue.

Searching SYSCAT for DB ( SYSCAT.TABLES, SYSCAT.TABLESPACES ) shows no findings on "DMD#"

All table buffers reset ( /$SYNC )

DMD" does not show in system profiles /SYS/profile/* or in environment settings
except for environment var dbs_db6_schema=sapdmd, dbs_db6_user=sapdmd
( - but this is as described in system copy guide, IBM DB2 for Linux, UNIX, and Windows-Specific Procedures: "You cannot

change the name of the database schema. The name of the database schema is the same
as that of the source system." )

All feedback will be appreciated.

Hanne

SAP Managed Tags:
SAP NetWeaver Application Server

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Accepted Solutions (1)

Thanks for the Update . Happy that the issue is fixed .

Kindly close the thread

Thanks,

Manu

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

The issue showed up in later step, MAIN_SHDCRE/SUBMOD_SHDDBCLONE/DBCLONE.

Below from System Copy Guide seems to have solved issue,

“If you use the

deferred table creation function, you also have to

execute the following command for each renamed tablespace using the

db6util tool:db6util -rtvt

<old_tbs><new_tbs>

For more information, see SAP Note

1227165.62”.

/Hanne

Answers (2)

Hi Hanne ,

The following Note should help you

2098062 - Error SQL0204N during SPAM/SAINT update in IMPORT_PROPER phase

1766273 - SQL0204N "<schema>#<tablespace>" is an undefined name. SQLSTATE=42704

Thanks ,

Manu

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Hi Manu

Thank you for your lates reply.

There seems no %DMD% or %ZMD% in ddstorage-table or syscat, paste in below,

db2 => select * from sapdmd.ddstorage
where upper(text) like upper('%DMD%') ;

DBSYSABBR
TABNAME
INDEXNAME USEFLAG POSNR   SIGN
PARNAME
TEXT

---------
------------------------------------------------------------------------------------------
--------- ------- ------- ----
------------------------------------------------------------------------------------------
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

0 record(s) selected.

db2 => select * from sapdmd.ddstorage
where upper(text) like upper('%ZMD%') ;

DBSYSABBR
TABNAME
INDEXNAME USEFLAG POSNR   SIGN
PARNAME
                                                                            TEXT

---------
------------------------------------------------------------------------------------------
--------- ------- ------- ---- ------------------------------------------------------------------------------------------
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

0 record(s) selected.

db2 =>

En select af det delete statement der er angivet returnerer heller ikke nogen rækker:

db2 => select * from sapdmd.ddstorage where tabname in ( select distinct(tabname)from

sapdmd.ddstorage where upper(text) like upper('sapdmd#%') );db2 (cont.)
=>

DBSYSABBR
TABNAME
                    INDEXNAME
USEFLAG POSNR   SIGN
PARNAME
TEXT

0 record(s) selected.

db2 =>

db2 => select substr(tbspace,1,32) from syscat.tablespaces where
tbspace like 'DMD%'

--------------------------------

0 record(s) selected.

db2 => select substr(tbspace,1,32) from syscat.tablespaces where
tbspace like '%BTABD%'

--------------------------------

ZMD#BTABD

1 record(s) selected.

db2 => select * from SAPDMD.DDSTORAGE where tabname like 'DMD%' or indexname like 'DMD%'

DBSYSABBR
TABNAME
INDEXNAME USEFLAG POSNR   SIGN
PARNAME
TEXT

0 record(s) selected.

DBSYSABBR
TABNAME
                        INDEXNAME
USEFLAG POSNR   SIGN
PARNAME
TEXT

--------- ------------------------------------------------------------------------------------------
--------- ------- ------- ----
------------------------------------------------------------------------------------------
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

0 record(s) selected.

db2 => select * from SAPDMD.DDSTORAGE2 where tabname like 'DMD%' or indexname
like 'DMD%'

DBSYSABBR
TABNAME
INDEXNAME USEFLAG POSNR   SIGN
PARNAME
                                 TEXT

--------- ------------------------------------------------------------------------------------------
--------- ------- ------- ----
------------------------------------------------------------------------------------------
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

0 record(s) selected.

db2 => select * from SAPDMD.tsdb6

TABSPACE
INDSPACE

------------------------------------------------------------------------------------------
------------------------------------------------------------------------------------------

ZMD#STABD
ZMD#STABI

ZMD#BTABD
ZMD#BTABI

ZMD#POOLD
ZMD#POOLI

ZMD#CLUD
ZMD#CLUI

ZMD#DIMD
ZMD#DIMI

ZMD#FACTD
ZMD#FACTI

ZMD#ODSD
ZMD#ODSI

ZMD#SOURCED
ZMD#SOURCEI

ZMD#DDICD
ZMD#DDICI

ZMD#DOCUD
ZMD#DOCUI

ZMD#EL731DX
ZMD#EL731IX

ZMD#LOADD
ZMD#LOADI

ZMD#PROTD
ZMD#PROTI

ZMD#ES731DX

ZMD#ES731IX

ZMD#USER1D
ZMD#USER1I

15 record(s) selected.

db2 => select * from SAPDMD.iadb6

TABART
TABSPACE

--------------- ------------------------------------------------------------------------------------------

APPL0
ZMD#STABI

APPL1
ZMD#BTABI

APPL2
ZMD#POOLI

CLUST
ZMD#CLUI

DDIM
ZMD#DIMI

DFACT
ZMD#FACTI

DODS
ZMD#ODSI

POOL
ZMD#POOLI

SDIC
ZMD#DDICI

SDOCU
ZMD#DOCUI

SLDEF
ZMD#EL731IX

SLEXC
ZMD#EL731IX

SLOAD
ZMD#LOADI

SPROT
ZMD#PROTI

SSDEF
ZMD#ES731IX

SSEXC
ZMD#ES731IX

SSRC
ZMD#SOURCEI

TEMP
ZMD#PROTI

USER
ZMD#USER1I

USER1
ZMD#USER1I

20 record(s) selected.

db2 => select * from SAPDMD.tadb6

TABART
TABSPACE

---------------
------------------------------------------------------------------------------------------

APPL0
ZMD#STABD

APPL1
ZMD#BTABD

APPL2
ZMD#POOLD

CLUST
ZMD#CLUD

DDIM
ZMD#DIMD

DFACT
ZMD#FACTD

DODS
ZMD#ODSD

POOL ZMD#POOLD

SDIC
ZMD#DDICD

SDOCU
ZMD#DOCUD

SLDEF
ZMD#EL731DX

SLEXC
ZMD#EL731DX

SLOAD
ZMD#LOADD

SPROT
ZMD#PROTD

SSDEF
ZMD#ES731DX

SSEXC
ZMD#ES731DX

SSRC
ZMD#SOURCED

TEMP
ZMD#PROTD

USER
ZMD#USER1D

USER1
ZMD#USER1D

20 record(s) selected.

Thanks, Hanne

All looks fine here .

Can you check the following note and see whether your environment variables are set fine

713524 - DB6: Additional information on system copy with DB resources

Also can you post your <hostname>_<DBSID>.xml

Thanks ,

Manu

Hi Manu

Your help is HIGHLY appreciated !

Environment settings (dbenv.* ) for user zmdadm are dbs_db6_schema=sapdmd,

dbs_db6_user=sapdmd.

Environment settings (dbenv.* ) for user db2zmd were ( missed changed
during the system copy process ) dbs_db6_schema=sapzmd, dbs_db6_user=sapzmd, now changed into dbs_db6_schema=sapdmd, dbs_db6_user=sapdmd and the system incl DB has restarted.

SUM continue, but fails with message at Gui screen:

“Severe error(s) occurred in phase PREP_PARSETUP/UVERS_SAVE!

Last error code set: RFC error system ZMD nr 00 function 'SUBST_HANDLE_UVERS' failed with
code 3 key DBIF_RSQL_TABLE_UNKNOWN: A table is unknown or does not exist.”

“DMD#” does no more shows in the logs created in /SUM/abap/log, but below shows in the logs

PSUVSAVE.SAV, PSUVSAVE.LOG and SAPup.log (/SUM/abap/log ,

"1EETQ399 Last error code set is: RFC error system ZMD nr 00 function
'SUBST_HANDLE_UVERS' failed with code 3 key DBIF_RSQL_TABLE_UNKNOWN: A table is
unknown or does not exist.

1EETQ204 Upgrade phase "UVERS_SAVE" aborted with severe errors
("20150213185736")"/ref paste in below.

Files from /SUM/abap/log (SUM_abap_log.zip ) in Dropbox link https://dl.dropboxusercontent.com/u/19928858/SUM_abap_log.zip. Last SUM run was today 14.02, 09:23->

Where to find “<hostname>_<DBSID>.xml”
?

I think of reset the SUM update and start over again,
but stepping backwards by “back” ( - to do “Reset Update” ), I get the message
( “Unable to execute the SDT request list SUM, Revoke is not allowed for the current operation extract. )”. Maybe restore of ZMD is needed.

From view PSUVSAVE.SAV (and PSUVSAVE.LOG ) ( /SUM/abap/log/* )

#!--------------------------------------------------------------

#!---- MASKING file "PSUVSAVE.LOG" from
"/usr/sap/ZMD/SUM/abap/log"

#!---- TIME: 20150214074624
PHASE: PREP_PARSETUP/UVERS_SAVE

#!--------------------------------------------------------------

1 ETQ201 Entering upgrade-phase "PREP_PARSETUP/UVERS_SAVE"
("20150213185736")

2 ETQ367 Connect variables are set for standard instance access

4 ETQ399 System-nr = '00', GwService = 'sapgw00' Client = '000'

4 ETQ399 Environment variables:

4 ETQ399 dbs_db6_schema=sapdmd

1 ETQ200 Executing actual phase 'PREP_PARSETUP/UVERS_SAVE'.

1 ETQ359 RFC Login to: System="ZMD",
AsHost="sapboxmdg" Nr="00", GwHost="sapboxmdg",
GwService="sapgw00"

2 ETQ232 RFC Login succeeded

4 ETQ010 Date & Time: 20150213185736

1 ETQ233 Calling function module "SUBST_HANDLE_UVERS" by RFC

2 ETQ373 parameter "IV_MODE" = "S"

2 ETQ373 parameter "IV_ALL" = " "

2 ETQ399 Table IT_UVERS (#0):

1EETQ235 Call of function module "SUBST_HANDLE_UVERS" by RFC
failed (error-status "3")

2EETQ360 RFC of "SUBST_HANDLE_UVERS" failed:

2EETQ361 code/exception : 3

2EETQ362 key :
DBIF_RSQL_TABLE_UNKNOWN

2EETQ399 A table is unknown or does not exist.

4 ETQ010 Date & Time: 20150213185736

1EETQ399 Last error code set is: RFC error system ZMD nr 00 function
'SUBST_HANDLE_UVERS' failed with code 3 key DBIF_RSQL_TABLE_UNKNOWN: A table is
unknown or does not exist.

1EETQ204 Upgrade phase "UVERS_SAVE" aborted with severe errors
("20150213185736")

From SAPup.log ( /SUM/abap/log/* )

STARTUP 20150214074508

Current unit is 'EXTRACT', next unit is 'EXTRACT'.

-> decided to continue with unit EXTRACT.

...begin
dialog at 20150214074615

...end dialog
at 20150214074624

..answered at 20150214074624.

-> decided to try again.

# Executing module 'PREP_PARSETUP'.

> 2015/02/14 07:46:24 BEGIN
PREPARE MODULE Setup parameters for
tool

# Starting phase execution with maxpar = 6, scheduled: 21x'-'

CURRENTPHASE PREP_PARSETUP/UVERS_SAVE

...started at 20150214074624

# Using phase log file 'PSUVSAVE.LOG'.

..finished at 20150214074624 with status ABORTED.

# Error message set: 'RFC error system ZMD nr 00 function
'SUBST_HANDLE_UVERS' failed with code 3 key DBIF_RSQL_TABLE_UNKNOWN: A table is
unknown or does not exist.'

...begin dialog at 20150214074625

Thanks, Hanne

Hi ,

Did you check the table name in db2diag.log . Can you check in ST22 ?

What is the status of the upgrade now . Did you reset ?

Thanks ,

Manu

Hi Manu

Update phase: RESTART: Stopped in phase PREP_PARSETUP/UVERS_SAVE – I have not done an Update reset yet.

ST22 DBIF_RSQL_TABLE_UNKNOWN
shows when resuming SUM, ref paste in below.

Db2diag.log last changed Feb 13,

-rwxrwxrwx 1 zmdadm
sapsys 32933 Feb 13 17:08
db2diag.log

sapboxmdg:zmdadm
36> pwd

/sapmnt/ZMD/global/db6/db2dump

From db2diag.log

2015-02-13-17.08.10.890863+060
I32616A317 LEVEL: Error

PID : 6881440 TID : 1
PROC : R3trans

INSTANCE:
db2zmd NODE : 000

EDUID : 1

FUNCTION:
DB2 UDB, common communication, sqlcctcpconnr, probe:110

MESSAGE :
DIA3202C The TCP/IP call "connect" returned an errno="79".

From ST22

Category ABAP Programming Error

Runtime Errors DBIF_RSQL_TABLE_UNKNOWN

ABAP Program SAPLSUGG

Application Component BC-UPG

Date and Time 14.02.2015 14:06:26

Information on where terminated
Termination occurred in the ABAP program "SAPLSUGG" - in "SUBST_HANDLE_UVERS".
The main program was "SAPMSSY1 ".

In the source code you have the termination point in line 251
of the (Include) program "LSUGGU05".

244 IF NOT ( lt_uvers[] IS INITIAL ).

245 LOOP AT lt_uvers INTO ls_uvers.

246 MOVE-CORRESPONDING ls_uvers TO ls_uvers_hist.

247 ls_uvers_hist-findate = ls_uvers_hist-enddate.

248 ls_uvers_hist-fintime = ls_uvers_hist-endtime.

249 APPEND ls_uvers_hist TO lt_uvers_hist.

250 ENDLOOP.

>>>> INSERT uvers_hist FROM TABLE lt_uvers_hist

252 ACCEPTING DUPLICATE KEYS.

253 DELETE uvers FROM TABLE lt_uvers.

254 ENDIF.

255

256 it_uvers[] = lt_uvers[].

Thanks

Hanne

No clue here , But the following you could check

check whether the table UVERs exist in the system . Do a check on the table

Check the following link

If nothing is working Backup your SUM directory and raise an OSS message with SAP . We never know whether the issue may reappear .

Do you have a backup before the SUM upgrade started ?

Thanks ,

Manu

Hi Manu

I did an Update reset as from the link you provided. New SUM session
failed in same step PREP_PARSETUP/UVERS_SAVE, same error ( TC ST22, DBIF_RSQL_TABLE_UNKNOWN, table UVERS_HIST ). In TC SE14, storage parameters for table UVERS_HIST showed “”DMD#”. In TC SE14 choosing “Delete database table”, “Create database table” solved the issue, storage parameters in TC SE14 for table UVERS_HIST now show “ZMD#”. SUM continued afterwards – pt running steps in Configuration Phase.

Thanks again for your highly appreciated help on this issue.

Hanne

1) Can you send the screenshot for the following commands

db2 list tablespAces | grep DMD

db2 list tablespAces | grep ZMD

Thanks ,

Manu

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Hi Manu

THANKS FOR VERY FAST REPLY !

Below output from "db2 list tablespAces", no entries including "DMD",

db2 => list tablespAces

Tablespaces for Current Database

Tablespace ID                        = 0
Name                                 = SYSCATSPACE
Type                                 = Database managed space
Contents                             = All permanent data. Regular table space.
State                                = 0x0000
   Detailed explanation:
     Normal

Tablespace ID                        = 1
Name                                 = ZMD#ES731DX
Type                                 = Database managed space
Contents                             = All permanent data. Large table space.
State                                = 0x0000
   Detailed explanation:
     Normal

Tablespace ID                        = 2
Name                                 = ZMD#ES731IX
Type                                 = Database managed space
Contents                             = All permanent data. Large table space.
State                                = 0x0000
   Detailed explanation:
     Normal

Tablespace ID                        = 3
Name                                 = PSAPTEMP16
Type                                 = System managed space
Contents                             = System Temporary data
State                                = 0x0000
   Detailed explanation:
     Normal

Tablespace ID                        = 4
Name                                 = SYSTOOLSTMPSPACE
Type                                 = System managed space
Contents                             = User Temporary data
State                                = 0x0000
   Detailed explanation:
     Normal

Tablespace ID                        = 5
Name                                 = SYSTOOLSPACE
Type                                 = Database managed space
Contents                             = All permanent data. Large table space.
State                                = 0x0000
   Detailed explanation:
     Normal

Tablespace ID                        = 6
Name                                 = ZMD#ES731D
Type                                 = Database managed space
Contents                             = All permanent data. Large table space.
State                                = 0x0000
   Detailed explanation:
     Normal

Tablespace ID                        = 7
Name                                 = ZMD#ES731I
Type                                 = Database managed space
Contents                             = All permanent data. Large table space.
State                                = 0x0000
   Detailed explanation:
     Normal

Tablespace ID                        = 8
Name                                 = ZMD#STABD
Type                                 = Database managed space
Contents                             = All permanent data. Large table space.
State                                = 0x0000
   Detailed explanation:
     Normal

Tablespace ID                        = 9
Name                                 = ZMD#STABI
Type                                 = Database managed space
Contents                             = All permanent data. Large table space.
State                                = 0x0000
   Detailed explanation:
     Normal

Tablespace ID                        = 10
Name                                 = ZMD#EL731D
Type                                 = Database managed space
Contents                             = All permanent data. Large table space.
State                                = 0x0000
   Detailed explanation:
     Normal

Tablespace ID                        = 11
Name                                 = ZMD#EL731I
Type                                 = Database managed space
Contents                             = All permanent data. Large table space.
State                                = 0x0000
   Detailed explanation:
     Normal

Tablespace ID                        = 12
Name                                 = ZMD#BTABD
Type                                 = Database managed space
Contents                             = All permanent data. Large table space.
State                                = 0x0000
   Detailed explanation:
     Normal

Tablespace ID                        = 13
Name                                 = ZMD#BTABI
Type                                 = Database managed space
Contents                             = All permanent data. Large table space.
State                                = 0x0000
   Detailed explanation:
     Normal

Tablespace ID                        = 14
Name                                 = ZMD#POOLD
Type                                 = Database managed space
Contents                             = All permanent data. Large table space.
State                                = 0x0000
   Detailed explanation:
     Normal

Tablespace ID                        = 15
Name                                 = ZMD#POOLI
Type                                 = Database managed space
Contents                             = All permanent data. Large table space.
State                                = 0x0000
   Detailed explanation:
     Normal

Tablespace ID                        = 16
Name                                 = ZMD#CLUD
Type                                 = Database managed space
Contents                             = All permanent data. Large table space.
State                                = 0x0000
   Detailed explanation:
     Normal

Tablespace ID                        = 17
Name                                 = ZMD#CLUI
Type                                 = Database managed space
Contents                             = All permanent data. Large table space.
State                                = 0x0000
   Detailed explanation:
     Normal

Tablespace ID                        = 18
Name                                 = ZMD#DIMD
Type                                 = Database managed space
Contents                             = All permanent data. Large table space.
State                                = 0x0000
   Detailed explanation:
     Normal

Tablespace ID                        = 19
Name                                 = ZMD#DIMI
Type                                 = Database managed space
Contents                             = All permanent data. Large table space.
State                                = 0x0000
   Detailed explanation:
     Normal

Tablespace ID                        = 20
Name                                 = ZMD#FACTD
Type                                 = Database managed space
Contents                             = All permanent data. Large table space.
State                                = 0x0000
   Detailed explanation:
     Normal

Tablespace ID                        = 21
Name                                 = ZMD#FACTI
Type                                 = Database managed space
Contents                             = All permanent data. Large table space.
State                                = 0x0000
   Detailed explanation:
     Normal

Tablespace ID                        = 22
Name                                 = ZMD#ODSD
Type                                 = Database managed space
Contents                             = All permanent data. Large table space.
State                                = 0x0000
   Detailed explanation:
     Normal

Tablespace ID                        = 23
Name                                 = ZMD#ODSI
Type                                 = Database managed space
Contents                             = All permanent data. Large table space.
State                                = 0x0000
   Detailed explanation:
     Normal

Tablespace ID                        = 24
Name                                 = ZMD#DDICD
Type                                 = Database managed space
Contents                             = All permanent data. Large table space.
State                                = 0x0000
   Detailed explanation:
     Normal

Tablespace ID                        = 25
Name                                 = ZMD#DDICI
Type                                 = Database managed space
Contents                             = All permanent data. Large table space.
State                                = 0x0000
   Detailed explanation:
     Normal

Tablespace ID                        = 26
Name                                 = ZMD#DOCUD
Type                                 = Database managed space
Contents                             = All permanent data. Large table space.
State                                = 0x0000
   Detailed explanation:
     Normal

Tablespace ID                        = 27
Name                                 = ZMD#DOCUI
Type                                 = Database managed space
Contents                             = All permanent data. Large table space.
State                                = 0x0000
   Detailed explanation:
     Normal

Tablespace ID                        = 28
Name                                 = ZMD#LOADD
Type                                 = Database managed space
Contents                             = All permanent data. Large table space.
State                                = 0x0000
   Detailed explanation:
     Normal

Tablespace ID                        = 29
Name                                 = ZMD#LOADI
Type                                 = Database managed space
Contents                             = All permanent data. Large table space.
State                                = 0x0000
   Detailed explanation:
     Normal

Tablespace ID                        = 30
Name                                 = ZMD#PROTD
Type                                 = Database managed space
Contents                             = All permanent data. Large table space.
State                                = 0x0000
   Detailed explanation:
     Normal

Tablespace ID                        = 31
Name                                 = ZMD#PROTI
Type                                 = Database managed space
Contents                             = All permanent data. Large table space.
State                                = 0x0000
   Detailed explanation:
     Normal

Tablespace ID                        = 32
Name                                 = ZMD#SOURCED
Type                                 = Database managed space
Contents                             = All permanent data. Large table space.
State                                = 0x0000
   Detailed explanation:
     Normal

Tablespace ID                        = 33
Name                                 = ZMD#SOURCEI
Type                                 = Database managed space
Contents                             = All permanent data. Large table space.
State                                = 0x0000
   Detailed explanation:
     Normal

Tablespace ID                        = 34
Name                                 = ZMD#USER1D
Type                                 = Database managed space
Contents                             = All permanent data. Large table space.
State                                = 0x0000
   Detailed explanation:
     Normal

Tablespace ID                        = 35
Name                                 = ZMD#USER1I
Type                                 = Database managed space
Contents                             = All permanent data. Large table space.
State                                = 0x0000
   Detailed explanation:
     Normal

Tablespace ID                        = 36
Name                                 = ZMD#EL731DX
Type                                 = Database managed space
Contents                             = All permanent data. Large table space.
State                                = 0x0000
   Detailed explanation:
     Normal

Tablespace ID                        = 37
Name                                 = ZMD#EL731IX
Type                                 = Database managed space
Contents                             = All permanent data. Large table space.
State                                = 0x0000
   Detailed explanation:
     Normal

Tablespace ID                        = 38
Name                                 = SAPTOOLS
Type                                 = Database managed space
Contents                             = All permanent data. Large table space.
State                                = 0x0000
   Detailed explanation:
     Normal

Tablespace ID                        = 39
Name                                 = SAPEVENTMON
Type                                 = Database managed space
Contents                             = All permanent data. Large table space.
State                                = 0x0000
   Detailed explanation:
     Normal

db2 =>

THANKS,

Hanne

Ask a Question

Top Q&A Solution Author

User

Count

Old DB2 tablespace name during SP update ( SUM ), step failure

Accepted Solutions (1)

Accepted Solutions (1)

Answers (2)

Answers (2)

SAC BW live connection: Error Illegal State: data ...

Background job status notifications

Re: Systemcopy sap QAS longTime

Re: NCO 2.0 and UNICODE compatibility

Re: Not able to delete SAP Business One License