Guru Of Geeks

Problem(Abstract) The following errors occur when the DataStage stored procedure stage contains columns of type NVarChar: Message: SP_SADRUPD,0: Error: Datatype not presently supported Message: SP_SADRUPD,0: Error occurred in call to ORPHCallActivePluginInitialize(). Resolving the problem When a DataStage Stored Procedure stage contains columns defined as data type NVarChar, the job fails with the following warning and error messages: Type: Warning Message Id: IIS-DSTAGE-STP-00082 Message: STP_stage,0: Error: Datatype not presently supported Type: Fatal Message Id: IIS-DSTAGE-TODC-00017 Message: STP_stage,0: Error occurred in call to ORPHCallActivePluginInitialize(). The NVarChar data type is not currently supported by the Stored Procedure stage. Change an NVarChar columns to type VarChar then save, compile, and re-run the job.

How to search for a pattern for all files under a given directory and its subdirectory. Examples with in COMMON_TOP we need to find all files that have the word ORACLE_SID in it find /appldev/apps/apps_st  -name "<ORACLE_SID>"

Find the Max file size: [applmgr@xxxxx out]$ ls -lSr -rwxrwxrwx 1 applmgr oinstall    3703635 Jun  6 15:45 o5829172.out -rwxrwxrwx 1 applmgr oinstall    3703635 Jun  6 15:04 o5829155.out -rwxrwxrwx 1 applmgr oinstall    3703635 Jun  5 19:38 o5828959.out -rwxrwxrwx 1 applmgr oinstall    3703635 Jun  5 19:38 o5828958.out -rwxrwxrwx 1 applmgr oinstall    3703635 Jun  5 16:44 o5814026.out -rwxrwxrwx 1 applmgr oinstall    3704017 Jun  3 16:18 o5812462.out -rw-r--r--     1 applmgr oinstall    4203665 Jun 21 10:39 o5833173.out -rw-r--r--      1 applmgr oinstall   4212642 Jun 24 11:48 o5833667.out -rw-r--r--     1 applmgr oinstall    4790961 Jun 21 10:39 o5833174.out last 10 Users Connected in Putty [applmgr@xxxxxx out]$ last -10 applmgr    pts/3        192.168.1.135       Mon Jul  1 09:59   still logged in root          pts/4        192.168.1.139        Sat Jun 29 11:49 - 11:53  (00:04) root          pts/3        :1.0                         Sat Jun 29 11:45 - 11:53  (00:08) root   ...

Connect as system and run the following query. ​ ​​ ​​ alter database datafile 'C:\app\administrator\oradata\odi\USERS01.dbf' resize 1000m ;​

When attempting to open a job log in Director, user gets the following error message: Error selecting from log file RT_LOG### Error was: Unable to open DICT 'RT_LOG###'. This is because the D_RT_LOG file is missing from the projects directory. To solve this issue simply copy D_RT_LOG from another project to the project directory that is missing this file. That's it.

​ Unable to open jobs with error "Unable to open the Job Unable to load RID - c2e76d84.43058877.7e01af4f.cd92bbcd-2ebc-4cb3.833e.37a962373ef7" Also in SystemOut.log file, it has the following: [8/25/10 21:21:46:475 UTC] 000000b1 SystemOut O 2010-08-25 21:21:46,475 ERROR ojb.OjbPersistentEObjectPersistence - java.lang.OutOfMemoryError Solution : 1) Try to restart the DS Client and reopen the job 2) Increasing Java Virtual Machine (JVM) Heap will resolve this problem. Here are the steps to do this:     Log into the WebSphere Application Server administrative console.     Select Server > Application Servers and select the <ServerName>.     In the Configuration tab, navigate to Server Infrastructure > Java and Process Management > Process Definition > Additional Properties: Java Virtual Machine     Edit the field Maximum Heap Size. If the default is not specified then it assumes 256. Note: A value greater than 512 MB will improve the perfor...

#!/usr/bin/ksh # Declares a Korn shell ############################### # # ##!/usr/bin/sh # Declares a Bourne shell # ##!/usr/bin/bash # Declares a Bourne-Again shell # ##!/usr/bin/csh # Declares a C shell # ##!/usr/bin/tsh # Declares a T shell # # # # # # SCRIPT: DSgetJobLocks.sh # # DATE: Mar 04, 2014 # # # # # # PLATFORM: (AIX, HP-UX, Linux, Solaris & All Nix ) # # # # # # PURPOSE: This script optionally take arguement and provide the ites locked by # # the user, if no arguement is passed if will give the locked item list for all # # # # # # # Usage : # # ./DSgetJobLocks.sh # # ./DSgetJobLocks.sh atul vibha peter mahei ############################################################################     usr= " $* " user= ` echo " $usr " | sed ' s/ /|/g ' ` echo $user   DS_HOME= ` . /opt/IBM/InformationServer/Server/DSEngine/dsenv ` cd $DS_HOME   echo " " echo " INODE US...

