Posts Tagged Unix

Ulimit and Cognos Performance Tuning on Unix

If you are experiencing slowdowns and delays on Cognos reports on your Unix-based system, the first good place to look is at your ulimit parameters.  To see your ulimit values, enter “ulimit -a” on your Unix system.

time(seconds) unlimited
file(blocks) unlimited
data(kbytes) unlimited
stack(kbytes) 8192
coredump(blocks) unlimited
nofiles(descriptors) 256
memory(kbytes) unlimited

Pay particular attention to your maximum file descriptor, listed above as nofiles(descriptors).  The default value of this item can be quite low, as you can see in this example.  Setting it higher can make significant improvement on your Cognos system.  You can set this value with the Unix command ulimit -n xxxxx (where xxxxx is your desired maximum file descriptor value).

You will find that these ulimit settings are a function of your Unix session, and will revert to default values after you log out.  If you want to make permanent changes to your Cognos ulimit settings you will need to either:

  1. Create a script that calls ulimit -n xxxxx command before it calls the cogconfig.sh file for Cognos startup; or
  2. Add the ulimit -n xxxxx command to your .profile for the Unix account account in question (open with vi .profile)

For more information on ulimit settings for Cognos, see this IBM article here (this IBM article is specific to AIX and Linux systems).

, ,

No Comments

Cognos Transformer Problems in Unix

Transitioning a cube from a Windows environment to a Unix environment can be tricky.  Your cube may build perfectly in a local-build on Windows, only to give you errors like this in a server-build on Unix:

Start processing data source ‘My Data Source’.
Reading source data.
(TR3703) The user ID or password is either missing or invalid. Please re-enter the credentials.
End processing 0 records from data source ‘My Data Source’.

While it appears as though you have a problem with a data source in Unix, the real problem lies with your signon credentials.  Once you transition from a local-build to a server-build in Transformer, you need to have a valid Signon defined.  But when you do this, there is no way to test to see if your Signon Credentials will work – short of moving your Transformer model to the Unix server and building it.  If your signon credentials are invalid, you will get a message like the one above.

So check the Signon Credentials and that should solve your problem.  The apparent reference to your data source is a red herring.

, ,

No Comments