Show Posts
1
MP Server / Delete AG with no data, when OD thinks it has data
« on: October 13, 2010, 02:23:55 AM »
Hi,
I found out an interesting problem when tried to delete one of old Application Groups, which was migrated to our system from another several years ago.
Problem is following.
1. When trying to delete AG from admin client, in deletion confirmation msgbox it shows that AG still has documents in it.
2. When comparing lists of loaded files load_id's to unloaded, it shows that all loaded files were unloaded.
3. Looking at AG table (the one named by AGID_NAME) I see that table exists and it is empty.
4. ARSSEG table shows that for table above number of inserted rows is greater than number of deleted rows. Difference matches number in point 1.
My question is if anybody already encountered same problem and if there are recommendations on how to get it solved.
I'm thinking of trying to update DEL_ROWS value in ARSSEG so it matches INS_ROWS value, then delete AG table, then try to delete AG from admin client again.
But before trying it I'd like to check if somebody already got and solved same issue.
OD version 8.4.1.2, DB2 v9.5.400.xxx
Thanks in advance!
I found out an interesting problem when tried to delete one of old Application Groups, which was migrated to our system from another several years ago.
Problem is following.
1. When trying to delete AG from admin client, in deletion confirmation msgbox it shows that AG still has documents in it.
2. When comparing lists of loaded files load_id's to unloaded, it shows that all loaded files were unloaded.
3. Looking at AG table (the one named by AGID_NAME) I see that table exists and it is empty.
4. ARSSEG table shows that for table above number of inserted rows is greater than number of deleted rows. Difference matches number in point 1.
My question is if anybody already encountered same problem and if there are recommendations on how to get it solved.
I'm thinking of trying to update DEL_ROWS value in ARSSEG so it matches INS_ROWS value, then delete AG table, then try to delete AG from admin client again.
But before trying it I'd like to check if somebody already got and solved same issue.
OD version 8.4.1.2, DB2 v9.5.400.xxx
Thanks in advance!