Load using dumpfile and appending with the date and time

[MallaKishore]

Hi Ganesh

U can append the dumpfile with the time so that when ever load runs it will create a new file instaed of
overwriting

for example

db2 load from data of del modified by dumpfile = /u/user/filename.`date +m%d%Y%H%M%` insert into table_name

it should write the exceptions in new file appending month , date, year, hours and minutes

as example 091020071108

Please try this and let me know if and issues

Thanks & Regards
KishoreMalla,
DB2 DBA,
ODW Team,
Prestige Towers,
99,Residency Road,
Banglore-56025,
INDIA
Tel-0-9916084285