• 1 reply
  • Latest Post - ‏2013-07-22T18:05:03Z by sundar_chinnagoundan
1 Post

Pinned topic Extract file space issue

‏2013-04-18T06:35:42Z |


While performing an insert using an extract file of 50GB, Optim shows : *** ERROR *** EXTRACT FILE HAS INVALID FORMAT OR HAS NOT BEEN BUILT.

Extract file has following attributes:  Space=(2500,4000), recfm=FS,DSORG=PS, DATACLASS=DCCMPPS,DSNTYPE=EXTPREF.

Control file's attributes are : Space=(2000,2500),RECFM=FS,DSORG=PS

The extract step went fine and it extracted 50GB of data. Am using legacy tables not DB2. How can i overcome this issue of extract file? I tried increasing the primary and secondary space but in vain. Please advise

  • sundar_chinnagoundan
    5 Posts

    Re: Extract file space issue


    This is storage management question.

    You did not mention the Space Units that you are using: (CYLS, TRKS, KB or MB)?

    See disk pack where your extract file is getting routed to. Generally there will be dataset high qualifier based routing. Check if you have enough free space there. If not use a different HLQ.