<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2 Transitional//EN">
<HTML>
<HEAD>
  <!--
    *************************************************************************************
    * Copyright (c) 2005 VERITAS Software Corporation. All rights reserved. *

      For third-party license citations, please see the bottom of this file.
    *************************************************************************************
  -->
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<meta name="TEMPLATEBASE" content="DocCD Manual Pages 1.4">
<meta name="LASTUPDATED" content="06/17/05 15:59:26">
<meta name="PRODUCTNAME" content="VERITAS Software Documentation">
<meta name="FILENAME" content="qio_getdbfiles.fm">
     
<title>qio_getdbfiles</title>

</HEAD>

<BODY bgcolor="#FFFFFF" link="#000066" vlink="#0000ff" marginheight="0" topmargin="0">
<basefont=1>

<a name="428550"></a>

<div align="left">
<table border="0" cellspacing="0" cellpadding="0" width="100%">
 <tr>
   <td height="2" border="0" cellspacing="0" cellpadding="0" colspan="2" bgcolor="#000000">
   </td>
 </tr>
 <tr>
   <td height="15" width="50%" border="0" cellspacing="0" cellpadding="0" bgcolor="#cccccc">
    <img src="images/vxsymbol.gif" height="20" width="31" border="0" cellspacing="0" cellpadding="0" align="left">
     
     
   </td>
   <td align="right" width="50%" bgcolor="#cccccc">

<!-- Header Breadcrumbs -->
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="-2">&lt;&nbsp;<a href="qio_convertdbfiles_sfora_man23_428852.html" title="Previous - qio_convertdbfiles">Previous</a>&nbsp;&nbsp;|&nbsp;&nbsp;<a href="qio_getdbfiles_ora_sfora_man25_428059.html" title="Next - qio_getdbfiles_ora">Next</a>
&nbsp;&gt;&nbsp;&nbsp;</font>
   </td>
 </tr>

 <tr>
  <td bgcolor="#CCCCCC" colspan="2" height="15" align="right">
  <font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="1">Product:  
<a href="sf_oracle_manpages_splashpage_docCD_sfora_man1_103036.vxhd" title="Oracle Manual Pages for Storage Foundation title page ">Oracle Manual Pages for Storage Foundation</a>
  &nbsp;&nbsp;
  </font>
  </td>
 </tr>
 <tr>
  <td bgcolor="#CCCCCC" colspan="2" height="15" align="right">
  <font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="1">Manual:  
<a href="man1m_titlepage_docCD_sfora_man2_73700.vxhd" title="Maintenance Commands (1m) title page ">Maintenance Commands (1m)</a>
  &nbsp;&nbsp;
  </font>
  </td>
 </tr>


</table>
</div>

<div align="left">
 <table border="0" width="100%" bgcolor="#FFFFFF">
  <tr>
   <td width="100%" valign="top" bgcolor="#FFFFFF">

<!-- Start Main Topic Content -->
        <a name="startcontent"></a>
	
<h2><font face="Arial, Helvetica, Geneva, sansserif, sans serif, Verdana" size="3" color="#000000"><a name="427471"></a>qio_getdbfiles</font>
</h2>

        

<h3><font face="Arial, Helvetica, Geneva, sansserif, sans serif, Verdana" size="2" color="#000000">
<a name="427501"></a> NAME</font>
</h3>
<p>
<a name="427506"></a><font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2">qio_getdbfiles - identify VxFS files to Quick I/O files </font>
</p>

<h3><font face="Arial, Helvetica, Geneva, sansserif, sans serif, Verdana" size="2" color="#000000">
<a name="427509"></a> SYNOPSIS</font>
</h3>
<br>
<font face="Courier, Courier New, sansserif, sans serif" size="2"><a name="427514"></a>For Oracle: <font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><b>qio_getdbfiles</b></font> [ <font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><b>-T</b></font> <em>database_type</em> ] [ <font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><b>-a</b></font> ] 
</font>
<br>
<font face="Courier, Courier New, sansserif, sans serif" size="2"><a name="427526"></a>For DB2: <font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><b>qio_getdbfiles</b></font> [ <font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><b>-T</b></font> <em>database_type</em> ] 
</font>
<br>
<font face="Courier, Courier New, sansserif, sans serif" size="2"><a name="427538"></a>For Sybase: <font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><b>qio_getdbfiles</b></font> [ <font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><b>-T</b></font> <em>database_type</em> ] [ <font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><b>-d</b></font> <em>database_name</em> ] | [ <font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><b>-m</b></font> <em>masterdevice_path</em> ] 
</font>

