InfoScale™ 9.0 Storage and Availability Management for DB2 Databases - AIX, Linux

To list all files on the current file system, including Quick I/O files and their links

• Use the ls -al command with the file names:

  $ ls -al filename .filename

  The following example shows how to use the -a option to display the absolute path name created using qiomkfile:

  $ ls -al d* .d*

  For DB2:

  -rw-r--r--	 1 db2inst1 db2iadm1 104890368		Oct 2 13:42		.dbfile
  

  lrwxrwxrwx	 1 db2inst1 db2iadm1 	 19		     Oct 2 13:42	 	dbfile -> 
   .dbfile::cdev:vxfs:
  

  For Sybase:

  -rw-r--r--		1 sybase 	sybase 	104890368		Oct 2 13:42		.dbfile
  

  lrwxrwxrwx		1 sybase  sybase 	   19		    Oct 2 13:42		 dbfile ->
   .dbfile::cdev:vxfs:
  

To determine if Quick I/O is installed and enabled for DB2

• Use the ls command as follows:

  $ ls -lL filename

  The following example shows how to determine if Quick I/O is installed and enabled:

  $ ls -lL dbfile

  where the first character, c, indicates it is a raw character device file, and the major and minor device numbers are displayed in the size field. If you see a No such file or directory message, Quick I/O did not install properly or does not have a valid Veritas InfoScale Enterprise and Storage license keys.

To determine if a Sybase segment has been converted to Quick I/O

• Use the ls command as follows:

  $ ls -lL filename

  The following example shows how to determine if Quick I/O is installed and enabled:

  $ ls -lL dbfile

  crw-r--r--			1 sybase 	dba		45, 1		Oct 2 13:42		dbfile
  

To show a Quick I/O file resolved to a raw device

• Use the ls command with the file names as follows:

  $ ls -alL filename .filename

  The following example shows how the Quick I/O file name dbfile is resolved to that of a raw device:

  $ ls -alL d* .d*

  For DB2:

  crw-r--r--			1 db2inst1 db2iadm1	45,  1 	 			  Oct 2 13:42				dbfile
  

  -rw-r--r--			1 db2inst1 db2iadm1	104890368				 Oct 2 13:42				.dbfile
  

  For Sybase:

  crw-r--r--			1 sybase 	 sybase 	 45,  1 	 			  Oct 2 13:42				dbfile
  

  -rw-r--r--			1 sybase 	 sybase			104890368				 Oct 2 13:42				.dbfile