Job Management Partner 1/Base User's Guide

[Contents][Glossary][Index][Back][Next]

8.3.2 Items output to the CSV file

The following explains the items that are output from the event database to a CSV file. The items that are actually output to the file depend on whether you specified the -k option when executing the jevexport command.

The output items in each case are listed separately below.

Organization of this subsection
(1) Items output when the -k option is specified in the jevexport command
(2) Items output when the -k option is omitted in the jevexport command

(1) Items output when the -k option is specified in the jevexport command

If you specify the -k option when executing the jevexport command, the extended attributes (program-specific information) specified in the items file are output to the CSV file. The items are output from column 28 in the same order as specified in the items file. Each item is output as an extended attribute name paired with its value. If a non-existent extended attribute is written in the items file, a null value is output to the corresponding column for that item.

The following table lists the items that are output when the -k option is specified in the jevexport command. The title name is output when the -a option is specified.

Table 8-1 Items output when the -k option is specified in the jevexport command

Col. Attribute name Title name Contents Format Remarks
1 Serial number Serial number Order in which events (including local events) arrive at this event server, regardless of the source. This attribute is not preserved for JP1 event transfers between event servers. This attribute is mainly used to prevent delays or duplication when a user program acquires JP1 events or when JP1/Base forwards a JP1 event to another event server. Number --
2 ID (basic code) Event ID(basic code) Basic code of the event ID. An event ID is expressed as an eight-byte value. The upper four bytes represent the basic code. Number Hexadecimal of 1 to 8 digits
3 ID (extended code) Event ID(extended code) Extended code of the event ID. The lower four bytes represent the extended code. Number Hexadecimal of 1 to 8 digits
4 PROCESSID Source process ID Process ID of the application program that issued the event. Number Number
5 TIME Registered time Time of event registration on the source event server (based on the source host clock). Number Cumulative seconds since UTC 1970-01-01 00:00:00
6 ARRIVEDTIME Arrived time Time an event was registered on the local event server. This attribute is not preserved for JP1 event transfers between event servers. Number Cumulative seconds since UTC 1970-01-01 00:00:00
7 REASON Registered reason Reason for registration of the JP1 event on this event server. This attribute is not preserved for JP1 event transfers between event servers. One of the following codes is set:

1:
Event issued by the local event server to the local event server

3:
Event issued by the remote event server to the local event server

4:
Event forwarded from the remote event server to the local event server according to the environment settings
 Number --
