hi

using load utility i am generating a dump file for every load operation to a particular path.

every time i execute the command specifying the same path for the dump file now its replacing the previous entries.

What i need is altough i give the same location for the dumpfile path should be autogenerated indicating that for this execution of load command a unique dumpfile should be generated.

BRIEFLY :
although i excute this query many times
db2 load from staff.del of del modified by dumpfile = /home/db2inst1/ "replace into task"

the dumpfiles should be many not one.

thanks for the guy who will solve it.

From the filename, I'm assuming you are on a unix system.
(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.

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.