If you are unable to create a new account, please email support@bspsoftware.com

 

Cognos BIB processes and taking over the Temp Space (URGENT) PS HELP

Started by gosoccer, 17 Feb 2017 06:26:18 PM

Previous topic - Next topic

gosoccer

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.




AnalyticsWithJay

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?

gosoccer

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?

AnalyticsWithJay

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.

gosoccer

Thanks I'll look for the uda files and past activities.
:)