​ Question How do you stop and start all services (DataStage, ASBAgent, WebSphere Application Server) in Information Server on Windows Answer Ensure there are no jobs running and no connections to the Information Server, Information Analyzer and DataStage. Perform the steps as listed below to Stop (shut down) or Start. Shutting down: Stop DataStage services Start -> Control Panel Double click on the DataStage icon to open it Click Stop All Services Stop the ASB Agent Start -> All Programs -> IBM Information Server -> Stop the agent Stop the WebSphere Server Start -> All Programs -> IBM WebSphere -> Application Server v6 -> Profiles -> default -> Stop the server Starting the services: Start the WebSphere Server Start -> All Programs -> IBM WebSphere -> Application Server v6 -> Profiles -> default -> Start the server Start the ASB Agent Start -> All Programs -> IBM Inform...

​#!/bin/bash # Script by Paramaguru DSHOME=`cat /.dshome` export DSHOME cd /opt/IBM/InformationServer/Server/DSEngine . ./dsenv cd /opt/IBM/InformationServer/Server/DSEngine/bin # get list of project and write it in a file ./dsjob -domain servername:9080 -user isadmin -password Lucid2014 -server servername:31539 -lprojects > /root/backup/project cd /opt/IBM/InformationServer/Clients/istools/cli today=`date +%Y%m%d` i=0; for i in `cat /root/backup/project` do         ./istool export -dom servername:9080 -u username -p password -ar "/location/$i"_"$today.isx" -ds "\"servername/$i/*/*.*\" -incdep" done​

Problem(Abstract) When trying to connect to DataStage server to list projects using dsjob command, this error message is received "Status error code =81016" Symptom Error received when attempting to connect to DataStage server from a Windows client to list projects with following command: dsjob.exe -server <ServerName> -user <Username> -password <Password> -lprojects Error received: "Status code = 81016 Cause Status error code =81016 means the connection refused by the server Diagnosing the problem 1. Open Information Server Web Console 2. Go to Domain Management to verify whether the DataStage Server name is listed as fully qualified hostname ( myhost.svl.ibm.com ) or short hostname (myhost) or IP address. 3. Make note of the hostname registered. Resolving the problem Run dsjob command replacing the <ServerName> with exact hostname registered in the In...

Question Why when trying to import metadata through the connector wizard using InfoSphere Information Server tools, such as InfoSphere Information Analyzer, InfoSphere DataStage Designer, InfoSphere FastTrack or InfoSphere Business Glossary, user gets the following error?: "An unexpected exception occurred accessing the repository" JavaException Caused by: com.ascential.xmeta.exception.runtime.AuthenticationException: User xxxxxxxx is not authorized to perform the operation: CommonMetadata.commonMetadataImportRoles Cause Due to user not having the "Common Metadata Administrator" role assigned. You can add this role to the user through the InformationServer web console, 'Administration', 'Users and Groups', Users, select user, 'Open User', Under Roles, tick 'Common Metadata Administrator', Save and Close. Answer InfoSphere Information Server tools, such as InfoSph...

