on 04-19-2012 4:08 PM
AIX 7.1 DB2 v9.7.04
Hi,
I've a problem with my sapdata-directories. It looks like this.
Filesystem | GB blocks | Free %Used | Iused %Iused Mounted on |
/dev/lv_data1 | 35,00 | 4,14 | 89% | 124 | 1% /db2/SRM/sapdata1 |
/dev/lv_data2 | 16,75 | 16,43 | 2% | 117 | 1% /db2/SRM/sapdata2 |
/dev/lv_data3 | 16,75 | 16,43 | 2% | 117 | 1% /db2/SRM/sapdata3 |
/dev/lv_data4 | 16,75 | 16,43 | 2% | 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!
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!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
81 | |
24 | |
11 | |
9 | |
7 | |
5 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.