DSM/Tape Catalog User's Guide

Tape File Concepts

DSM/Tape Catalog User’s Guide — 520233-008

2 - 11

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.