This appendix lists and defines the member names in the LOG
, ORA
, and TRC
gateway library files
This appendix contains the following sections:
Members are listed for the following file types:
The LOG
file contains the LISTENER
member, which is the default log output member for the Oracle Net TCP/IP listener.
To display this member on the AS/400, use the following command:
WRKMBRPDM instance_name/LOG
where instance_name
is the name that is used for the gateway when it is installed.
In the LOG file, which is in the instance library, the LISTENER
member records information about the startup of the listener and also records information about every connection attempt that is made to the associated instance. The file can get quite large over time, and you should therefore occasionally clear out the LISTENER
member entries by using the CLRPFM FILE
command. To issue the command, you need to sign on to your iSeries computer with either the QSECOFR
ID or the instance ID and then enter the following command:
CLRPFM FILE(instance_name/LOG) MBR(LISTENER)
The LISTENER
member can also be displayed using the WRKTRCLOG
command. The gateway instance library should be in the library list when you use the WRKTRCLOG
command.
The ORA
file contains the following members:
Member LISTENER
contains the parameter values for the listener. The values in this file should not be changed directly with an AS/400 editor. The most commonly used parameters can be changed with the CHGORANET
command. All other values must be changed in the ORA(LISTENER_CHG)
file. Refer to "CHGORANET, Change Network Parameters" for more information.
Member LISTENER_CHG
is used to make changes to the ORA(LISTENER)
file. Refer to "CHGORANET, Change Network Parameters" for more information.
Member LISTENLOCK
is the ORA(LISTENLOCK)
member. It is used to ensure that only one instance of the RUNORALSN
program is running. The RUNORALSN
program runs the TCP/IP listener. Do not modify this file.
Member SQLNET contains the network parameter values for Oracle Net. The values in this file should not be changed directly with an AS/400 editor. The most commonly used parameters can be changed with the CHGORANET
command. All other values must be changed in the ORA(SQLNET_CHG)
file. Refer to "CHGORANET, Change Network Parameters" for more information.
Member SQLNET_CHG
is used to make changes to the ORA(SQLNET)
file. Refer to "CHGORANET, Change Network Parameters" for more information.
To display these members on the AS/400, use the following command:
WRKMBRPDM instance_name/ORA
where instance_name
is the name that is used for the gateway when it is installed. You may also use the command WRKTRCLOG
, but you must first make sure that the instance library is in the library list before using this command.
The TRC file contains the following members, where xxxxxx
is numeric (the job number):
LIST
xxxxxx
is the default trace output file for the Oracle Net TCP/IP listener, where xxxxxx
is the job number of the listener.
SERV
xxxxxx
is the Oracle Net trace for server job number xxxxxx.
To display these members on the AS/400, use the following AS/400 command:
WRKMBRPDM instance_name/TRC
where instance_name
is the name that is used for the gateway when it is installed. Alternatively, you may use the command WRKTRCLOG
, but you must first make sure that the instance library is in the library list before using this command.
There is a .ORA
file, CALL_NAMES.ORA
, in the IFS. This file is used in conjunction with DB2/400 SQL User Defined Functions (UDF) that are to be called through the gateway. Oracle must be aware of all the DB2/400 UDFs. An attempt to use a UDF that does not appear in this file will result in an ORA-06571 error. The file is located at /home/myinst/rdbms/admin/call_names.ora where 'myinst' is the name of your gateway instance. The file may be edited with the EDTF system editor. The names of the UDFs are found in this file, at most one name in each line. The name may be qualified by the name of the library in which a UDF resides, e.g., "MYORAINST.MYFUNC
".
Agent trace files are now located within the integrated file system in the directory /home/myinst
/rdbms/log, where myinst
is the instance name. The file names are of the form myinst_agt_nnnnnn.trc,
where myinst
is the instance name, and nnnnnn
is the job number. To display these files, use the WRKTRCLOG
command, but ensure that the instance library is in the library list before doing so.