SHOW-FT-LOGGING-RECORDS - Display logging records

With FTAC functionality, you can use SHOW-FT-LOGGING-RECORDS to also display the FTAC log records of your own user ID. Even FT administrators can only display those FTAC log records which refer to their own user IDs. The FTAC administrator is the only user who can display all FTAC log records on the system.

If you call HELP for the SDF command syntax shown below, you may also see some operands that are not indicated here. This is because only the operands relevant for FTP are described in this section.

SHOW-FT-LOGGING-RECORDS - showing operands relevant for FTP

SELECT = *OWN / *ALL / *PARAMETERS(...)
	*PARAMETERS(...)
		|	LOGGING-ID = *ALL / <alphanum-name 1..12> / *INTERVAL(...)
		|		*INTERVAL(...)
		|			|	FROM = 1 / <alphanum-name 1..12>
		|			|	,TO = *HIGHEST-EXISTING / <alphanum-name 1..12>
		|	,OWNER-IDENTIFICATION = *OWN / *ALL / <name 1..8>
		|	,CREATION-TIME = *INTERVAL (...) / *DAYS(...)
		|		*INTERVAL(...)
		|			|	FROM = 1970-01-01 (...) / <date 8..10> (...)
		|			|		(...)
		|			|			|	TIME = 00:00 / <time 1..8>
		|			|	,TO = *TOMOR ROW (...) / *TODAY (...) / <date 8..10> (...)
		|			|		(...)
		|			|			|	TIME = 00:00 / <time 1..8>
		|		*DAYS(...)
		|			|	NUMBER = <integer 1..1000>
		|	,RECORD-TYPE = *ALL / *PARAMETERS(...)
		|		*PARAMETERS(...)
		|			|	,FTAC = ( *TRANS FER -F ILE, *READ-FILE-ATTRIBUTES,*DEL ETE -FILE,
		|			|				*CRE ATE- FILE , *MOD IFY- FILE-ATTR IBUTES,
		|			|				*READ-DIRECTORY,*MOVE-FILE,*CREATE-DIRECTORY,
		|			|				*DELETE-DIRECTORY,*MODIFY-DIRECTORY. *LOGIN ) / *NONE /
		|			|				list-poss(11): *TRANSFER-FILE / *READ-FILE-ATTRIBUTES / *DELETE-FILE /
		|			|				*CREATE-FILE / *MODIFY-FILE-ATTRIBUTES / *READ-DIRECTORY /
		|			|				*MOVE-FILE / *CREATE-DIRECTORY / *DELETE-DIRECTORY /
		|			|				*MODIFY-DIRECTORY / *LOGIN
		|	,INITIATOR = (*LOC AL, *REMOTE) / *REMOTE
		|	,PARTNER-NAME = *ALL / <text 1..200 with-low>
		|	,FILE-NAME = *ALL / <filename 1..54> / <filename-prefix 2..53> /
		|					<c-string 1..512 with-low> / *DIRECTORY(...) / *POSIX(NAME=<posix-pathname 1..510>)
		|		*DIRECTORY(...)
		|			|	NAME = *ALL / <partial-filename 1..53> / <c-string 1..512 with-low>
		|	,REASON-CODE = *ALL / *FAILURE / <text 1..4>
		|	,TRANSFER-ID = *ALL / <integer 1.. 2147483639>
,NUMBER = 1 / *ALL / <integer 1..99999999>
,INFORMATION = *STD / *ALL
,OUTPUT = *SYSOUT (LAYOUT = *STD / *CSV ) /
				*SYSLST (LAYOUT = *STD / *CSV)

Operands

SELECT=

Used to select a group of log records.