It happened to me few times during the stress tests that Oracle listener became a bottleneck and not be able to handle the required workload. It was resolved by creating  multiple  listeners which appeared to be a quick solution.  Here is a short step-by-step procedure to configure multiple Oracle listeners  on Solaris for standalone Oracle 9i and 10g environment. 1)  First of all, add additional NIC and cables. They can be on separate subnetwork or the same. In the later, make sure to set static route if needed.    2) Assume that we are going to configure two listeners,  LISTENER and LISTENER2 Modify listener.ora and tnsnames.ora as following: Here is a sample of  listener.ora  LISTENER =   (DESCRIPTION_LIST =     (DESCRIPTION =       (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.100.3)(PORT = 1521))     )   ) LISTENER2 =   (DESCRIPTION_LIST =     (DESCRIPTION =       (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.100.2)(PORT = 1525))   ...

Problem(Abstract) The Tivoli Workload Scheduler (TWS) ISMP GUI installation fails to launch with the DISPLAY environment correctly set and other graphical programs running successfully. Symptom The installer is unable to run in graphical mode. Try running the installer with the -console or -silent flag. Cause Linux libraries are missing. Diagnosing the problem Detailed system requirements for Tivoli Workload Scheduler, version 8.5.1 https://www-304.ibm.com/support/docview.wss?uid=swg27017192 Required Linux libraries for TWS v8.3 and above https://www-304.ibm.com/support/docview.wss?uid=swg21392107&wv=1 According to the documentation above, the following libraries are required: For all Linux on x86-64 operating systems (install both 32-bit and 64-bit libraries):     libstdc++.so.5     libgcc_s.so.1     libstdc++-libc6.1-2.so.3 (or a soft link to libstdc++-libc6.2-2.so.3) (Linux 32 and 6...

​ Problem(Abstract) ASBAgent fails to start after following instructions for changing host name found in document titled "Instructions for Changing the Information Server Services & Engine Hostname" The following errors are in the "asbagent_startup.err" file: [ISF-AGENT-APP] [0020] Error retrieving the configuration for this agent. com.ascential.asb.agent.config.AgentNotConfiguredException: Server "<server name>:31531" does not have an agent configured. at com.ascential.asb.agent.config.server.impl.AgentConfigurationImpl.getAgentMetaData(AgentConfigurationImpl.java:334) at com.ascential.asb.agent.config.server.impl.AgentConfigurationBean.getAgentMetaData(AgentConfigurationBean.java:256) at com.ascential.asb.agent.config.server.EJSRemoteStatelessAgentConfiguration_c53aed69.getAgentMetaData(Unknown Source) at com.ascential.asb.agent.config.server._EJSRemoteStatelessAgentConfiguration_c53aed69_Tie.getAgentMetaData__CORB...

​ Problem(Abstract) Empty Connectors list while importing metadata in Infosphere Information Server v8.7 Identifying dangling or unbalanced references in IBM InfoSphere Xmeta repository Agent Connection Error : Failed to create connection. Cause There is a dangling reference on xmeta that needs to be replaced with the object's RID found in the logs Diagnosing the problem In SystemOut.log , there is a record like "An inconsistent graph was read from the repository. Encountered reference to non-existent object from an instance of "ASCLModel.Connector" XmetaDiagnosticReport.xml log file obtained after running ISALite Xmeta Diagnostic Test displays the following record : <log4j:eventlogger="com.ascential.xmeta.diagnostic.probes.database.danglingreferences.DanglingReferencesProbe" timestamp="1352894335920" level="ERROR" thread="org.apache.commons.launcher.ChildMain"> ...

Problem When a J2EE web application is deployed into the WebSphere Application Server 7 (WAS), the WAS started to load very slow and keep hanging for whatever actions selected, end with a " java.lang.OutOfMemoryError " error message in the WebSphere's log file. Solution The default WebSphere's Java Virtual Machine memory is not enough; you should adjust more memory to your WebSphere Application Server. See following guide to increase WebSphere's JVM memory. 1. In WebSphere web console, select Servers -> Server Types -> WebSphere application servers -> Server Infrastructure -> Java and Process Management -> Process definition. 2. In Additional Properties section, select Java Virtual Machine 3. In General Properties section, put 256 for "Initial heap size" and 1024 for "Maximum heap size". Done, restart WebSphere.

Open PCManFM. Choose Edit->Preferences. Navigate to the bottom and set your View Mode.

Job Control Error codes . Equ DSJS.RUNNING To 0 ;* This is the only status that means the job is actually running Equ DSJS.RUNOK To 1 ;* Job finished a normal run with no warnings Equ DSJS.RUNWARN To 2 ;* Job finished a normal run with warnings Equ DSJS.RUNFAILED To 3 ;* Job finished a normal run with a fatal error Equ DSJS.VALOK To 11 ;* Job finished a validation run with no warnings Equ DSJS.VALWARN To 12 ;* Job finished a validation run with warnings Equ DSJS.VALFAILED To 13 ;* Job failed a validation run Equ DSJS.RESET To 21 ;* Job finished a reset run Equ DSJS.CRASHED To 96 ;* Job has crashed Equ DSJS.STOPPED To 97 ;* Job was stopped by operator ntervention (can't tell run type) Equ DSJS.NOTRUNNABLE To 98 ;* Job has not been compiled Equ DSJS.NOTRUNNING To 99 ;* Any other status DataStage API error codes 0 DSJE_NOERROR No...

​ Problem(Abstract) You are unable to add new data store in Information Analyzer using the DB2 or Oracle Connector Cause ASB Agent connections managed in WebSphere Application Server have been exhausted. Diagnosing the problem Add a new data store in Information Analyzer client. When defining a Data Connection, select DB2Connector or OracleConnector. The error message "Unable to connect successfully using the selected connector. Check to ensure the selected connector is installed in the engine tier system or select a different connector to establish the connection" is displayed. Information Server Console log (isc.log) located in the directory "C:\Documents and Settings\<user>\Local Settings\Application Data\IBM\IBM Information Server console" on the client tier contains the following errors: <Type>com/ascential/investigate/cas/exception/CASConnectionException</Type> <Message><...

Check whether you have the Aero mouse scheme enabled on the local device, change this back to None. -- Thank You. Regards, Guru

To enable rsh To ensure that the rsh and rsh-server packages are installed, type the following command: # rpm -qa | grep -i rsh If it is not already in the file, type the following command to append the line " rsh " to the /etc/securetty file: # echo "rsh" >> /etc/securetty Modify /etc/init.d/rsh disable=no. In the /etc/pam.d/rsh file, change the " auth " type from " required " to " sufficient ": auth sufficient Add the "promiscuous" flag into /etc/pam.d/rsh and /etc/pam.d/rlogin after item "pam_rhosts_auth.so". To enable the rsh server, type the following command: # chkconfig rsh on Modify the .rhosts file. Each line of the .rhosts file contains a fully qualified domain name or IP address for each remote system. This file also contains the name of a user having access to the local system. For example, if the root user must remotely access system1 from system2 , add an ...

​ 1.  Copy the following file and save it as /etc/init.d/db2server #!/bin/bash # # chkconfig: - 91 35 # description: Starts and stops db2server. \ # Source function library. . /etc/init.d/functions # Source networking configuration. . /etc/sysconfig/network # Check that networking is up. [ ${NETWORKING} = "no" ] && exit 0 prog="DB2" inst="db2inst1" start() {     echo -n $"Starting $prog: "     su - $inst -c "db2start" } stop() {     echo -n $"Shutting down $prog: "     su - $inst -c "db2stop force" } # See how we were called. case "$1" in   start)         start         ;;   stop)         stop         ;;   restart|reload)         stop         sleep 3         start         ;;   *)         echo $"Usage: $0 {start|stop|restar...

Problem(Abstract) Error: Unexpected protocol character/message Symptom A remote client connecting to the database intermittently displays the following error message: 'SimpleDB::Database::Exception' what(): Error SQLConnect: [unixODBC]Unexpected protocol character/message Cause The problem occurs when DNS and/or network response becomes slow which causes an nslookup timeout error on the Netezza side of the remote connection. Resolving the problem To prevent this error, do the following: 1. Confirm that the client IP address is listed in the  /etc/hosts  file on the host; if not, add it. 2. Confirm that the host domain name is listed in the client's  /etc/hosts  file; if not, add it. These changes eliminate the need for the reverse lookup over the network. ​Source: http://www-01.ibm.com/support/docview.wss?uid=swg21569232 ​

Citrix Receiver 13.1 on Ubuntu 14.04 1. (64-bit only) Alternative install procedure that can be added to a deployment bash script http://mark911.wordpress.com/2014/06/27/how-to-install-citrix-receiver-icaclient-in-ubuntu-14-04-lts-64-bit-tested-and-working-using-mozilla-firefox/ 2. (64-bit only) Enable i386 Multiarch Even the Citrix Receiver for 64-bit systems has a lot of dependencies on packages from the i386 architecture. If you are using 64-bit Ubuntu and have not already configured i386 multiarch, you must configure it by running: sudo dpkg --add-architecture i386 sudo apt-get update 3. Download the Citrix Receiver for Linux .deb package Go to https://www.citrix.com/downloads/citrix-receiver/linux/receiver-for-linux-131.html Near the bottom of the page, select either "For 64-bit Systems" or "For 32-bit Systems" as appropriate. Look for "File Type: .deb" under the Download buttons. Download the "Receiver for Linux" package. O...

The steps are as follows: Choose a picture you want to use. Optionally you can create one - preferably with equal dimensions (a square). Save the picture (in .PNG format) as ~/.face .