<h3><font face="Arial, Helvetica, Geneva, sansserif, sans serif, Verdana" size="2" color="#000000">
<a name="427559"></a> AVAILABILITY</font>
</h3>
<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="427564"></a>This command is part of VERITAS Storage Foundation <em>for Databases</em>. </font>
</p>


<h3><font face="Arial, Helvetica, Geneva, sansserif, sans serif, Verdana" size="2" color="#000000">
<a name="427567"></a> DESCRIPTION</font>
</h3>
<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="427572"></a>You can use the <font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><b>qio_getdbfiles </b></font>command to identify database files and then convert them to use Quick I/O with <font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><b>qio_convertdbfiles</b></font>. These two commands are for use with VxFS file systems only and  call the database-specific version of the conversion utility. </font>
</p>

<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="427611"></a>The <font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><b>qio_getdbfiles</b></font> command is available in the <font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><b>/opt/VRTSdbed/bin</b></font> directory for Oracle; the <font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><b>/opt/VRTSdb2ed/bin</b></font> directory for DB2; and the <font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><b>/opt/VRTSsybed/bin</b></font> directory for Sybase. </font>
</p>

<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="427632"></a>To use this command for Oracle, the <em>ORACLE_SID</em> environment variable must be set. </font>
</p>

<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="427644"></a>To use this command for DB2, the <em>DB2DATABASE</em> environment variable must be set. If <em>DB2INSTANCE</em> is not set, the script will assume the current user ID is <font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><b>DB2INSTANCE</b></font>. </font>
</p>

<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="427665"></a>To use this command for Sybase, the <em>SYBASE</em> and <em>DSQUERY </em>environment variables must be set. </font>
</p>

<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="427677"></a>While the database instance is up and running, run the <font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><b>qio_getdbfiles </b></font>command to get a list of files used by the database. This command stores the file names and sizes in bytes in a file called <font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><b>mkqio.dat</b></font>. The files listed in <font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><b>mkqio.dat</b></font> are converted to Quick I/O by the <font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><b>qio_convertdbfiles</b></font> command. If the database you want to gather this information about is not up and running, you can manually create the <font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><b>mkqio.dat </b></font>file. The format of this file is a list of paired file paths and file sizes. For example: </font>
</p>

<br>
<font face="Courier New, Courier, sansserif, sans serif" size="2"><a name="427794"></a><font face="Courier New, Courier, sansserif, sans serif" size="2">/database/dbfile.001&nbsp;1024000</font>
</font>
<br>
<font face="Courier New, Courier, sansserif, sans serif" size="2"><a name="427799"></a><font face="Courier New, Courier, sansserif, sans serif" size="2">/database/dbfile.002&nbsp;2048000</font>
</font>
<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="427809"></a>After running the <font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><b>qio_getdbfiles </b></font>command, shut down the database and run the <font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><b>qio_convertdbfiles </b></font>command to convert the list of file names in the <font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><b>mkqio.dat </b></font>file to Quick I/O files. For more information, see the <font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><b>qio_convertdbfiles</b></font>(1M) man page. </font>
</p>


<h3><font face="Arial, Helvetica, Geneva, sansserif, sans serif, Verdana" size="2" color="#000000">
<a name="427875"></a> OPTIONS</font>
</h3>
<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="427880"></a>The following options are supported by <font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><b>qio_getdbfiles</b></font>: </font>
</p>

