Hi everyone,

Just recently we encountered problem in loading historical data to our db2 server.

Error Msg : "[DB2/NT64] SQL0968C The file system is full. SQLSTATE=57011

but the drive has a 234 gig of free space and I dont know why will the file system be full. We are using SSIS package to load the data to the DB2 server I dont know if there is any conflict with this process. Besides this is the first time we encountered the problem since we started loading the historical data a few months ago.

I'm attaching also the script that we use.

Im using WINDOWS 2003 Enterprise Edition for the OS
DB2 WORKGROUP SERVER EDITION v 9.5 with the latest fixpack (FP 3a)


thanks

Jane

Look at the file system where your DB2 transaction log is located.

hi everyone,

im back again, seeking help about this script. Thi s is the script when i load the historical data to our db2 server using SSIS package which causes the TDA file to increase thus occupying the whole file server.

thanks.

Jane R.