OnDemand User Group

Support Forums => MP Server => Topic started by: rellerbrock on March 14, 2019, 10:44:08 AM

Title: Listing of Load IDs with Index Values
Post by: rellerbrock on March 14, 2019, 10:44:08 AM

Is there a way to get a listing of index values with load ids for a given day and application group?   We had an issue where duplicate files were generated and then sent to OnDemand.   I am trying to get a list so we can identify load ids of duplicate index values.  I can then script an unload of those documents.   Thanks.

Title: Re: Listing of Load IDs with Index Values
Post by: jsquizz on March 14, 2019, 11:05:42 AM

Here is what I would do. Of course, I would fine tune this depending on your needs. Make sure you test all of this.

1) Get the exact table name for the specific app group-

db2 => select arsag.name, arsseg.table_name from arsag, arsseg where arsag.agid=arsseg.agid and arsag.name='AGNAME'

NAME                                                         TABLE_NAME
------------------------------------------------------------ ------------------
AGNAME                                                      TBL1


2) get a listing of the date, plan, doc_name from the table, and use where clause with the date you choose (in the arsdate format..)

db2 => select rdate, plan , doc_name from TBL1 where rdate = '17840'

3) export to excel, apply some filters to remove duplicates. Then toss them in an arsadmin unload

Title: Re: Listing of Load IDs with Index Values
Post by: Stephen McNulty on March 15, 2019, 04:38:34 AM

If you are looking for duplicate 'load' files, an option could be to use the system load folder.  It provides the load id, Input file name, and input size.

Title: Re: Listing of Load IDs with Index Values
Post by: rjrussel on March 15, 2019, 07:01:00 AM

While I don't have time at the moment to write up entire instructions here is, at a high level, what I would do.

1. Find the load ID of the load you're interested in looking at the index data for.

2. Use arsadmin retrieve to pull the index object (ex: 123FAA1)

3. Use arsadmin decompress to uncompress the object.

--> All meta data that was loaded to the database will be contained in the uncompressed data.

By following this method you can simply use supported, native OnDemand commands to perform the task before you.

Thanks,
RR

Title: Re: Listing of Load IDs with Index Values
Post by: rellerbrock on April 02, 2019, 05:30:16 AM

Thanks to everyone for their input this worked to get the duplicates removed.