<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="427884"></a><font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><b>-T</b></font> <em>database_type</em></font>
</p>
<p>
<a name="428904"></a><font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2">This option forces behavior for a specific database vendor. The database options that are currently supported are <font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><b>ora</b></font>, <font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><b>syb</b></font>, and <font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><b>db2</b></font>. Use this option in environments where the database to perform operations on is ambiguous. <font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><b>qio_getdbfiles</b></font> and <font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><b>qio_convertdbfiles </b></font>resolve ambiguity by examining the environment and searching for variable settings that are a prerequisite for using one or more database vendors' products. </font>
</p>
<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="427968"></a><font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><b>For Oracle:</b></font>  </font>
</p>

<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="427972"></a><font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><b>-a</b></font></font>
</p>
<p>
<a name="428927"></a><font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2">Includes all datafiles. By default, any database files that the <font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><b>qio_getdbfiles</b></font> command identifies as potential sparse files are excluded. This option should be used for debugging only, since sparse database files are not candidates for use with the Quick I/O driver. </font>
</p>
<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="428020"></a><font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><b>For DB2:</b></font>  </font>
</p>

<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="428024"></a>No options.</font>
</p>
<p>
<a name="428940"></a><font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2">Includes all datafiles. By default, any database files that the <font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><b>qio_getdbfiles</b></font> command identifies as potential sparse files are excluded. This option should be used for debugging only, since sparse database files are not candidates for use with the Quick I/O driver. </font>
</p>
<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="428027"></a><font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><b>For Sybase:</b></font>  </font>
</p>

<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="428031"></a><font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><b>-d</b></font> <em>database_name</em></font>
</p>
<p>
<a name="428971"></a><font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2">Includes files used by database devices. By default, all database device files that are part of the ASE server are included. Only Sybase database device files with the <font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><b>dsync</b></font> flag set to <font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><b>true</b></font> will be converted to Quick I/O. </font>
</p>
<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="428080"></a><font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><b>-m</b></font> <em>masterdevice_path</em></font>
</p>
<p>
<a name="429026"></a><font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2">Specifies the full pathname of the master device for the Sybase ASE server. In the Sybase ASE server, the master device physical pathname is stored as <font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><b>d_master</b></font> in the catalog. <font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><b>qio_getdbfiles</b></font> will attempt to obtain the master device's pathname from the default Sybase startup file <em>$SYBASE</em><font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><b>/ASE-12_0/install/RUN_</b></font><em>servername</em>. If, however, you do not use the standard startup file or the startup file is out of date, <font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><b>qio_getdbfiles</b></font> can put the wrong master device pathname in the <font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><b>mkqio.dat </b></font>file. You can use the <font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><b>-m</b></font> flag to pass in the correct master device path in such a situation. </font>
</p>
<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="428183"></a><font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><b>-h</b></font></font>
</p>
<p>
<a name="429045"></a><font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2">Shows command usage. </font>
</p>
<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="428196"></a>USAGEou must be logged in as the Database Administrator to run \fB<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><b>qio_getdbfiles\fP</b></font>. The \fB<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><b>qio_getdbfiles\fP</b></font> command queries the database to gather a list of datafiles to be converted, which requires direct access to the database. </font>
</p>
<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="428231"></a>For Sybase, <font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><b>qio_getdbfiles </b></font>connects to the Sybase ASE server via a Sybase <font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><b>sa</b></font> account. It is important to protect the <font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><b>sa</b></font> password so that it is not visible to other users. By default, <font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><b>qio_getdbfiles</b></font> will ask users to type in the Sybase <font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><b>sa</b></font> password. The Sybase tools used in the command will receive the password without displaying it on the screen. To run <font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><b>qio_getdbfiles</b></font> in a non-interactive mode, you can create a file <font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><b>/opt/VRTSsybed/.private/sa_password_</b></font><em>dataserver_name</em>, which contains the Sybase <font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><b>sa</b></font> password for the corresponding ASE server. <em>dataserver_name</em> is the content of the DSQUERY variable set by the user. Only the Sybase DBA user should have access to the <font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><b>.private</b></font> directory and <font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><b>sa_password_</b></font><em>dataserver_name</em> file. If the <font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><b>sa_password_</b></font><em>dataserver_name</em> file is present, <font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><b>qio_getdbfiles</b></font> will read the Sybase <font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><b>sa</b></font> password from the file and run in non-interactive mode. </font>
</p>