8 USERID Source user ID User ID of the source process. Number In Windows and Java, set to a fixed value (-1 to 65,535) according to the environment settings.
9 GROUPID Source group ID Group ID of the source process. Number In Windows and Java, set to a fixed value (-1 to 65,535) according to the environment settings.
10 USERNAME Source user name User name of the source process. Character string --
11 GROUPNAME Source group name Group name of the source process. Character string Null string in Windows and Java
12 SOURCESERVER Source event server name Name of the source event server. Set to the event server name of the host on which a JP1 event occurred, even if the event is forwarded to another event server. Character string --
13 SOURCESEQNO Source specific serial number Serial number in the event database on the source host. Number Unchanged during an event transfer.
14 CODESET Code set Name of the character code-set in which the message, detailed information, and extended attributes are written. Character string --
15 MESSAGE Message Message text indicating the JP1 event contents. Character string --
16 SEVERITY Event level Urgency of the JP1 event. The following levels are used, starting from the most severe:
Emergency, Alert, Critical, Error, Warning, Notice, Information, Debug		 Character string Extended attribute value 1
17 USER_NAME User name Name of the user who executed the job. Character string Extended attribute value 2
18 PRODUCT_NAME Product name Name of the program that issued the JP1 event. The program names set in this attribute include:
/HITACHI/JP1/AJS
/HITACHI/JP1/AOM
/HITACHI/JP1/IM
/HITACHI/JP1/NBQ
/HITACHI/JP1/NQSEXEC 		Character string Extended attribute value 3
19 OBJECT_TYPE Object type Object type as one of the following:
JOB, JOBNET, ACTION, ACTIONFLOW, PRINTJOB, PRINTQUEUE, PRINTER, BATCHQUEUE, PIPEQUEUE 		Character string Extended attribute value 4
20 OBJECT_NAME Object name Object name (job, jobnet, and so on).
For a hierarchy of objects such as a jobnet, the lowest element is set.		 Character string Extended attribute value 5
21 ROOT_OBJECT_TYPE Root object type Object type.
Normally the same as OBJECT_TYPE, but when there is a hierarchy of objects as in a jobnet, the type of ROOT_OBJECT_NAME is used. The range of values is the same as for OBJECT_TYPE.		 Character string Extended attribute value 6
22 ROOT_OBJECT_NAME Root object name Name of the unit for execution instructions during user operation. Normally the same as OBJECT_NAME, but when there is a hierarchy of objects as in a jobnet, the name of the top-level object is set. Character string Extended attribute value 7
23 OBJECT_ID Object ID Object ID.
When paired with PRODUCT_NAME, the OBJECT_ID uniquely identifies an instance of the object within the JP1 system. (The format is product-dependent. This information is used when a user launches the monitor screen for a JP1 program from the Tool Launcher in JP1/IM - View.)		 Character string Extended attribute value 8
24 OCCURRENCE Occurrence The event that occurred in relation to the object shown in OBJECT_NAME. The values set in this attribute include:
END, LATEEND, LATESTART, NOTICE, PAUSE, START, SWITCH		 Character string Extended attribute value 9
25 START_TIME Start time Time at which execution started or restarted, as the number of seconds since UTC 1970-01-01 00:00:00. This item is not always set. Character string Extended attribute value 10
26 END_TIME End time Time at which execution or re-execution completed, as the cumulative seconds since UTC 1970-01-01 00:00:00. This item is not always set. Character string Extended attribute value 11
27 RESULT_CODE Result Code Completion code (numeric literal). This item is not always set. Character string Extended attribute value 12
28 Program-specific extended attribute name 1 Program-specific extended attribute Program-specific extended attribute name Character string --
29 Program-specific extended attribute value 1 Not output. Program-specific extended attribute value Character string --
:
:		 :
:		 :
:		 :
:		 :
:		 :
:
m-1 Program-specific extended attribute name n Not output. Program-specific extended attribute name Character string --
m Program-specific extended attribute value n Not output. Program-specific extended attribute value Character string --

Legend:
m: Number of items output to the CSV file
n: Number of program-specific extended attribute names and associated values

(2) Items output when the -k option is omitted in the jevexport command

If you omit the -k option when executing the jevexport command, the data from column 28 and on in the CSV file differs from the items that are output when the -k option is specified. The following table lists the items that are output from column 28 and on when the -k option is omitted. For details on the items that are output from columns 1 to 27, see Table 8-1 Items output when the -k option is specified in the jevexport command. The title name is output when the -a option is specified.

Table 8-2 Items output when the -k option is omitted in the jevexport command

Col. Attribute name Title name Contents Format Remarks
28 Program-specific extended attributes count Program-specific extended attributes count Number of program-specific extended attributes Number Number (0 to n)
29 Program-specific extended attribute name 1 Program-specific extended attribute Program-specific extended attribute name Character string --
30 Program-specific extended attribute value 1 Not output. Program-specific extended attribute value Character string --
:
:		 :
:		 :
:		 :
:		 :
:		 :
:
m-1 Program-specific extended attribute name n Not output. Program-specific extended attribute name Character string --
m Program-specific extended attribute value n Not output. Program-specific extended attribute value Character string --

Legend:
m: Number of items output to the CSV file
n: Number of program-specific extended attribute names and associated values

[Contents][Back][Next]

[Trademarks]

All Rights Reserved. Copyright (C) 2009, Hitachi, Ltd.