CA View - How to get past message SARDBI01 filetype FILE ALLOCATION FAILED FOR database -ERROR=1708, INFO=0002 DS=nnn

Products

• Output Management Document Viewer
• Deliver
• View
• Output Management Web Viewer

Issue/Introduction

Description:

Message "SARDBI01 Data FILE ALLOCATION FAILED FOR database -ERROR=1708, INFO=0002 DS=nnn " will occur when an active View database extent has been deleted. 

This message appears when trying to add extra space or requesting a status on a database, and View is unable to find a dataset which it considers is part of the database. 

This condition can occur by a dataset being renamed/deleted or as a result of a previously run failed job to add space.

Therefore the missing file has to be recreated and may need to be restored.

Environment

Release: 12.2
Component: VIEW

Resolution

Solution:

To create the missing extent, do the following:

 . Create a new database with a new name, using SARDBASE ADDDS.

 . For the extents up to right before the extent that is missing, use "ADDDS ... CYL=1". 

 . For the replaced extent, use "ADDDS ... CYL=nnnn", allocated as would be a standard extent. 

 . Use =3.4 to rename the database extent to match the name of the extent that is missing.