<h3><font face="Arial, Helvetica, Geneva, sansserif, sans serif, Verdana" size="2" color="#000000">
<a name="428388"></a> EXAMPLE</font>
</h3>
<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="428393"></a>This example shows the procedure for converting the files in a database to Quick I/O files. </font>
</p>

<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="428405"></a>Get information about the file: </font>
</p>

<br>
<font face="Courier New, Courier, sansserif, sans serif" size="2"><a name="428423"></a><font face="Courier New, Courier, sansserif, sans serif" size="2">$&nbsp;/opt/VRTSdbed/bin/qio_getdbfiles</font>
</font>
<br>
<font face="Courier New, Courier, sansserif, sans serif" size="2"><a name="428428"></a><font face="Courier New, Courier, sansserif, sans serif" size="2">$&nbsp;cat&nbsp;mkqio.dat</font>
</font>
<br>
<font face="Courier New, Courier, sansserif, sans serif" size="2"><a name="428433"></a><font face="Courier New, Courier, sansserif, sans serif" size="2">dbfile&nbsp;&nbsp;104800000</font>
</font>
<hr noshade size="2" width="100%" color="#000000">
<img src="images/note.gif" alt="Note " height="16" width="16">&nbsp;
<font face="Arial, Helvetica, Geneva, sansserif, sans serif, Verdana" size="2" color="#000000">
<a name="428443"></a><b>Note  &nbsp;&nbsp;</b>
</font>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2" color="#000000"> For Oracle, use <font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><b>VRTSdbed</b></font> in the command path; for DB2, use <font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><b>VRTSdb2ed</b></font>; and for Sybase, use <font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><b>VRTSsybed</b></font>. 
</font>
<hr noshade size="2" width="100%" color="#000000">
<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="428455"></a>Shut down the database and convert the file to Quick I/O: </font>
</p>

<br>
<font face="Courier New, Courier, sansserif, sans serif" size="2"><a name="428473"></a><font face="Courier New, Courier, sansserif, sans serif" size="2">$&nbsp;/opt/VRTSdbed/bin/qio_convertdbfiles</font>
</font>
<br>
<font face="Courier New, Courier, sansserif, sans serif" size="2"><a name="428483"></a><font face="Courier New, Courier, sansserif, sans serif" size="2">$&nbsp;ls&nbsp;-alL&nbsp;d*&nbsp;.d*</font>
</font>
<br>
<font face="Courier New, Courier, sansserif, sans serif" size="2"><a name="428488"></a><font face="Courier New, Courier, sansserif, sans serif" size="2">-rw-r--r--&nbsp;1&nbsp;admin&nbsp;dbgrp&nbsp;104857600&nbsp;May&nbsp;2&nbsp;13:42&nbsp;.dbfile</font>
</font>
<br>
<font face="Courier New, Courier, sansserif, sans serif" size="2"><a name="428493"></a><font face="Courier New, Courier, sansserif, sans serif" size="2">crw-r--r--&nbsp;1&nbsp;admin&nbsp;dbgrp&nbsp;45,&nbsp;1&nbsp;May&nbsp;3&nbsp;12:18&nbsp;dbfile</font>
</font>
<br>
<font face="Courier New, Courier, sansserif, sans serif" size="2"><a name="428503"></a><font face="Courier New, Courier, sansserif, sans serif" size="2">$&nbsp;ls&nbsp;-al&nbsp;d*&nbsp;.d*</font>
</font>
<br>
<font face="Courier New, Courier, sansserif, sans serif" size="2"><a name="428508"></a><font face="Courier New, Courier, sansserif, sans serif" size="2">-rw-r--r--&nbsp;1&nbsp;admin&nbsp;dbgrp&nbsp;104857600&nbsp;May&nbsp;2&nbsp;13:42&nbsp;.dbfile</font>
</font>
<br>
<font face="Courier New, Courier, sansserif, sans serif" size="2"><a name="428513"></a><font face="Courier New, Courier, sansserif, sans serif" size="2">lrwxrwxrwx&nbsp;1&nbsp;admin&nbsp;dbgrp&nbsp;17&nbsp;May&nbsp;3&nbsp;12:18&nbsp;dbfile&nbsp;-&gt;&nbsp;.dbfile::cdev:vxfs:</font>
</font>
<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="428523"></a>The <font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><b>qio_convertdbfiles</b></font> command renames the file <font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><b>dbfile</b></font> to <font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><b>.dbfile</b></font> and creates a symbolic link to <font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><b>.dbfile</b></font> with the Quick I/O extension. By default, the symbolic link uses a relative path name. </font>
</p>

