Load Failed due the space alloaction.

Tej Patil

Load Failed due the space alloaction.
Hi Everybody,

Below is the copy of SDSF for load job, It says it needs more space for this
dataset.
How to calculate the space required by dataset, is there a way to calculate
it? If so can anybody explain it to me?
How do you extend space for a VSAM Dataset?
Thanks in advance.

IGD17272I VOLUME SELECTION HAS FAILED FOR INSUFFICIENT SPACE FOR 900
DATA SET DB2DEVL.DSNDBD.NTRBx02.XITR2.I0001.A003
JOBNAME (LDNTR112) STEPNAME (LOAD3 )
PROGNAME (AMUUMAIN) DDNAME (N/A )
REQUESTED SPACE QUANTITY = 415019 KB
STORCLAS (STANDARD) MGMTCLAS (NOBKDB2) DATACLAS (DCEXTADD)
STORGRPS (SGAITDB )
IGD17273I ALLOCATION HAS FAILED FOR ALL VOLUMES SELECTED FOR DATA SET 901
DB2DEVL.DSNDBD.NTRBx02.XITR2.I0001.A003
IGD17290I THERE WERE 1 CANDIDATE STORAGE GROUPS OF WHICH THE FIRST 1 902
WERE ELIGIBLE FOR VOLUME SELECTION.
THE CANDIDATE STORAGE GROUPS WERE:SGAITDB
IGD17279I 732 VOLUMES WERE REJECTED BECAUSE THEY DID NOT HAVE SUFFICIENT
SPACE
IGD17279I 1 VOLUMES WERE REJECTED BECAUSE THEY WERE ON THE EXCLUDE LIST
IEC070I 211(8,17273)-221,LDNTR112,LOAD3,SYS00206,1B77,APD05E, 905
IEC070I DB2DEVL.DSNDBC.NTRBx02.XITR2.I0001.A003,
IEC070I DB2DEVL.DSNDBD.NTRBx02.XITR2.I0001.A003,ICF.DAPP02
LDNTR112 12 LOAD3 AMUUMAIN ---- R0012
LDNTR112 13 CLEAN3 IEFBR14 ---- NXEQ

Load Step output:
-----------------
EXTEND REQUEST FOR DATASET 'DB2DEVL.DSNDBD.NTRBx02.XITR2.I0001.A003' FAILED,
DATASET IS OUT OF SPACE
1: VSAM I/O ERROR ON DATASET 'DB2DEVL.DSNDBD.NTRBx02.XITR2.I0001.A003', R =
8,, F = 08FF07#, P = 0800B4
BUILD TASK NUMBER 1 ABNORMALLY TERMINATED WITH RETURN CODE = 12
BUILD TASK NUMBER 0 ABNORMALLY TERMINATED WITH RETURN CODE = 12
UTILITY EXECUTION TERMINATING, RETURN CODE = 12

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

Michael Ebert

Re: Load Failed due the space alloaction.
(in response to Tej Patil)
DB2 tried to allocate a dataset which is either the 3rd dataset in a very
big segmented Table- or Indexspace, or a dataset belonging to a 3rd
partition in a partitioned TS - I suspect the latter (because the LOAD job
is called LOAD3). The file allocation request is not handled directly by
DB2 but passed to AMS. The requested size is 415 MB, but there is not
enough free space in your storage group to fulfill the request. This could
be either because your disk pack is really nearly 100% full, or because
the free space is too fragmented. In the first case, your storage
administrator has to add more disks to storage group SGAITDB, in the
second case defragmenting the disks might help. Here too your disk pack
must be highly used so sooner or later you (or your storage admin) will
have to think about freeing up space or adding more disks.

Dr. Michael Ebert
DB2 & Oracle Database Administrator
aMaDEUS Data Processing
Erding / Munich, Germany








tsp l <[login to unmask email]>
Please respond to DB2 Database Discussion list at IDUG
<[login to unmask email]>
Sent by: DB2 Data Base Discussion List <[login to unmask email]>
07-01-06 20:45

