Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2006
    Posts
    104

    Unanswered: 32Gb DB2 Backup fails on Windows 2000

    Hi,

    We use DB2 version 7.5 on windows 200 platform.

    the db backup failed occasionaly with following error

    Media controller -- device and file access denied: ffffb5aa

    On analysing we found the failure occurs when backup file size exceed 32 GB.

    IBM says the problem is due to NT cache setting and recommend setting db2 registry variable DB2NTNOCACHE=ON.

    We did that but found all our quries take 10 times more time with this setting.


    So the question is "How do we overcome the apparent 32 Gb limitation on Windows 2000 system'.

    Thanks in advance

  2. #2
    Join Date
    Sep 2003
    Posts
    237
    Looks like destination file cannot exceed 32gig; how about backingup to multiple destinations(look in the backup command; in V8 you can use this)Also in UNIX, you can use a PIPE and COMPRESS(there may be something equivalent)
    mota

Posting Permissions

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