Hi folks, we have an urgent situation if someone can help.
We have several Cognos BIB process running and taking over Temp Space related to our DB2 DB. Please see below:
db2 list applications show detail | grep -i XXXRPT
XXXRPT BIBusTKServerMa 43097 IPADDRESS.43594.170217XXXXXXX 00009 1 0 2013 UOW Waiting Not Collected XXXXDB1P /udb-db2inst/db2inst1/NODE0000/SQL00001/MEMBER0000/
XXXRPT BIBusTKServerMa 43011 IPADDRESS.46609.17021XXXXXX 00010 1 0 1057 UOW Waiting Not Collected XXXXDB1P /udb-db2inst/db2inst1/NODE0000/SQL00001/MEMBER0000/
XXXRPT BIBusTKServerMa 42883 IPADDRESS.38540.XXXX17215911 00012 1 0 1981 UOW Executing Not Collected XXXXCDB1P /udb-db2inst/db2inst1/NODE0000/SQL00001/MEMBER0000/
$
$ df -k | grep data
/dev/mapper/volgroup02-udbdata1vol
964904048 849737748 66157084 93% /udb-data1
/dev/mapper/volgroup02-udbdata2vol
964904048 849738016 66156816 93% /udb-data2
/dev/mapper/volgroup02-udbdata3vol
964904048 849737396 66157436 93% /udb-data3
/dev/mapper/volgroup02-udbdata4vol
964904048 849737816 66157016 93% /udb-data4
Do you guys know why these BIB Processes are taking up so much space even though there are no users in the system?
Thanks for your time.
I see this is from a few days ago. Are you still having this issue?
When did this start occurring, and what has changed in your environment? Do you see any current activities in Cognos administration?
The environment has been running very slow but it got really bad last week. What current activities in the Cognos Admin would help us. What am I looking for?
The most common use of the temp directory for Cognos is for reporting, which is likely the cause of your issue.
Do you see large 'uda' files being created in the Cognos temp directory?
I would look at Past Activities under Cognos Administration -> Status, to see if you can isolate a report that ran at the time this issue started happening.
Very large temp files are typically a result of bad report/model design.
Thanks I'll look for the uda files and past activities.
:)