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. ...
