OnDemand Users Group

I'm working on a migration for a customer, and they have an interesting problem.

Print data was being sent to CMOD for archiving forms that were filled out by employees, from customers.  Depending on the data, there may have been dozens of sections.  Each of those sections had their own AFP resources, so the resulting individual printed document may have had a mix of a 20 or 30 individual resources (pageseg, overlay, etc.) -- creating thousands of combinations.

Now, CMOD can handle this easily, but older versions of CMOD only compared the last 50 resources that were loaded -- meaning that their print steams contained one of hundreds of those possible combinations.  And if the specific group of resources used didn't appear in the last 50 resource bundles, it stored a new one.

So now I have an Application Group with 750,000 individual resource files.

I figure I can't be working on the only system in the world to have this issue.

So, I'd appreciate it if folks would run this database query, and post the results:

db2 "select agid,resources from (select agid,count(*) as resources from arsres group by agid) where resources>50"

AGID        RESOURCES 
----------- -----------
       5134         819
       5142         808
       5144         917
       5148      303336
       5188          52
       5825         279
       5857      108256
       5859         673
       5863         403
       6011        8313
       6013        1830
       6623        5668
       6637        1260
       6697       38906

  14 record(s) selected.



I'm stuck with this problem temporarily (I have 2.1 million files to load) but I've changed the 'Resource Comparisons' value to 9999, and so far, I've reduced the number of individual resource bundles down to under 10,000.

I have a good idea as to how to fix this, but wanted to see if the problem is actually widespread before working on a solution.

-JD.

Hi Justin.


$ db2 "select agid,resources from (select agid,count(*) as resources from root.arsres group by agid) where resources>50"

AGID        RESOURCES
----------- -----------
        685         266
        740        2649
        949         208
       1208         606
       1446         299
       2648         328
       2658        2382
       3198        1404
       3215          55
       3224          70
       3235          64
       3317         315
       3319         470
       3652        1361
       3812       12727
       3821         375
       4464          83
       5267        2449
       5558         159
       5611          74
       5806         542
       6113        5026
       6117         215
       6118        1463
       6119         249
       6120         256
       6180         384
       6182          57
       6360        2614

  29 record(s) selected.


Kind regards,

Michel.

Thanks Michael!

-JD.