<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="428526"></a>Start up the database. </font>
</p>

<hr noshade size="2" width="100%" color="#000000">
<img src="images/note.gif" alt="Note " height="16" width="16">&nbsp;
<font face="Arial, Helvetica, Geneva, sansserif, sans serif, Verdana" size="2" color="#000000">
<a name="428529"></a><b>Note  &nbsp;&nbsp;</b>
</font>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2" color="#000000"> If the server is up and running, you will receive an error message stating that you need to shut it down before you can run the <font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><b>qio_convertdbfiles </b></font>command. 
</font>
<hr noshade size="2" width="100%" color="#000000">

<h3><font face="Arial, Helvetica, Geneva, sansserif, sans serif, Verdana" size="2" color="#000000">
<a name="428550"></a> SEE ALSO</font>
</h3>
<blockquote>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="428555"></a><a href="qio_convertdbfiles_sfora_man23_428852.html#427625"><font color="#0000ff"><font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><b>qio_convertdbfiles </b></font></font></a>(1M), <a href="qio_recreate_sfora_man26_427226.html#426708"><font color="#0000ff"><font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><b>qio_recreate </b></font></font></a>(1M) </font>
</blockquote>
<blockquote>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="428576"></a>For Oracle: </font>
</blockquote>
<blockquote>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="428588"></a><a href="dbed_vxdba_sfora_man21_428716.html#427786"><font color="#0000ff"><font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><b>dbed_vxdba </b></font></font></a>(1M), <a href="oracle_edition_sfora_man33_427786.html#427093"><font color="#0000ff"><font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><b>oracle_edition </b></font></font></a>(7) </font>
</blockquote>
<blockquote>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="428612"></a><em>VERITAS Storage Foundation for Oracle Administrator's Guide </em></font>
</blockquote>
<blockquote>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="428624"></a>For DB2: </font>
</blockquote>
<blockquote>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="428636"></a><font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><b>db2ed_vxdba</b></font>(1M), <font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><b>db2_edition</b></font>(7) </font>
</blockquote>
<blockquote>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="428660"></a><em>VERITAS Storage Foundation for DB2 Administrator's Guide </em></font>
</blockquote>
<blockquote>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="428672"></a>For Sybase: </font>
</blockquote>
<blockquote>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="428684"></a><font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><b>sybase_edition</b></font>(7) </font>
</blockquote>
<blockquote>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="428696"></a><em>VERITAS Storage Foundation for Sybase Administrator's Guide </em></font>
</blockquote>

<!-- End Main Topic Content -->

   </td>
  </tr>
 </table>
</div>

<div>
<table border="0" cellspacing="0" cellpadding="0" width="100%">
 <tr>
  <td height="18" border="0" cellspacing="0" cellpadding="0" colspan="2" bgcolor="#FFFFFF">
  </td>
 </tr>
  <td align="left"><font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="-2">&nbsp;&#94;&nbsp;<a href="qio_getdbfiles_sfora_man24_428550.html" title="qio_getdbfiles">Return to Top</a></font>

  </td>
  <td align="right"><font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="-2">&lt;&nbsp;<a href="qio_convertdbfiles_sfora_man23_428852.html" title="Previous - qio_convertdbfiles">Previous</a>&nbsp;&nbsp;|&nbsp;&nbsp;<a href="qio_getdbfiles_ora_sfora_man25_428059.html" title="Next - qio_getdbfiles_ora">Next</a>
