Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2008

    Unanswered: problem loading historical data to DB2 server

    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)


    Attached Files Attached Files

  2. #2
    Join Date
    May 2003
    Look at the file system where your DB2 transaction log is located.
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

  3. #3
    Join Date
    Oct 2008
    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.


    Jane R.
    Attached Files Attached Files

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts