cancel
Showing results for 
Search instead for 
Did you mean: 

Only sapdata1 seems to be used

Former Member
0 Kudos

AIX 7.1 DB2 v9.7.04

Hi,

I've a problem with my sapdata-directories. It looks like this.

FilesystemGB blocks  Free %UsedIused %Iused Mounted on
/dev/lv_data1 35,00  4,14     89%1241% /db2/SRM/sapdata1
/dev/lv_data2 16,75 16,432%  117 1% /db2/SRM/sapdata2
/dev/lv_data3 16,75 16,432%  117 1% /db2/SRM/sapdata3
/dev/lv_data4 16,75 16,432%  119 1% /db2/SRM/sapdata4

Checking for example

db2 => LIST TABLESPACE CONTAINERS FOR 35

            Tablespace Containers for Tablespace 35

Container ID                         = 0

Name                                 = /db2/TEB/sapdata4/db2teb/NODE0000/TEB/T0000035/C0000000.LRG

Type                                 = File

Container ID                         = 1

Name                                 = /db2/TEB/sapdata3/db2teb/NODE0000/TEB/T0000035/C0000001.LRG

Type                                 = File

Container ID                         = 2

Name                                 = /db2/TEB/sapdata2/db2teb/NODE0000/TEB/T0000035/C0000002.LRG

Type                                 = File

Container ID                         = 3

Name                                 = /db2/TEB/sapdata1/db2teb/NODE0000/TEB/T0000035/C0000003.LRG

Type                                 = File

db2 =>  LIST TABLESPACE CONTAINERS FOR 34

            Tablespace Containers for Tablespace 34

Container ID                         = 0

Name                                 = /db2/SAP/sapdata4/db2eb/NODE0000/TEB/T0000034/C0000000.LRG

Type                                 = File

Container ID                         = 1

Name                                 = /db2/SAP/sapdata3/db2eb/NODE0000/TEB/T0000034/C0000001.LRG

Type                                 = File

Container ID                         = 2

Name                                 = /db2/SAP/sapdata2/db2eb/NODE0000/TEB/T0000034/C0000002.LRG

Type                                 = File

Container ID                         = 3

Name                                 = /db2/SAP/sapdata1/db2eb/NODE0000/TEB/T0000034/C0000003.LRG

Type                                 = File

Looks like some is using all sapdata-directories.

But checking PSAPTEMP16 gives

db2 => LIST TABLESPACE CONTAINERS FOR 3

            Tablespace Containers for Tablespace 3

Container ID                         = 0

Name                                 = /db2/SAP/sapdata2/db2eb/NODE0000/TEB/T0000003/C0000000.TMP

Type                                 = Path

Container ID                         = 1

Name                                 = /db2/SAP/sapdata3/db2eb/NODE0000/TEB/T0000003/C0000001.TMP

Type                                 = Path

Container ID                         = 2

Name                                 = /db2/SAP/sapdata4/db2eb/NODE0000/TEB/T0000003/C0000002.TMP

Type                                 = Path

Any ideas what could be the problem of just filling up sapdata1?

Thanks in advance!

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

The output from df and db2 list is from the same system, I just changed the SIDS to make it official..and didn't use the same on both places, sorry for that!