OnDemand User Group

Support Forums => MP Server => Topic started by: CHYTU453 on March 14, 2018, 11:26:27 PM

Title: adding and deleting the documents while doing migration
Post by: CHYTU453 on March 14, 2018, 11:26:27 PM

Hi,
          Here I will try to explain the scenario that which I came across We are in a migration from cmod v7.1.2.8 to v8.5 so we have successfully migrated  lets say one application group from source to target for time being .Now our question is :

"If there is  any document that was deleted from the "source"(after migration) then how can we know that the document is deleted from which application group or if one document is added(after migration) in the source how can we know that one document is added in the source to which application group  or let me give another scenario where if a user is added in the source how can we reflect him in the target server(after migration)" we can able to know how many docs are deleted from application group by the following query :

db2 "select arsag.name,arsseg.table_name,arsseg.ins_rows,arsseg.del_rows from arsag,arsseg where arsag.agid=arsseg.agid order by arsseg.table_name"

But we are unable to fetch the filenames exactly what are deleted so that we can delete or add in the target too.

Title: Re: adding and deleting the documents while doing migration
Post by: Norbert Novotny on March 15, 2018, 11:42:56 AM

Hi,
not sure if I fully understand what you are trying to achieve, however as far as the deleted documents (post or during migration) IMHO you have two options:

• given you are using proper CMOD technique to delete or unload you can find relevant info by querying the System Log (or respective SLn table)
• The long route would be to do reconcile row counts of each of the migrated segment tables

The new arrivals; a great help would be to have all segments closed just before migration, so the "long running" migration can progress with static data not be "polluted" with new ingestion(s). Then after the "long migration" you can just re-run process on delta found in currently open segment.

Other route would be to subtract load_ids; from arsag.load_id on source system subtract the arsag.load_id on target system ; the difference gives you number of new ingestions to your source system since migration begun.
Sure, you can also get the information from System Log and/or System Load (if present).

Hope this helps or at least give you some pointers.
Cheers,
 N.

Title: Re: adding and deleting the documents while doing migration
Post by: CHYTU453 on March 15, 2018, 09:20:53 PM

Hi Norbert Novotny,
                             Thanks for the quick reply.
                               

Title: Re: adding and deleting the documents while doing migration
Post by: Justin Derrick on March 23, 2018, 07:28:14 AM

Quote

db2 "select arsag.name,arsseg.table_name,arsseg.ins_rows,arsseg.del_rows from arsag,arsseg where arsag.agid=arsseg.agid order by arsseg.table_name"

I'm flattered that you quoted the IBM CMOD Wiki page on Useful SQL queries!  https://cmod.wiki/index.php?title=Useful_SQL_Queries_for_Content_Manager_OnDemand & https://cmod.wiki/index.php?title=Useful_SQL_Queries_for_Content_Manager_OnDemand#How_many_documents_are_in_CMOD_Application_Groups.3F  :D

If you were on IBM CMOD v8.5 or higher, you might have the System Load Application Group, which is where you would find that information easily in a way you could access with SQL.

Unfortunately, you'll have to search the System Log and parse out the data you're looking for.

-JD.

Title: Re: adding and deleting the documents while doing migration
Post by: CHYTU453 on March 28, 2018, 03:14:04 AM

Hi Justin Derrick,

                        Thank you derrick for the useful information and replying for the post. :)