From the filename, I'm assuming you are on a unix system.
Originally Posted by vijay_b
(On MS-Windows, just install bash from cygwin.)
Place your "db2 load" invocation in a shell script as follows:
The variable "$$" is the process id of the executing script, which should be different on every invocation.
db2 load from staff.del of del modified by dumpfile = /home/db2inst1/dump$$.log
An alternative, safer way which also gives a nicer file name sequence, is:
Note that this will start reusing the file dump1.log if you manually delete it.
while test -f /home/db2inst1/dump$i.log
do i=`expr $i + 1`
db2 load from staff.del of del modified by dumpfile = /home/db2inst1/dump$i.log
__IBM Certified Database Administrator, DB2 9 for z/OS
__IBM Certified Application Developer
__ABIS Training and Consulting