DQWFINIT is the batch utility which you use to initialize the DQE (SQL Found Table), DQF (Found Table), and DQW (Work Table). DQWFINIT initializes only the first block of the DQF.
In DBUTLTY Directory (CXX) reports, the DQW always shows 99 percent full after DQWFINIT has been run. A lack of available work space on the DQW is indicated by error messages. The percent full value on the report for the DQF and the DQE shows the maximum used at one time (a "high-water mark"). Space that has been used and freed shows on the report as being in use.
Tasks
Use the DQWFINIT utility to perform the following maintenance tasks:
Procedures
You can run DQWFINIT after the appropriate files have been initialized and null loaded with DBUTLTY.
SYNCHRONIZE. When you null load and initialize the DQF, you must also null load and initialize the DQE, DQR, and DQS to maintain synchronization. Failure to synchronize these tables can result in failure to reclaim DQF space. (Omit the DQE and DQR tables if the SQL option is not installed.)
Executing DQWFINIT completely reinitializes the DQF table and destroys any deferred KEEP or EXTRACT row collections currently on the table. Queued network print requests are all lost. Deferred batch jobs are lost.
Work Table Create Report
Following is an example of the Work Table Create Report produced by DQWFINIT when DQW initialization is successful.
DATAQUERY WORK TABLE CREATE TABLE DQW INITIALIZED SUCCESSFULLY 00586 ROWS WRITTEN
|
Copyright © 2014 CA.
All rights reserved.
|
|