Guru Of Geeks

Problem(Abstract) In IBM InfoSphere Information Server, enough memory must be allocated to run istool commands. Insufficient memory allocation in the computer that runs the istool command might cause the command to fail. Symptom In the following example, the istool query command fails and displays an OutOfMemoryError error in a JAVA heap message: istool workbench query -domain myserver -username myname -password mypasswrd -queryname "BI Report Models" Initializing query engine ..... JVMDUMP0061 Processing dump event "systhrow", detail "java/lang/OutOfMemoryError" - please wait. JVMDUMP0321 JVM requested Snap dump using '/data/IBM/InformationServer/Clients/istools/cli/Snap.2091125.10000 Cause By default, 64 MB of memory is allocated to run istool commands. This amount of memory is not sufficient to run metadata workbench commands. Resolving the problem On th...

So I'm doing a lot of posts in the DB2 Basics area this week. That's because they are quick for me to write, and they're questions I get all the time. So bear with me if you read for the more detailed Commerce topics – I'm not abandoning them. DB2 Client DB2 databases can be cataloged on DB2 servers or DB2 clients. Before trying cataloging, make sure you at least have the DB2 client installed. DB2 Clients are free (no licensing required). All App servers should have DB2 clients already installed on them. Web servers should not. You can download DB2 Clients here: https://www-304.ibm.com/support/docview.wss?uid=swg27007053 Select the same version and FixPack as the servers you're connecting to. Then select the proper OS. Finally, select "IBM Data Server Client" (9. versions) or "Administration Client" (8. versions). Installation and Instance creation are outside the scope of this post. Make sure you have all the inputs...

This procedure describes how to set up database connectivity for an Oracle content store. You must perform this procedure on each computer where you install Content Manager. Procedure On the computer where the Oracle client is installed, go to the ORACLE_HOME/jdbc/lib directory. Copy the correct library file for your version of the Oracle client to the c10_location \webapps\p2pd\WEB-INF\lib directory on the computer where Content Manager is installed and where notification is sent to an Oracle database. If you are using Oracle 10g, you must have ojdbc14.jar. If you are using Oracle 11g, you must have ojdbc5.jar. The files are available from an Oracle client or server install, and can also be downloaded from the Oracle technology Web site. ​

CMSYSPROPS This table has the Content Store Version. CMOBJNAMES This table has the names of all the objects in the content store. CMOBJPROPS1 Users, Roles \ Group Distribution list and contact information such as Email, phone number, Fax Given name etc are stored in this table. CMOBJPROPS2 Report scheduling information is stored. This table has fields like hour, day week etc CMOBJPROPS3 Stores Screen Tip and Object description provided while creating the objects are stored here CMOBJPROPS4 Stores the printer paper setting details like height and width of A3 , A4 , letter and 11X17 paper orientations CMOBJPROPS6 Has the details of the all packages which were published using the FM. CMOBJPROPS7 This table stores the XML of all reports and models. This is basically to maintain the metadata about the structure of the reports and models. CMOBJPROPS10 Contact information is stored in this table. This table has columns like Contact Email and C...

Problem(Abstract) On starting Cognos Services, the services do not start and give errors in cogserver.log. On looking at Content store observed that only seeing 5 CM* tables present. There should be more than this. Symptom Any of these messages may be present in the log files CM 1127 1 Audit.cms.CM Warning CM-CFG-5063 A Content Manager configuration error was detected while connecting to the content store. CM-CFG-5023 Content Manager is unable to initialize the content store by using the initialization file "D:\Program Files\cognos\c8\configuration\schemas\content\oracle\dbInitScript_oracle.sql&quo t;. ORA-00955: name is already used by an existing object 5. 09:41:12, 'com.cognos.pogo.services.DefaultHandlerService', 'pogo', 'Failure'. DPR-DPR-1035 Dispatcher detected an error. 8. 09:41:12, CM-CFG-5131 A Content Manager configuration error occurred during the initialization of Content Manage...

If you try to run the dsjob command you will get something like this: $ dsjob dsjob: error while loading shared libraries: libvmdsapi.so: cannot open shared object file: No such file or directory Presuming that you have selected the default path names during the installation of your server, the following will setup the environment: $ export DSHOME=/opt/IBM/InformationServer/Server/DSEngine $ export PATH=$PATH:$DSHOME/bin:/opt/IBM/InformationServer/Server/PXEngine/bin $ export APT_CONFIG_FILE=/opt/IBM/InformationServer/Server/Configurations/default.apt $ . /$DSHOME/dsenv You could even include the above into the  ~/.bashrc file so they are executed automatically

Login in to WAS admin console I n the Administrative console, select Servers > Server Types > WebSphere application servers . Select your server and view the Communication > Ports section for a list of ports being used by your server. For the SCA samples, use the WC_defaulthost port number. In the example port configuration shown in the screen below, this is port 9080.