Hi members: Recently on the production database we tried to take an full online backup and got an error SQL0902 error Reason Code = 2.
Has anyone experienced this before. Some history on what we have found so far: The DB2 Diaglog output explains it all but the reason it leads to is do with a table which is on a SMS tablespace. This table is almost 1.99999 gig and cannot become larger due to the filesystem restriction (the filesystem does not enabled for "LARGE FILE Support") - AIX 4.3.3. So, we keep getting disk full error even when the JFS filesystem has 16 gig space left. Its because of this ceiling on the file size that can be created on the JFS (2 Gig)... Therefore, we decided to take an online backup, drop and recreate the filesystems with large file support enabled and do a redirected restore. Now, We can't take this online backup and get a SQL0902 error rc=2 due to this 1.999 gig sized table which keeps terminating the backup. The ZRC=xFFFFF60A and points to the USERSPACE1 and a table with tableID=14. Any kind of help is appreciated. Thank You in Advance. - Vijay - ::: When replying to the list, please use 'Reply-All' and make sure ::: a copy goes to the list ([EMAIL PROTECTED]). *** To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED] *** For more information, check http://www.db2eug.uni.cc
