Cognos Maintenance

[Cinu8]

hi guys

please help me on Cognos server and portal maintenance i mean
what are the steps taken periodically to improve the performance also the regular
maintenance process
Daily
Weekly
Monthly
Quarterly
Half yearly
Yearly

thank you in advance cinu8

[Cinu8]

hi all

please provide me the information

i hope you guys do the maintenance regularly

waiting for your reply

cinu8

[sir_jeroen]

What have you tried? Vague questions result in vague answers...

[shaashish1]

no maintainance required... its maintainance Free

[joe123]

AFAIK, the only build-in maintenance task is the consistency check against the directory service to find dead users.
Apart  from  that i run some scripts for environment housekeeping, eg. archive old logs, delete java/bibus dumps, etc.
It also figured out that cognos works best if restarted daily.
From time to time i check audit db and cogserver.log for application errors. (best viewed with bin/logviewV2.exe)

I'm shure that there are some little things more i don't remember jet.

[shaashish1]

to Add on...

Check for
1. Jobs/ Server Loads/ reports in Queue
2. Monitor Cognos Services are running, Dispatcher and failover content manager
3. Cube Refresh
4. Troubleshoot Errors for Reports and Portal
5. User Access and Authentication/ De-Authentication
6. Check RDW & SBW are in sync
7. Update missing files, Manual Processing and matching data.
8. Try to automate all manual efforts and reduce Run Time for Reports.
9. Take backup and troubleshooting and debugging issues as they come in.
10. Cognos development may also be required.
11. The installation, configuration and day-to-day tasks associated with ensuring the smooth and efficient operation of Cognos environment.


Please add on if you know more Admin Activities?

[Cinu8]

thank you joe123 thats what i do too.

and shaashish1 your stuff looks great i do some of them and can you please elabrate below 4 tasks .

5.  User Access and Authentication/ De-Authentication ?
6. Check RDW & SBW are in sync ?
7. Update missing files, Manual Processing and matching data. ?
9. Take backup and troubleshooting and debugging issues as they come in.?


and is there a way to run the report from Content Store for all the users and there access.
right now i am requesting a excel report from AD group and loading in to data base and creating cognos reports out of it

thank you in advance

[venkys4u_]

AFAIK, the only build-in maintenance task is the consistency check against the directory service to find dead users.
Apart  from  that i run some scripts for environment housekeeping, eg. archive old logs, delete java/bibus dumps, etc.
It also figured out that cognos works best if restarted daily.
From time to time i check audit db and cogserver.log for application errors. (best viewed with bin/logviewV2.exe)

I'm shure that there are some little things more i don't remember jet.

could you please explain more about
"environment housekeeping, eg. archive old logs, delete java/bibus dumps, etc."

I mean deleting java,bibus dumps!


Thanks in advance
venky

[jeffowentn]

joe123,

I would also be interested in the archive logs and delete java/bibus files, etc.  Can you elaborate or share any scripts, etc.?

Thank you,
Jeff

[venkys4u_]

joe123,

I would also be interested in the archive logs and delete java/bibus files, etc.  Can you elaborate or share any scripts, etc.?

Thank you,
Jeff

Jeff,
If u have configured audit package, u can take the audit database backup for archiving logs.. In case if u dont have audit database, I guess u have to work towards
c8/installation (transfer.logs,transfer summary error.log,
c8/configuration (coglocale,startup,cogstartup.bak),
c8/logs (cogserver.log,gateway.log,unistall.log)

does any cog admin archive these files?? please correct if im incorrect..

gud luck
venky