SELECT=*OWN /*ALL
Selects log records under the user’s own user ID. If no other selection criteria are specified, the most recent log record under the user’s own user ID is displayed. The entries *OWN and *ALL generate the same output.

SELECT=*PARAMETERS(...)

LOGGING-ID=

Specifies the number of the log record.

LOGGING-ID=*ALL
The number of the log record is not a selection criterion.

LOGGING-ID=<alphanum-name 1..12>
Number of the log record to be output. The value range for the logging ID is from 1 through 999999999999.

LOGGING-ID=*INTERVAL(...)
Range of log records to be output.

FROM=<alphanum-name 1..12>
First log record to be output. The value range for the logging ID is from 1 through 999999999999.

TO=*HIGHEST-EXISTING / <alphanum-name 1..12>
Last log record to be output. The value range for the logging ID is from 1 through 999999999999.

OWNER-IDENTIFICATION=
Specifies the user ID of the user whose log records are to be displayed.

OWNER-IDENTIFICATION=*OWN
Shows the log records of the user’s own ID.

OWNER-IDENTIFICATION=*ALL
Shows the log records of all user IDs. This operand can be used by the FTAC administrator to display the FTAC log records for all user IDs.
Normal FTP users receive information only on the log records of their own user IDs even if they select this entry.

OWNER-IDENTIFICATION=<name 1..8>
Any user ID for which the log records are to be output.
Normal FT users may only specify their own user IDs.

CREATION-TIME=*INTERVAL(...)
Selects a range of log records to be output by specifying a creation date.

FROM=1970-01-01(...) / < date 8..10>(...)
Date in the format yyyy-mm-dd or yy-mm-dd, e.g. 2004-01-29 or 04-01-29 for the 29th of January, 2004. FT then displays all log records written after the specified date and time.

TIME=00:00 / <time 1..8>
Time for the day specified with CREATION-TIME. FT displays all log records written after the specified time. The time is entered in the format hh:mm:ss, e.g. 14:30:10.

TO=*TOMORROW / *TODAY(...) / <date 8..10>(...)
Date in the format yyyy-mm-dd or yy-mm-dd, e.g. 2004-01-29 or 04-01-29 for the 29th of January, 2004. FT then displays all log records written up to the specified date and time.

TIME=00:00 / <time 1..8>
Time for the day specified with CREATION-TIME. FT displays all log records written up to the specified time. The time is entered in the format hh:mm:ss, e.g. 14:30:10.

CREATION-TIME = *DAYS(NUMBER=<integer 1..1000>)
This field is specified in number of days. All logging sets that were created in the last n calendar days, including today, are output.

RECORD-TYPE=
Defines which type of log record is to be displayed.

RECORD-TYPE=*ALL
The record type is not a selection criterion.

RECORD-TYPE=*PARAMETERS(...)
The type of the log record.

FTAC=
(*TRANSFER-FILE, *READ-FILE-ATTRIBUTES, *DELETE-FILE, *CREATE-FILE, *MODIFY-FILE-ATTRIBUTES, *READ-DIRECTORY, *MOVE-FILE, *CREATE-DIRECTORY, *DELETE-DIRECTORY, *MODIFY-DIRECTORY / *LOGIN) / *NONE / list-poss(11): *TRANSFER-FILE / *READ-FILE-ATTRIBUTES / *DELETE-FILE / *CREATE-FILE / *MODIFY-FILE-ATTRIBUTES / *READ-DIRECTORY / *MOVE-FILE / *CREATE-DIRECTORY / *MODIFY-DIRECTORY / *DELETE-DIRECTORY / *LOGIN
Specifies whether or not FTAC log records are to be output. If yes, it can also be specified for which FTP functions the FTAC log records are to be output. In this case, the following definitions apply:

*TRANSFER-FILE

All log records for the function “transfer files” are shown. This corresponds to the server commands retr, stor, stou and appe.

*READ-FILE-ATTRIBUTES

All logging records for the function “Read file attributes” are displayed.

*DELETE-FILE

All log records for the function “delete files” are shown. This corresponds to the server command dele.

*CREATE-FILE

All log records for the function “create files” are shown. This corresponds to the server command site file.

*MODIFY-FILE-ATTRIBUTES

All log records for the function “modify file attributes” are shown. This corresponds to the server command rnfr.

*READ-DIRECTORY

All log records for the function “read directories” are shown. This corresponds to the server commands cwd, xcwd, list, mlsd, mlst, nlst, pwd, xpwd, cdup, xcup, size and mdtm.

*MOVE-FILE

All logging records for the function “Copy and delete files” are displayed.

*CREATE-DIRECTORY

All log records for the function “create directory” are shown. This corresponds to the server commands mkd and xmkd.

*DELETE-DIRECTORY

All log records for the function “delete directory” are shown. This corresponds to the server commands rmd and xrmd.

*MODIFY-DIRECTORY

All logging records for the function “Modify directory” are displayed.

*LOGIN

All logging records for the function “Inbound FTP access” are displayed. Log records of the type *LOGIN are only written in the case of an incorrect transfer admission.

INITIATOR=
Selects log records by the initiator.

INITIATOR=(*LOCAL,*REMOTE)
The initiator is not a selection criterion.

INITIATOR=*REMOTE
This corresponds to the default value, since FTP requests are always remote requests.

PARTNER=
Client system.

PARTNER=*ALL
The client system is not a selection criterion.

PARTNER=<text 1..200 with-low>
The client system for which log records are to be shown. For more information on address specifications, see „openFT (BS2000) -  Command Interface“.

FILE-NAME=
File name.

FILE-NAME=*ALL
The file name is not a selection criterion.

FILE-NAME=<full-filename 1..54> / <c-string 1..512 with-low> / *POSIX(NAME=posix_pathname_1..510)

Fully qualified name of the files for which you want to view the log records.

FILE-NAME=<partial-filename 2..53>
Partially qualified name of the files for which you want to view the log records.

FILE-NAME = *DIRECTORY(...)
Name of the directory.

*DIRECTORY(...)
The directory specification relates to the corresponding specification in the SHOW-REMOTE-FILE-ATTRIBUTES command (see „openFT (BS2000) - Command Interface“).

NAME = *ALL
The directory is not a selection criterion

NAME = <partial-filename 1..53> / <c-string 1..512 with-low>
Name of the directory. Directories are represented by partially qualified file names in DVS.

REASON-CODE=
Selects log records by the REASON code.

REASON-CODE=*ALL
The REASON code is not a selection criterion; all records are shown.

REASON-CODE=*FAILURE
All log records with error codes are shown.

REASON-CODE=<text 1..4>
Defines which log records to be shown by specifying the error codes. Leading zeros may be omitted (e.g. 14 for 0014).

TRANSFER-ID =
Selection on the basis of the request ID.

TRANSFER-ID = *ALL
The request ID is not used as a selection criterion.

TRANSFER-ID = <integer 1..2147483639>
Only outputs log records for the specified request ID.

NUMBER=
The maximum number of log records to be shown.

NUMBER=1 / <integer 1..99999999>
The maximum permissible number of log records that can be displayed. By default, only one log record is shown.

NUMBER=*ALL
All log records are shown.

INFORMATION=
Scope of the required information.

INFORMATION=*STD
Only the standard information is shown for the log records.

INFORMATION=*ALL
The log records are shown in their entirety (long form).

OUTPUT=
Determines the output medium.

OUTPUT=*SYSOUT(...)
The output is sent to SYSOUT.

OUTPUT=*SYSLST(...)
The output is sent to SYSLST.

LAYOUT=*STD
The output is formatted using a standard layout that can be easily read by the user.

LAYOUT=*CSV
The output is supplied in CSV (Comma Separated Value) format. This is a widely used tabular format, especially in the PC environment, in which individual fields are separated by a delimiter, which is usually a semicolon “;”.

Description of the output fields

Short output form of an FT logging record (example)

/SHOW-FT-LOGGING-RECORDS NUMBER=2
%TYP LOGG-ID TIME    RC    PARTNER  INITIATOR INIT USER-ADM FILENAME
%2010-06-22
%PM    3283 18:26:59 0000 <G133H301 *REMOTE        FT2V292  TEST2
%P     3212 11:33:53 0000 >G133H301 *REMOTE        FT2V292  TEST1

Long output form (example)

/SHOW-FT-LOGGING-RECORDS NUMBER=2,INFORMATION=*ALL
%LOGGING-ID  = 00003283  RC     = 0000       TIME    = 2010-06-22 18:26:59
%   INITIATOR= *REMOTE   PARTNER = G133H301   REC-TYPE = FTAC(FTP)
%   INITSN   =           TRANS   = FROM       FUNCTION = MODIFY-FILE-ATTR
%   USER-ADM = FT2V292   PROFILE = Z          PRIV     = NO
%   FILENAME = TEST2
%LOGGING-ID  = 00003212  RC     = 0000       TIME    = 2010-06-22 11:33:53
%   INITIATOR= *REMOTE   PARTNER = G133H301   REC-TYPE = FTAC(FTP)
%   INITSN   =           TRANS   = TO         FUNCTION = TRANSFER-FILE
%   USER-ADM = FT2V292   PROFILE = Z          PRIV     = NO
%   FILENAME = TEST1

Explanation

Identifier		Explanation
TYP (column 1)  or  REC-TYPE		Indicates whether an FT or FTAC log record is involved. In the short output form, the first column T indicates the FT log record; C indicates the FTAC log records, and P indicates the FTP-specific FTAC log record; in the long output form (REC-TYPE), these details are written out in full.
TYP (column 2‑3) or FUNCTION		Definition of FT function:
		V A D C M R CD MD DD L	transfer file transfer file and delete send file (only inbound possible) read file attributes delete file create file modify file attributes read directory create director modify directory delete directory login (inbound FTP access)
LOGG-ID or LOGGING-ID		Number of the log record (max. 12 positions)
TIME		Time when the log record was written
RC		Reason Code. Indicates if a request was successfully executed, and if not, why it was rejected or terminated. If an FTP request is rejected for “FTAC reasons” (e.g. 0014), the precise reason for the termination can be found in the FTAC log record. Further information on the reason code can be obtained by using the BS2000 command HELP-MSG-INFORMATION.
PARTNER		Returns information on the client system involved. The output shows the possibly abbreviated symbolic name with up to eight characters. In the short form, the client system name is preceded by an identifier from which you can determine the direction of the request.
TRANS=TO or > with PARTNER		The transfer direction is to the client system.This direction is specified for a - send request - request to view remote file attributes - request to view remote directories
TRANS=FROM or < with PARTNER		The transfer direction is to the local system. This direction is specified for a - receive request - request to modify remote file attributes - request to delete remote files
TRANS	BOTH	The transfer direction is to the client system and to the local system.
INITIATOR		Initiator of the request; for FTP, always *REMOTE
INIT or INITSN		For FTP, this field is always empty.
USER-ADM		User ID referenced by the requests on the local system.
FILENAME		File name on the local system
PROFILE		Admission profile used
PRIV	*NO	Non-privileged admission profile
	*YES	Privileged admission profile

Command return codes

(SC2)	SC1	Maincode	Meaning/Guaranteed messages
0	0	CMD0001	No log records available for the selection criteria.
33	32	CMD0221	Request rejected. Internal error.
36	32	CMD0221	Request rejected. Request data inconsistent.
83	32	CMD0221	Internal error
88	32	CMD0221	Error during OPS generation.
36	64	FTR1036	User not authorized for other user IDs,
2	0	FTR2225	Information output cancelled.

SC1/2 = Subcode 1/2 in decimal form
More information can be found in the manual “openFT - Command Interface”.

Example

You want to view all log records created under your user ID before 01.01.11.

/SHOW-FT-LOGGING-RECORDS SELECT=*PARAMETERS(LOGGING-DATE=2011-01-01), NUMBER=*ALL

All log records entered before 00:00 on 01.01.11 are displayed.

You now want to display the first record of this output in detail.

/SHOW-FT-LOG-REC (LOG-DATE=2011-01-01),INF=*ALL