Database server files

Database server files are created in default directories, or in a directory that the relevant configuration parameter specifies. A database administrator might need to edit or examine the content of files that are used by the database server.

  • Table 1 lists database server files that you might need to look at, copy, edit, move, or delete (except where noted).
  • Table 2 lists database server files that are for internal use only. You must not edit, move, or delete these files.
Table 1. Database server files that you can use. This table lists the files that you might refer to or use when you configure and use the database server.
File name Directory Purpose Created
af.xxx

xxx identifies a specific assertion failure

$INFORMIXDIR/tmp (UNIX)

%INFORMIXDIR%\tmp (Windows)

Specified by DUMPDIR configuration parameter

Assertion-failure information By the database server
ac_msg.log /tmp (UNIX)

%INFORMIXDIR%\etc (Windows)

The message log for the archecker utility By the database server
ac_config.std $INFORMIXDIR/etc (UNIX)

%INFORMIXDIR%\etc (Windows)

Template for archeckerparameter values By the database server
bar_act.log /tmp (UNIX)

%INFORMIXDIR%\etc (Windows)

Specified by the BAR_ACT_LOG configuration parameter

ON-Bar activity log By ON-Bar
bar_dbug.log /usr/informix/ (UNIX)

\usr\informix\ (Windows)

Specified by the BAR_DEBUG_LOG configuration parameter

ON-Bar debug log By ON-Bar
bldutil.process_id (UNIX)

bldutil.out (Windows)

/tmp (UNIX)

\tmp (Windows)

Error messages about building the sysutils database By the database server
buildsmi.out (UNIX)

buildsmi_out.%INFORMIXSERVER% (Windows)

/tmp (UNIX)

%INFORMIXDIR%\etc (Windows)

Error messages about building the sysmaster database By the database server
concdr.sh $INFORMIXDIR /etc/conv (UNIX)

%INFORMIXDIR% \etc\conv (Windows)

Converts the syscdr database during an upgrade By the database server
core (UNIX) Directory from which the database server was started Core dump By the database server
gcore.xxx (UNIX) $INFORMIXDIR/tmp (UNIX)

%INFORMIXDIR%\tmp (Windows)

Specified by DUMPDIR configuration parameter

Assertion failure information By the database server
.informix (UNIX) User's home directory Set personal environment variables By the user
informix.rc (UNIX) $INFORMIXDIR/etc Set default environment variables for all users By the database administrator
InstallServer.log (Windows) C:\temp Database server installation log By the database server
ixbar.servernum $INFORMIXDIR/etc (UNIX)

%INFORMIXDIR%\etc (Windows)

Emergency boot file that is used in a cold restore By ON-Bar
jvp.log /urs/informix

Specified by JVPLOGFILE configuration parameter

Messages from the Java™ virtual processor By the database server
.jvpprops urs/informix/extend/krakatoa

Specified by JVPPROPFILE configuration parameter

Template for Java VP properties During installation
oncfg_ servername.servernum $INFORMIXDIR/etc (UNIX)

%INFORMIXDIR%\etc (Windows)

Configuration information for whole-system restores by ON-Bar By the database server
online.log $INFORMIXDIR/tmp (UNIX)

%INFORMIXDIR% (Windows)

Specified by the MSGPATH configuration parameter

Database server message log, which contains error messages and status information By the database server
onconfig $INFORMIXDIR/etc (UNIX)

%INFORMIXDIR%\etc (Windows)

Configuration information By the database administrator or the database server administrator
onconfig.std $INFORMIXDIR/etc (UNIX) Template for configuration parameter values
Important: Do not move, modify, or delete the onconfig.std file unless instructed to do so by IBM Software Support. However, you may make a copy of the onconfig.std file to create a customized configuration file, and then move the copy to another location.
During installation
onsnmp.servername /tmp (UNIX)

\tmp (Windows)

Log file that the onsnmp subagent uses By the onsnmp utility
onsrvapd.log /tmp (UNIX)

\tmp (Windows)

Log file for the database server daemon onsrvapd By the onsnmp utility
psm_act.log /tmp (UNIX)

%INFORMIXDIR%\etc (Windows)

Specified by the PSM_ACT_LOG configuration parameter

Log file for Informix® Primary Storage Manager By ON-Bar
pua.map $INFORMIXDIR/gls/etc (UNIX)

%INFORMIXDIR%\gls\etc\(Windows)

Mapping file for displaying characters in Unicode Private-Use Area (PUA) ranges. By the user
revcdr.sh (UNIX)

revcdr.bat (Windows)

$INFORMIXDIR/etc/conv (UNIX)

%INFORMIXDIR%\etc\conv(Windows)

Reverts the syscdr database to an earlier format By the database server
shmem.xxx $INFORMIXDIR/tmp (UNIX)

%INFORMIXDIR%\tmp (Windows)

Specified by DUMPDIR configuration parameter

Assertion-failure information By the database server
sm_versions.std $INFORMIXDIR/etc (UNIX)

%INFORMIXDIR%\etc (Windows)

Identifies storage manager in use During installation
snmpd.log /tmp (UNIX)

\tmp (Windows)

Log file for the SNMP master agent, snmpdm By onsnmp
sqlhosts.servername $INFORMIXDIR/etc

%INFORMIXDIR%\etc (Windows)

Connection information During installation; modified by the database server administrator

The file extension is the server name (the default extension is ol_informixversion)

sqlhosts.std $INFORMIXDIR/etc (UNIX)

%INFORMIXDIR%\etc (Windows)

Template for connection information During installation
Table 2. Database server files that are for internal use only. This table lists the files that are required by the database server.
Important: Do not move, modify, or delete these files unless instructed to do so by IBM Software Support.
File name Directory Purpose Created
.conf.dbservername $INFORMIXDIR/etc (UNIX)

%INFORMIXDIR%\etc (Windows)

The onsnmp utility uses this file to obtain the database server configuration By the database server
illlsrra.xx $INFORMIXDIR/lib (UNIX)

%INFORMIXDIR%\lib (Windows)

Shared libraries for the database server and some utilities By installation procedure
INFORMIXTMP /INFORMIXTMP (UNIX)

\%INFORMIXDIR% (Windows)

Temporary directory for internal files By the database server
.inf.servicename /INFORMIXTMP (UNIX)

drive:\INFORMIXTMP (Windows)

Connection information By the database server
.infos.dbservername $INFORMIXDIR/etc (UNIX)

%INFORMIXDIR%\etc (Windows)

Connection information By the database server
.infxdirs /INFORMIXTMP (UNIX)

drive:\INFORMIXTMP (Windows)

Database server discovery file that onsnmp uses By the database server
JVM_vpid Specified by JVPLOG configuration parameter Messages that the Java virtual machine generates By the Java virtual machine
servicename.exp /INFORMIXTMP (UNIX)

drive:\INFORMIXTMP (Windows)

Connection information By the database server
servicename.str /INFORMIXTMP (UNIX)

drive:\INFORMIXTMP ( Windows)

Connection information By the database server
VP.servername.nnx /INFORMIXTMP (UNIX)

drive:\INFORMIXTMP (Windows)

Connection information By the database server

Copyright© 2019 HCL Technologies Limited