DB2 console/operation log?

[PeterG5]

Hello All,

Hopefully, this may be simple one for you DB2 experts out there - it's all new to me.

I run this command:

"C:\Program Files\IBM\SQLLIB\BIN\DB2CMD.exe" /c DB2SETCP.BAT DB2.EXE -tvf export.sql

It works fine and produces this screen output:

connect to e6dwprod user e6dw_data using

Database Connection Information

Database server = DB2/NT 8.1.3
SQL authorization ID = E6DW_DAT...
Local database alias = E6DWPROD


EXPORT TO C:\IBI\PGFTEMP\EXP_STAT.TXT OF DEL SELECT CAST(SO_STATUS_NEXT_ID AS CHAR(12)) || CAST(SO_STATUS_NEXT_DESC AS C
HAR(60)) FROM SOT_LU_STATUS_NEXT WHERE SO_STATUS_NEXT_ID <= '999' WITH UR
SQL3104N The Export utility is beginning to export data to file
&quot;C:\IBI\PGFTEMP\EXP_STAT.TXT&quot;.

SQL3105N The Export utility has finished exporting &quot;32&quot; rows.


Number of rows exported: 32


connect reset
DB20000I The SQL command completed successfully.

C:\Program Files\IBM\SQLLIB\BIN>

The &quot;DOS box&quot; then shuts down (/c papameter); Great!

My question is: How do I capture the screen output for later
viewing? This procedure runs un-attended overnight and I need a console log of some sort in order to verify that everything ran OK while I was still asleep. I'm not talking about a recovery log, just a simple file showing the results of the logon, SQL, etc. statements.

Any suggestions?

Many Thanks, Peter.

 

[gregsimpson]

Peter,

perhaps you could take advantage of the messages file. See the link below

http://www.cs.yorku.ca/~seela/db2/import.html

Cheers
Greg

 

[PeterG5]

Greg,

That works fine; many Thanks, Peter