Sql warning message 6008 – HP NonStop G-Series User Manual
Page 51
Tape File Concepts
DSM/Tape Catalog User’s Guide — 520233-008
2 - 11
SQL Warning Message 6008
SQL Warning Message 6008
Under certain conditions, for example, when a large amount of data is added to a DSM
database in a time period before the automatic file expiration process has run, this
SQL warning message can be output to the console that is executing a MEDIACOM
session:
6008 STATISTICS OR PARTITIONS FOR A TABLE WERE NOT AVAILABLE
SO THE ACCESS PATH CHOSEN MIGHT NOT BE THE BEST AVAILABLE.
Response time to certain MEDIACOM commands such as INFO DISKFILE is
considerably slower than normal.
The SQL message and slow response time are an indication that you need to run the
clean-up process manually. To manually run the file expiration process for all local file
catalogs, execute these MEDIACOM commands:
MC> ALTER MEDIADEFS, RESET EXPIRATION
MC> EXPIRE TAPEFILE *
The EXPIRE TAPEFILE command manually starts the clean-up process on all file
catalogs (and because of the accompanying ALTER MEDIADEFS command, all
volume catalogs) on your local system. Upon normal completion of EXPIRE
TAPEFILE, you receive status messages showing what was affected by the clean-up
process.