Tech Tip: CA Datacom Core Products Version 15.1 Additional Enhancements provided via PTF RO92259/ONLINE_AREA_RELEASE

Document created by KarinaPulinx Employee on Oct 25, 2016
Version 1Show Document
  • View in full screen mode

Tech Tip from Karina Pulinx, Principal Support Engineer for October 25, 2016

 

This is another in the series of tips for CA Datacom Core Products Version 15.1 enhancement PTF RO92259.

RO92259 delivers 10 new features.

 

One of these new features is  Multi-User Console-only command ONLINE_AREA_RELEASE .

This command allows to release unused space in a data area without the need to run a DBUTLTY BACKUP/INIT/LOAD .

 

Use the following syntax in your command to initiate this function from the system console.

 

►►─ ONLINE_AREA_RELEASE        dbid,area-name,percent-of-never-used-space-to-remove ────────►◄

 

Example:

 

 

Before running this command my area TRN  per CXX report has

TOTAL TRACKS  -    30,660

PERCENT FULL  -        53

 

/F DLV1M151,ONLINE_AREA_RELEASE 900,TRN,10

 

DB01311I - ONLINE_AREA_RELEASE 900,TRN,10

DB01335I - CONSOLE SCHEDULED - ONLINE_AREA_RELEASE 900,TRN,10

DB02829I - ONLINE_AREA_RELEASE 900 TRN STATUS STARTED

DB02829I - ONLINE_AREA_RELEASE 900 TRN STATUS LOGICAL SPACE RELEASED

DB02841W - WAIT DELAY 'O_A_RELEASE' MIN:SEC-0:0 ***DBCOM 100 XCOMMTRN 900

DB02829I - ONLINE_AREA_RELEASE 900 TRN STATUS PHYSICAL SPACE RELEASED

DB02829I - ONLINE_AREA_RELEASE 900 TRN STATUS COMPLETE, RELEASED 95 CYL

 

After running   my area has 

TOTAL TRACKS  -    29,235

PERCENT FULL  -        55

Attachments

    Outcomes