The size of the DQW area of DBID 3 (Dataquery) has been increased from 12,000 tracks to 20,000 tracks. DQWFINIT was executed successfully.
However, a CXX report shows PERCENT FULL at 60%, not 100% as occurs after a DQWFINIT:
TABLE NAME - DQW AREA NAME - DQW
OCCURRENCE - DATAQUERY-DQW P001 OCCURRENCE - DATAQUERY-DQW P001
TABLE ID - 14 AREA SQLNAME -
RECORD LENGTH - 772 / 784 BLOCK LENGTH - 4,096 SLACK - 0
RECORDS IN TABLE - 719,990 OVERFLOWS IN AREA - 0
LENGTH OF KEY/ELEMENTS - 168 BLOCKS IN USE - 144,000 HIGH USED TRACK - 12,032
NUMBER OF KEYS - 1 BLOCKS UNUSED - 96,000
NUMBER OF ELEMENTS - 3 TOTAL BLOCKS - 240,000 CXXMAINT LINK - YES
CHANGE MASTER KEY - NO TOTAL TRACKS - 20,000 DYNAMIC EXTEND - NO
DUPLICATE MASTER KEY - NO PERCENT FULL - 60 DYN.EXT.TRACKS - 0
RECOVER - YES ENCRYPTION - NONE DEVICE TYPE - 3390 SECONDARY CYLS - 0
LOGGING - NO BLOCKS/TRACK - 12
PIPELINE - NO DSOP MODE - RANDOM
DB COMPRESSION - NO TRANSITION - NEVER TABLE LOADED - YES, DATE--2/02/2022, TIME-22.20.25
USER COMPRESSION - NO INDEX LOADED - YES
CLUSTER KEY ID - 0 DATADICTIONARY BASE - 2
CLUSTER KEY LENGTH - 0 DATA BASE ID CHANGE - NO
DEFINITION POSTED VIA - LOAD FROM BACKUP
AUTHID - SQL-INTENT - *
TABLE SQLNAME - UNIQUE ROW IDENTIFIERS (URI) - 719,990 URI-REUSE NO
DOMAIN CONSTRAINT - NO TABLE BEING REFERENCED - NO
DL1-T CONSTRAINT - NO TABLE REFERENCING - NO
TABLE CONSTRAINED - NO ALL REFERENCING IN THIS BASE - YES
CURRENT CHECK PENDING - LOAD SET - NO HISTORY CHECK PENDING - LOAD SET - NO
RELATED TABLE - NO RELATED TABLE - NO
FORWARD RECOVERY - NO FORWARD RECOVERY - NO
TRIGGER(S) - NO FORCED OFF - NO
CURRENT ROW(S) VIOLATE CONSTRAINT(S) - NO HISTORY ROW(S) VIOLATE CONSTRAINT(S) - NO
DATA SET NAME - xxxx.PROD.SYS003.DQW.DBD DATA DTF/DDNAME - DQW003
VOLUMES - vvvvvv
KEY - NAME ID LENGTH MASTER NATIVE UNIQUE DIRECT KEY INC KEY USE OCCURRENCE / KEY SQLNAME STATUS
DQWK1 0033 4 YES YES NO NO YES ANY DQWK1 P001 LD
- FIELDS - ORDER SENSITIVE NULL START LENGTH OCCURRENCE
ASCEND NOT SENS NO 0 4 F00001-00004 P001
Release : 15.1
Component : Dataquery for CA Datacom
DQW was recently reloaded (via DBUTLTY LOAD) using a backup file that was generated when the size of DQW was still 12,000 tracks.
So only 60% (i.e 12,000 tracks out of 20,000) of the dataset has been formatted by DQWFINIT.
Run DQWFINIT again, immediately take a new backup and then use this new file to load DQW again when necessary