To
[login to unmask email]
cc



Subject
[DB2-L] Load Failed due the space alloaction.






Hi Everybody,

Below is the copy of SDSF for load job, It says it needs more space for
this dataset.
How to calculate the space required by dataset, is there a way to
calculate it? If so can anybody explain it to me?
How do you extend space for a VSAM Dataset?
Thanks in advance.

IGD17272I VOLUME SELECTION HAS FAILED FOR INSUFFICIENT SPACE FOR 900
DATA SET DB2DEVL.DSNDBD.NTRBx02.XITR2.I0001.A003
JOBNAME (LDNTR112) STEPNAME (LOAD3 )
PROGNAME (AMUUMAIN) DDNAME (N/A )
REQUESTED SPACE QUANTITY = 415019 KB
STORCLAS (STANDARD) MGMTCLAS (NOBKDB2) DATACLAS (DCEXTADD)
STORGRPS (SGAITDB )
IGD17273I ALLOCATION HAS FAILED FOR ALL VOLUMES SELECTED FOR DATA SET 901
DB2DEVL.DSNDBD.NTRBx02.XITR2.I0001.A003
IGD17290I THERE WERE 1 CANDIDATE STORAGE GROUPS OF WHICH THE FIRST 1 902
WERE ELIGIBLE FOR VOLUME SELECTION.
THE CANDIDATE STORAGE GROUPS WERE:SGAITDB
IGD17279I 732 VOLUMES WERE REJECTED BECAUSE THEY DID NOT HAVE SUFFICIENT
SPACE
IGD17279I 1 VOLUMES WERE REJECTED BECAUSE THEY WERE ON THE EXCLUDE LIST
IEC070I 211(8,17273)-221,LDNTR112,LOAD3,SYS00206,1B77,APD05E, 905
IEC070I DB2DEVL.DSNDBC.NTRBx02.XITR2.I0001.A003,
IEC070I DB2DEVL.DSNDBD.NTRBx02.XITR2.I0001.A003,ICF.DAPP02
LDNTR112 12 LOAD3 AMUUMAIN ---- R0012
LDNTR112 13 CLEAN3 IEFBR14 ---- NXEQ

Load Step output:
-----------------
EXTEND REQUEST FOR DATASET 'DB2DEVL.DSNDBD.NTRBx02.XITR2.I0001.A003'
FAILED, DATASET IS OUT OF SPACE
1: VSAM I/O ERROR ON DATASET 'DB2DEVL.DSNDBD.NTRBx02.XITR2.I0001.A003 ', R
= 8,, F = 08FF07#, P = 0800B4
BUILD TASK NUMBER 1 ABNORMALLY TERMINATED WITH RETURN CODE = 12
BUILD TASK NUMBER 0 ABNORMALLY TERMINATED WITH RETURN CODE = 12
UTILITY EXECUTION TERMINATING, RETURN CODE = 12

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

Mike Bell

Re: Load Failed due the space alloaction.
(in response to Michael Ebert)
The error message says that you don't have any volumes with at least 415MB
in space in less than 5 extents. That is about 400+ cylinders of space. You
need to talk to your DASD people about SMS storage group SGAITDB.

The normal problem I used to see is someone took the DDL from prod for a big
partitioned table and wants to load a small test file. The problem is that
prod is sized for prod and you need to change the priqty and secqty to match
what you are actually loading

There are multiple methods to calculate the space required for load
processing. It depends how accurate you need to be.

1. Real accurate - DB2 estimator - download from the IBM site and it will
take in DDL and record counts and give space allocations. BMC admin tool has
a panel that does it, the CA (old Platinum) has a panel, don't remember
where anymore.
2. (not very accurate) If the record length of the table is less than 10% of
the page size for the tablespace, you can just take the record length times
the number of records time 1.2 (for 20% overhead) and come out with a
reasonable guess. Remember to do the same calculation for the indexes.
3. in between - Go to the DB2 admin guide and calculate the number of rows
per page and do the math for number records divided by number of rows per
page to get number of pages (remember to include free page and free space in
the calculation), and divide by 12 4K pages per track. (if page size is
something other than 4K, you need to calculate number of pages per track in
units of 4k physical blocks). Then redo the same calculation for the indexes
with free page and free space, etc

