Was loading data to DB2 table using BMC load utility. DB2/BMC automatically generates the IDCAMS statement and this is the message it gave me.....

DEFINE CLUSTER -
(NAME(U011.DSNDBC.WPDDPROD.WPDXEM01.I0001.A006) -
LINEAR -
REUSE -
SHAREOPTIONS(3 3) -
NOERASE -
RECORDS(0016777216 0000658620) -
IDC3221I CONSTANT '0016777216' NOT WITHIN VALUE RANGE
VOLUMES('* ') ) -
DATA(NAME(U011.DSNDBD.WPDDPROD.WPDXEM01.I0001.A006 ) -
)

For some reason it won't allocate that primary quatity in the RECORDS parm even though there is ample space. I can't tell if this is systems or database problem. I've got calls out to both BMC and DB2.

Sorry, DB2 version is 7.1.

That looks like a VSAM/IDCAMS problem, not DB2. Look up the error message in the VSAM/IDCAMS Messages and Codes, or contact BMC.