Question & Answer
Question
What does it mean each characters trailing "Starting LOAD operation" at db2diag.log?
Answer
When run a LOAD, may find below messages on db2diag.log.
----------
2015-11-06-00.28.27.312929+540 I131266A630 LEVEL: Warning
PID : 16711886 TID : 34687 PROC : db2sysc 0
INSTANCE: xxxxxxx NODE : 000 DB : xxxxx
APPHDL : 0-24767 APPID: xxxxxxxxxxxxxxxxxxxxxxxxxxx
AUTHID : xxxxx HOSTNAME: xxxxxxxx
EDUID : 34687 EDUNAME: db2agent (xxxxxx) 0
FUNCTION: DB2 UDB, database utilities, sqluvtld_route_in, probe:924
DATA #1 : LOADID, PD_TYPE_LOADID, 50 bytes
LOADID: 34687.2015-11-06-00.28.27.312918.0 (-1;-1)
DATA #2 : String, 63 bytes
Starting LOAD operation (R) (7) (R) [xxxxxxxx.xxxxxxxxxxxxxxx].
----------
----------
2015-11-06-00.28.24.592643+540 I97951A634 LEVEL: Warning
PID : 10092602 TID : 101668 PROC : db2sysc 0
INSTANCE: xxxxxxx NODE : 000 DB : xxxxx
APPHDL : 0-21696 APPID: xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
AUTHID : xxxxx HOSTNAME: xxxxxxxx
EDUID : 101668 EDUNAME: db2agent (xxxxx) 0
FUNCTION: DB2 UDB, database utilities, sqluvtld_route_in, probe:924
DATA #1 : LOADID, PD_TYPE_LOADID, 51 bytes
LOADID: 101668.2015-11-06-00.28.24.592627.0 (-1;-1)
DATA #2 : String, 63 bytes
Starting LOAD operation (S) (1) (R) [xxxxxxxx.xxxxxxxxxxxxxxx].
----------
There are three letters after "Starting LOAD operation" as (R) (7) (R) and (R) (7) (R).
These three letters represent "Media Type", "Data File Type" and "Operation Type". Here is the list for each types.
"Media Type":
----------
'L' /* path/device */
'S' /* remote file/device/named pipe */
'C' /* local file/device/named pipe */
'Q' /* SQL Statement */
'A' /* Tivoli Storage Manager */
'X' /* X/Open XBSA interface */
'O' /* vendor library */
'F' /* Snapshot capable storage device */
'f' /* Scripted snapshot ACS interface */
'R' /* remote fetch data */
'U' /* user exit */
'D' /* Generated only by vendors */
'K' /* Generated only by vendors */
'N' /* Generated internally by DB2 */
'T' /* Generated only by vendors */
'P' /* Generated only by vendors */
----------
"Data File Type":
----------
'1' /* filetype for delimited ASCII (DEL) files */
'2' /* filetype for Symphony 1.0, 1.1 or filetype for Lotus 123, 2.0 */
'3' /* filetype for IXF files */
'4' /* filetype for Non-Delimited ASCII (ASC) files */
'5' /* For the crossloader.. */
'6' /* For CLI.. */
'7' /* For REMOTE FETCH */
'8' /* For Crossloader Format. */
----------
"Operation Type":
----------
'I' /* INSERT */
' ' /* RESTART (blank) */
'T' /* TERMINATE */
'R' /* REPLACE */
'K' /* REPLACE_KEEPDICTIONARY */
'S' /* REPLACE_RESETDICTIONARY */
'O' /* REPLACE_RESETDICTIONARYONLY */
----------
Note:
Db2diag.log being intended for internal use and these values may be changed to have different meaning. As well, some of these values may already be obsolete and not used anymore.
The above values and format of "Starting LOAD operation" line are DB2 UDB V10.5 FP6 based IBM internal information. It may be changed without notice in the future.
If its changed, then users will have to adjust their procedures or will not refer to this technote.
Related Information
Was this topic helpful?
Document Information
Modified date:
16 June 2018
UID
swg21971862