Mike
HLS Technologies

-----Original Message-----
From: DB2 Data Base Discussion List [mailto:[login to unmask email] On Behalf
Of tsp l
Sent: Saturday, January 07, 2006 1:46 PM
To: [login to unmask email]
Subject: [DB2-L] Load Failed due the space alloaction.

Hi Everybody,

Below is the copy of SDSF for load job, It says it needs more space for this
dataset.
How to calculate the space required by dataset, is there a way to calculate
it? If so can anybody explain it to me?
How do you extend space for a VSAM Dataset?
Thanks in advance.

IGD17272I VOLUME SELECTION HAS FAILED FOR INSUFFICIENT SPACE FOR 900
DATA SET DB2DEVL.DSNDBD.NTRBx02.XITR2.I0001.A003
JOBNAME (LDNTR112) STEPNAME (LOAD3 )
PROGNAME (AMUUMAIN) DDNAME (N/A )
REQUESTED SPACE QUANTITY = 415019 KB
STORCLAS (STANDARD) MGMTCLAS (NOBKDB2) DATACLAS (DCEXTADD)
STORGRPS (SGAITDB )
IGD17273I ALLOCATION HAS FAILED FOR ALL VOLUMES SELECTED FOR DATA SET 901
DB2DEVL.DSNDBD.NTRBx02.XITR2.I0001.A003
IGD17290I THERE WERE 1 CANDIDATE STORAGE GROUPS OF WHICH THE FIRST 1 902
WERE ELIGIBLE FOR VOLUME SELECTION.
THE CANDIDATE STORAGE GROUPS WERE:SGAITDB
IGD17279I 732 VOLUMES WERE REJECTED BECAUSE THEY DID NOT HAVE SUFFICIENT
SPACE
IGD17279I 1 VOLUMES WERE REJECTED BECAUSE THEY WERE ON THE EXCLUDE LIST
IEC070I 211(8,17273)-221,LDNTR112,LOAD3,SYS00206,1B77,APD05E, 905
IEC070I DB2DEVL.DSNDBC.NTRBx02.XITR2.I0001.A003,
IEC070I DB2DEVL.DSNDBD.NTRBx02.XITR2.I0001.A003,ICF.DAPP02
LDNTR112 12 LOAD3 AMUUMAIN ---- R0012
LDNTR112 13 CLEAN3 IEFBR14 ---- NXEQ

Load Step output:
-----------------
EXTEND REQUEST FOR DATASET 'DB2DEVL.DSNDBD.NTRBx02.XITR2.I0001.A003' FAILED,
DATASET IS OUT OF SPACE
1: VSAM I/O ERROR ON DATASET 'DB2DEVL.DSNDBD.NTRBx02.XITR2.I0001.A003 ', R =
8,, F = 08FF07#, P = 0800B4
BUILD TASK NUMBER 1 ABNORMALLY TERMINATED WITH RETURN CODE = 12
BUILD TASK NUMBER 0 ABNORMALLY TERMINATED WITH RETURN CODE = 12
UTILITY EXECUTION TERMINATING, RETURN CODE = 12
----------------------------------------------------------------------------
----- Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and
home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page
select "Join or Leave the list". The IDUG DB2-L FAQ is at
http://www.idugdb2-l.org. The IDUG List Admins can be reached at
[login to unmask email] Find out the latest on IDUG conferences at
http://conferences.idug.org/index.cfm


---
Incoming mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.510 / Virus Database: 307 - Release Date: 8/14/2003



---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.510 / Virus Database: 307 - Release Date: 8/14/2003


---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm