What would cause there to be a limit of 1 GiG on the backup file size of the db2 backup command. I issued the command 'db2 backup db records to /workspace'. I expected this command to create 1 backup file, however when the file reached 1G I got he message 'SQL2059W A device full warning was encountered on device "/workspace" '. Do you want to continue(c), terminate this device only(d), abort the utility(t) ? (c/d/t)' I answered 'c' and another 1G file was created, then the same message appeared. The same thing happened after I answered 'c' again.
Its not a db2 config value. Its a Server side file system setting. So you should change ulimit value (and/or) /etc/security/limits file parameter. You should have root to do this. (i hope you are working on AIX).