View previous topic :: View next topic
|
Author |
Message |
Manshadi
New User
Joined: 31 Aug 2005 Posts: 82
|
|
|
|
Hi,
How can I extend SPT01, it has reached to 2G.
Regards
Manshadi |
|
Back to top |
|
|
GuyC
Senior Member
Joined: 11 Aug 2009 Posts: 1281 Location: Belgium
|
|
Back to top |
|
|
Manshadi
New User
Joined: 31 Aug 2005 Posts: 82
|
|
|
|
The version of DB2 is 8.
Is the allocating new VSAM file enough?
Thanks
Manshadi |
|
Back to top |
|
|
Manshadi
New User
Joined: 31 Aug 2005 Posts: 82
|
|
|
|
I find the following information on DB2 administrator guide book, but I am not sure it will work or not?!!!
Procedure 4. Add a data set: If the object supported is user-defined, use the access method services to define another data set.
The name of the new data set must continue the sequence begun by the names of the existing data sets that support the object.
The last four characters of each name are a relative data set number: If the last name ended with A001, the next must end with
A002, and so on. Also, be sure to add either I or J in the name of the data set. |
|
Back to top |
|
|
GuyC
Senior Member
Joined: 11 Aug 2009 Posts: 1281 Location: Belgium
|
|
|
|
allocating VSAM was the last solution if the first two didn't help and you don't want to compress SPT01.
After allocating you'll need to stop/start the DB2 subsystem. |
|
Back to top |
|
|
Manshadi
New User
Joined: 31 Aug 2005 Posts: 82
|
|
|
|
GuyC
We have 5 big database on our sub system and we need all packages.
I created new data set and restarted DB2 sub system and run my bulk bind on it.
I will confirm you the result.
Thanks
Manshadi |
|
Back to top |
|
|
Manshadi
New User
Joined: 31 Aug 2005 Posts: 82
|
|
|
|
GuyC
The second allocation of SPT01 worked fine.
Thanks
Manshadi |
|
Back to top |
|
|
GuyC
Senior Member
Joined: 11 Aug 2009 Posts: 1281 Location: Belgium
|
|
|
|
thx for the feedback |
|
Back to top |
|
|
|