Image | Audio | Video |
---|---|---|
X | X | X |
List all media files that are inaccessible and referenced by a table, tables with a specific qualifier, or all the tables in the current database.
Authorization
For all tables in the current database, that is, if you do not specify USER or IN: SYSADM, SYSCTRL, SYSMAINT, DBADM
For a particular table (if you specify IN) or tables that belong to a qualifier (if you specify USER): Select
Command syntax
>>-GET INACCESSIBLE FILES----+-----------------+--FOR-----------> +-USER--user_ID---+ '-IN--table_name--' .-,----------------. V | >--------extender_name---+-------------------------------------><
Command parameters
Examples
List all the image files referenced by tables in the database, but are inaccessible:
get inaccessible files for db2image
List all the image files referenced in tables with the qualifier anita, but are inaccessible:
get inaccessible files user anita for db2image
List all the image files referenced by entries in the employee table, but are inaccessible:
get inaccessible files in employee FOR db2image
Usage notes
Connect to the database before using this command.
If you specify a table the command lists inaccessible files for that table. If you specify a qualifier, the command lists inaccessible files for only those tables with that qualifier. If you specify neither, the command lists inaccessible files for all the tables in the current database.