z/OSのSYSPRINT出力およびUNIXシステムの標準出力(stdout)の特徴は以下のとおりです。
- 各出力行の最初の5桁は予約されています。その行がTeradata TPump文の先頭である場合、最初の5桁には文番号が入ります。これは、Teradata TPump文の前に置かれるコメントにも適用されます。
- 出力行がTeradata TPump生成のメッセージである場合、最初の5桁には「****」という文字列が入ります。
- 他の場合はすべて、最初の5桁はブランクになります。
- いずれのジョブの場合にも、処理の開始日付を示すメッセージが先頭に表示されます。
- Teradata TPump生成のメッセージには、システム時刻を示すヘッダーが前に付きます。そのタイムスタンプは、メッセージと同じ行に表示され、「****」の後に示されます。
例
次に示す例は、前記のリストで説明した各タイプのSYSPRINT/stdout出力行を表わしています。
========================================================================
= =
= Teradata Parallel Data Pump Utility Release 17.20.00.02 =
= Platform WIN 64-bit =
= PID 14184 =
= =
========================================================================
= =
= Copyright 1997-2022 Teradata. All rights reserved. =
= =
========================================================================
**** 14:06:06 UTY2411 Processing start date: FRI MAY 20, 2022
========================================================================
= =
= Logon/Connection =
= =
========================================================================
========================================================================
= =
= Teradata Parallel Data Pump Utility Release 17.20.00.02 =
= Platform WIN 64-bit =
= PID 14184 =
= =
========================================================================
= =
= Copyright 1997-2022 Teradata. All rights reserved. =
= =
========================================================================
**** 14:06:06 UTY2411 Processing start date: FRI MAY 20, 2022
========================================================================
= =
= Logon/Connection =
= =
========================================================================
0001 .LOGTABLE TPLOG0044;
0002 .LOGON NODEID/FLUSER,;
**** 14:06:06 UTY8400 Teradata Database Release: 17.20.00.00
**** 14:06:06 UTY8400 Teradata Database Version: 17.20.00.00
**** 14:06:06 UTY8400 Default character set: ASCII
**** 14:06:06 UTY8400 Current RDBMS has UDT support
**** 14:06:06 UTY8400 Current RDBMS has Large Decimal support
**** 14:06:06 UTY8400 Current RDBMS has Statement Info Parcel support
**** 14:06:06 UTY8400 Maximum supported buffer size: 1M
**** 14:06:06 UTY8400 Upsert supported by RDBMS server
**** 14:06:06 UTY8400 Data Encryption supported by RDBMS server
**** 14:06:06 UTY8400 Array Support supported by RDBMS server
**** 14:06:06 UTY8400 Statement Independence supported by RDBMS server
**** 14:06:07 UTY6211 A successful connect was made to the RDBMS.
**** 14:06:07 UTY6217 Logtable 'FLUSER.TPLOG0044' has been created.
========================================================================
= =
= Processing Control Statements =
= =
========================================================================
0003 .NAME TPUMP0044;
0004 DROP TABLE TPTBL0044;
**** 14:06:08 UTY1008 RDBMS failure: 3807, Object 'TPTBL0044' does not exist.
0005 DROP TABLE TPERR0044;
**** 14:06:09 UTY1008 RDBMS failure: 3807, Object 'TPERR0044' does not exist.
0006 CREATE TABLE TPTBL0044, FALLBACK(
F1 INTEGER, F2 CHAR(50),
F3 VARCHAR(50), F4 FLOAT,
F5 BYTE (10), F6 VARBYTE (10),
F7 DECIMAL(8,2),F8 BYTEINT,
F9 SMALLINT, F10 DATE)
UNIQUE PRIMARY INDEX (F1);
**** 14:06:10 UTY1016 'CREATE' request successful.
0007 .BEGIN LOAD CHECKPOINT 15
SESSIONS 4 1
TENACITY 2
ERRORTABLE TPERR0044
ROBUST OFF
NOMONITOR
PACK 500;
========================================================================
= =
= Processing TPump Statements =
= =
========================================================================
0008 .LAYOUT LAY0044;
0009 .FIELD FF1 * INTEGER KEY;
0010 .FIELD FF2 * CHAR(50);
0011 .FIELD FF3 * VARCHAR(50);
0012 .FIELD FF4 * FLOAT;
0013 .FIELD FF5 * BYTE(10);
0014 .FIELD FF6 * VARBYTE(10);
0015 .FIELD FF7 * DECIMAL(8,2);
0016 .FIELD FF8 * BYTEINT;
0017 .FIELD FF9 * SMALLINT;
0018 .FIELD FF10 * DATE;
0019 .DML LABEL LABEL0044;
0020 INSERT INTO TPTBL0044 VALUES ( :FF1, :FF2,
:FF3, :FF4,
:FF5, :FF6,
:FF7, :FF8,
:FF9, :FF10);
0021 .IMPORT INFILE DATA0044
LAYOUT LAY0044
APPLY LABEL0044;
0022 .END LOAD;
**** 14:06:11 UTY6609 Starting to log on sessions...
**** 14:06:15 UTY6610 Logged on 4 sessions.
========================================================================
= =
= TPump Import(s) Beginning =
= =
========================================================================
**** 14:06:16 UTY6630 Options in effect for following TPump Import(s):
. Tenacity : 2 hour limit to successfully connect load sessions.
. Max Sessions : 4 session(s).
. Min Sessions : 1 session(s).
. Checkpoint : 15 minute(s).
. Errlimit : No limit in effect.
. Restart Mode : SIMPLE.
. Serialization: OFF.
. Packing: 500 Statements per Request.
. StartUp Rate: UNLIMITED Statements per Minute.
**** 14:06:56 UTY6625 WARNING: Packing has changed to 253 statement(s) per
request.
**** 14:06:56 UTY6664 PACK factor was determined by the USING variable limit.
Apply: 1, Stmt: 1.
**** 14:06:56 UTY6608 Import 1 begins.
**** 14:06:57 UTY6641 Since last chkpt., 20 recs. in, 20 stmts., 1 reqs
**** 14:06:57 UTY6647 Since last chkpt., avg. DBS wait time: 797.00
**** 14:06:57 UTY6612 Beginning final checkpoint...
**** 14:06:57 UTY6641 Since last chkpt., 20 recs. in, 20 stmts., 1 reqs
**** 14:06:57 UTY6647 Since last chkpt., avg. DBS wait time: 797.00
**** 14:06:57 UTY6607 Checkpoint Completes with 20 rows sent.
**** 14:06:57 UTY6642 Import 1 statements: 20, requests: 1
**** 14:06:57 UTY6643 Import 1 average statements per request: 20.00
**** 14:06:57 UTY6644 Import 1 average statements per record: 1.00
**** 14:06:57 UTY6645 Import 1 statements/session: avg. 5.00, min. 0.00, max.
20.00
**** 14:06:57 UTY6646 Import 1 requests/session: average 0.25, minimum 0.00,
maximum 1.00
**** 14:06:57 UTY6648 Import 1 DBS wait time/session: avg. 199.25, min. 0.00,
max. 797.00
**** 14:06:57 UTY6649 Import 1 DBS wait time/request: avg. 199.25, min. 0.00,
max. 797.00
**** 14:06:57 UTY1823 Import processing statistics
. IMPORT 1 Total thus far
. ========= ==============
Candidate records considered:.... 20 20
Apply conditions satisfied:...... 20 20
Records logable to error table:.. 0 0
Candidate records rejected:...... 0 0
**** Statistics for Apply Label : LABEL0044
Type: I
Database: FLUSER
Table or Macro Name: TPTBL0044
Activity: 20
**** 14:06:58 UTY6677 Loading phase statistics
Elapsed time: 00:00:00:02(dd:hh:mm:ss)
CPU time: 0 Seconds
MB/sec: 0.000946
MB/cpusec: N/A
**** 14:07:00 UTY0821 Error table FLUSER.TPERR0044 is EMPTY, dropping table.
0023 .LOGOFF;
========================================================================
= =
= Logoff/Disconnect =
= =
========================================================================
**** 14:07:02 UTY6216 The restart log table has been dropped.
**** 14:07:02 UTY6212 A successful disconnect was made from the RDBMS.
**** 14:07:02 UTY2410 Total processor time used = '3.03125 Seconds'
. Start : 14:06:04 - FRI MAY 20, 2022
. End : 14:07:02 - FRI MAY 20, 2022
. Highest return code encountered = '0'.