CU Users Group

jgraves · Joined: 19 Jun 2008 Posts: 21 Location: ROCHESTER, MN

Our day takes 10 hours to run and finish. We have about 1.2 million open accounts. We resize our files on a monthly basis and it seems to help shed one hour the next night it runs but by day 2, it is back to 10 hours again. We are now debating if we should and can resize files daily and if this is really our issue. Any thoughts from anyone and can you please give me ideas on how long other agencies day end takes and the number of accounts it handles?
Thank you!!

GHAWKINS · Posted: Tue Feb 02, 2010 2:58 pm Post subject:

I hear your pain....our dayend was taking forever. Are you running anything during the CFDAYEND-USER-BEGIN or CFDAYEND-USER? How about CAW? I know that our CAW process takes about 3-4 hours on one of our logons.

If the answer is "yes" to any of those items, let me know and I'll tell you how you can shave a bunch of time off the process.

Also - how large are your desks? We use "super desks", and if those CF files aren't resized to accommodate the size, it can hold things up, too.

jgraves · Joined: 19 Jun 2008 Posts: 21 Location: ROCHESTER, MN

Yes, our CAW is taking about 3 hours, for one log on. Do you have any suggestions for improving this?

I have never heard of "super desks"..thank you for the suggestion, I will look into that. We have about 300,000 accounts within a one desk and there are multiple desks.

Thank you for the feedback.

GHAWKINS · Posted: Tue Feb 02, 2010 9:37 pm Post subject:

We removed the CAW export out of the regular day end program and put it in our CFDAYEND-USER-BEGIN; we then start it as a PHANTOM process so it runs while the rest of day end keeps on going:

HPHANTOM TO-PORTAL-AUTO
P

Here's what the line looks like.

Have CUBS help you comment out the regular day end CAW export routine to be on the safe sife since it's a core program you'll be changing.

Here's what it looks like in our CFDAYEND now - the C comments out the regular TO-PORTAL-AUTO - just make sure you have placed it in your CFDAYEND-USER-BEGIN so your CAW exports runs. You'll have to update each logon if you have multiples to run it in the CFDAYEND-USER-BEGIN since it's in PRIVLIB.

303 CHTO-PORTAL-AUTO
304 CP

Let me know if you have questions.

jgraves · Joined: 19 Jun 2008 Posts: 21 Location: ROCHESTER, MN

Thank you for that information!!!

One more question, what do you mean by a "super desk"?

GHAWKINS · Posted: Thu Feb 04, 2010 5:36 pm Post subject:

We refer to a "super desk" as one used by a group of collectors on one particular contract. Because a desk like that is out of the "normal" for a standard desk size, we refer to it as a "super" or "mega" desk, and it has a lot of strategies attached to it.

rufinij · Posted: Tue Apr 20, 2010 6:49 pm Post subject:

I would first ask what versions of the database, operating system and TCS you are on - second, I would ask what your hardware setup is.

My experience has usually pointed to file system & I/O issues as the root cause of such pain - unless you are trying to do something truly heroic every night (perhaps updating 5 million records or something of that nature).

Post your specs and perhaps I can assist.
_________________
John Rufini
Director - Technology
First Data - Merchant Services
Houston, Texas