&nbsp;&gt;&nbsp;&nbsp;</font>
  </td>
 <tr>
   <td height="9" border="0" cellspacing="0" cellpadding="0" colspan="2" bgcolor="#FFFFFF">
   </td>
 </tr>

<!-- Footer Breadcrumbs -->
<tr>
<td bgcolor="#FFFFFF" colspan="2" height="15" align="right">
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="1">Product:  
<a href="sf_oracle_manpages_splashpage_docCD_sfora_man1_103036.vxhd" title="Oracle Manual Pages for Storage Foundation title page ">Oracle Manual Pages for Storage Foundation</a>&nbsp;&nbsp;</font></td>
</tr>

<tr>
<td bgcolor="#FFFFFF" colspan="2" height="15" align="right">
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="1">Manual:  
<a href="man1m_titlepage_docCD_sfora_man2_73700.vxhd" title="Maintenance Commands (1m) title page ">Maintenance Commands (1m)</a>&nbsp;&nbsp;</font></td>
</tr>


 <tr>
  <td colspan="2" align="left"><font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" color="#000000" align="right" size="-2">
<em>VERITAS Software Corporation
</em></font><br>

<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="-2">www.veritas.com</font><br>
  </td>
 </tr>
</table>
</div>

</BODY>
  <!--
    *************************************************************************************
    * Copyright (c) 2005 VERITAS Software Corporation. All rights reserved. *

    VERITAS, VERITAS SOFTWARE, the VERITAS Logo, and VERITAS Software Documentation 
    are trademarks or registered trademarks of VERITAS Software Corporation 
    or its affiliates in the U.S. and other countries. Other names may be 
    trademarks of their respective owners. 

    Apache Jakarta Lucene:
    Apache Software License
    Version 1.1

    Copyright (c) 2000 The Apache Software Foundation. All rights reserved.

    Redistribution and use in source and binary forms, with or without modification, 
    are permitted provided that the following conditions are met:

    1. Redistributions of source code must retain the above copyright notice, this 
    list of conditions and the following disclaimer.

    2. Redistributions in binary form must reproduce the above copyright notice, this 
    list of conditions and the following disclaimer in the documentation and/or other 
    materials provided with the distribution.

    3. The end-user documentation included with the redistribution, if any, must include 
    the following acknowledgment: "This product includes software developed by the Apache 
    Software Foundation (http://www.apache.org/)." Alternately, this acknowledgment may 
    appear in the software itself, if and wherever such third-party acknowledgments 
    normally appear.

    4. The names "Apache" and "Apache Software Foundation" must not be used to endorse or 
    promote products derived from this software without prior written permission. For 
    written permission, please contact apache@apache.org.

    5. Products derived from this software may not be called "Apache", nor may "Apache" 
    appear in their name, without prior written permission of the Apache Software Foundation.

    THIS SOFTWARE IS PROVIDED "AS IS" AND ANY EXPRESSED OR IMPLIED WARRANTIES, INCLUDING, 
    BUT NOT LIMITED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A 
    PARTICULAR PURPOSE ARE DISCLAIMED. IN NO EVENT SHALL THE APACHE SOFTWARE FOUNDATION 
    OR ITS CONTRIBUTORS BE LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL, SPECIAL, EXEMPLARY, 
    OR CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS 
    OR SERVICES; LOSS OF USE, DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND 
    ON ANY THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT (INCLUDING 
    NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE OF THIS SOFTWARE, EVEN IF 
    ADVISED OF THE POSSIBILITY OF SUCH DAMAGE.

    This software consists of voluntary contributions made by many individuals on behalf 
    of the Apache Software Foundation. For more information on the Apache Software Foundation, 
    please see <http://www.apache.org/>. Portions of this software are based upon public domain 
    software originally written at the National Center for Supercomputing Applications, University 
    of Illinois, Urbana-Champaign.
    
    This product includes WebWindow Software developed by Horst Heistermann.
    *************************************************************************************
  -->
</HTML>
