How to avoid increase the NC counts in cognos 10.2.2

[nagoole]

Hi All,

In our env currently that NC count every day increasing like anything and we forced to this cleanup on every week.

Previously We use to clean up the NC tables two/three months once as it's slowly increasing As per IBM suggestion if  its crossed above 10k counts to avoid that schedules reports/job going to pending status.

Recently we added 5 applications in our env and we understood that because of this only the count is increasing anything everyday. But we are seeing every day the count increasing more than 5k per day, due to this most of the schedules went to pending status and getting delayed to complete the schedules request.

It is there any other way to find out why the NC count is increasing and how to find out which schedules reports/job are causing this issue in cognos 10.2.2 env ?

Thanks,
Naga

[bensah]

Hi,

please check the number schedule activity in your environment. Because for each schedule activity it will insert the data in the NC tables.
In Cognos 10.2, you don't need to stop the service to cleanup the data from the NC tables.

you can refer the below link for details.
http://www-01.ibm.com/support/docview.wss?uid=swg21637944

Thanks,
Benu

[nagoole]

Hi Beanu,

Thanks for quick response, Yes we are doing same steps to cleanup the NC counts manually after taking back up for safer side.
Do we have any automate way to clear this counts from NC table once its crossed 10k records in below tables in cognos 10.2.2 env ?

NC_TASK_ANCESTOR_STOREIDS
NC_TASK_HISTORY_DETAIL
NC_TASK_QUEUE
NC_TSE_STATE_MAP
NC_TASK_PROPERTY

Curenntly NC counts crossed 75k in our env. plan to clean up this week end  :) :) :)

Thanks,
Naga

[bensah]

Hi Naga,

I don't have any automatic script. But what every queries that you are running to cleanup the NC table records, you can put it in one script and schedule that script for your system. You can take help of your DBA team. I will check and if I will find any script then I will share.

Is your app server on windows or Unix ? Is your content store on Oracle or SQL server?

Thanks,
Benu

[nagoole]

App server - Windows

Content Store DB - Oracle