Db2 load query

su - db2inst1
db2 connect to db1
db2 load query table XXXX.YYYY

LOAD QUERYコマンドの最後の方で以下のような内容が表示され、何件進んでいるのかがわかる

SQL3501W The table space(s) in which the table resides will not be placed in backup pending state since forward recovery is disabled for the database. SQL3109N The utility is beginning to load data from file "/u/mydir/data/staffbig.del" SQL3500W The utility is beginning the "LOAD" phase at time "03-21-2002 11:31:16.597045". SQL3519W Begin Load Consistency Point. Input record count = "0". SQL3520W Load Consistency Point was successful. SQL3519W Begin Load Consistency Point. Input record count = "104416". SQL3520W Load Consistency Point was successful. SQL3519W Begin Load Consistency Point. Input record count = "205757". SQL3520W Load Consistency Point was successful. SQL3519W Begin Load Consistency Point. Input record count = "307098". SQL3520W Load Consistency Point was successful. SQL3519W Begin Load Consistency Point. Input record count = "408439". SQL3520W Load Consistency Point was successful. SQL3532I The Load utility is currently in the "LOAD" phase. Number of rows read = 453376 Number of rows skipped = 0 Number of rows loaded = 453376 Number of rows rejected = 0 Number of rows deleted = 0 Number of rows committed = 408439 Number of warnings = 0 Tablestate: Load in Progress

https://www.ibm.com/docs/en/db2/11.5?topic=commands-load-query

この結果はNODE単位で出力される。
そうなると、NODE6−55の合計がLOADの状況になる
以下は6にする場合

db2 terminate
export DB2NODE=6
db2 connect to db1

以下のコマンドでも状況が掴める
db2 list utilities show detail