Guru Of Geeks

Technote (troubleshooting) Problem(Abstract) Unable to open the "Edit assembly" page of the Hierarchical Stage properties. Getting error "The underlying connection was closed : Unable to establish a trust for the secure channel SSL / TLS" Cause The security defined on the client machine does not allow installation of certificate. Diagnosing the problem Use the direct URL link to access the Edit Assembly page : https://<hostname>:<portnumber>/ibm/iis/ds/xmlpack3/index.html# example : https://MyServerIIS.ibm.com:9443/ibm/iis/ds/xmlpack3/index.html# Resolving the problem You can manually install the certificate using the following procedure : 1) Extract the certificate from the WebSphere Application Server web console into a file : From a web browser, go to the WebSphere Application Server web console : https://<hostname>:9043/ibm/console On the left menu ...

Technote (troubleshooting) Problem(Abstract) IBM InfoSphere DataStage and QualityStage Operations Console sometimes displays the Disk Space information of a selected engine as 'Nothing monitored'. For example, Activity > Resources > Charts > Disk Space > MYSERVER (Engine) > (Nothing monitored) Cause The Operations Console retrieves a list of mounted file systems to be monitored from the DSODBConfig.cfg file on the engine tier. The possible causes for the issue: - Properties ResourceLocalFS and / or ResourceRemoteFS in the DSODBConfig.cfg are not set. - The file systems specified in these properties do not actually exist. - Properties ResourceLocalFS and / or ResourceRemoteFS have leading and trailing spaces in their names and values. For example, # The following specifies a locally mounted file system to be monitored. # This property can be repeated any number of times to specify multiple file systems.   ResourceLocalF...

​ Technote (troubleshooting) Problem(Abstract) DataStage clients cannot connect to the server after a reboot of the engine tier. Symptom DSEngine does not start automatically on RHEL7 even though ds.rc links have been set up under /etc/init.d and /etc/rc[2-5].d. Cause In Red Hat Enterprise Linux 7, systemd replaces upstart as the default init system. Environment RHEL 7 Resolving the problem The following steps work around the issue . Root access is necessary. For non-itag installs:--- Create a file "/usr/lib/systemd/system/ds.rc.service" with the following content. [Unit] Description=DataStage Engine Requires=basic.target [Service] Type=forking RemainAfterExit=yes ExecStart=/etc/init.d/ds.rc start ExecStop=/etc/init.d/ds.rc stop [Install] WantedBy=multi-use...

Technote (troubleshooting) Problem(Abstract) The following error occurs when editting an LDAP group definition, using Information Server web console , if the group name contains an ampersand '&' character : The ID you entered contains invalid characters, re-enter the ID with valid characters and try again. For a list of valid characters, click the help icon. Resolving the problem Prior to 11..3. Customers could edit the isfconfig.properties file to modify the list of valid characters. Starting with IIS 11.3 and above, the isfconfig.properties file is no longer used. The properties are now saved in the repository. 1- You can list the property by running: sh-4.1# /opt/IBM/InformationServer/ASBServer/bin/iisAdmin.sh -display -key com.ibm.iis.isf.security.directory.principalIdAllowedCharacters com.ibm.iis.isf.security.directory.principalIdAllowedCharacters=_-,\ =$.@ 2- You can set the new value by appending characters l...

Technote (troubleshooting) Problem(Abstract) On the RedHat Enterprise Linux 6.1 operating system, parallel jobs run with degradated performance. Symptom On RedHat Linux 6.1 system there is a 10 - 90% performance degradation depending on the hardware configuration and DataStage node configuration during parallel job runs. Increase in number of CPU cores and DataStage node counts used on the system leads to more performance degradation. Cause This is caused by Parallel jobs using transformer stages and use of the CurrentTimestampMS() function in the transformer stage on the Redhat Linux 6.1 system. Resolving the problem On the computer that has the Redhat Enterprise Linux 6.1 operating system installed, set the environment variable as follows: TZ=:/etc/localtime before running parallel jobs. The CPU time improves. ...

Technote (troubleshooting) Problem(Abstract) Unable to retrieve data from the metadata repository using a SQL view due to insufficient privileges on an Oracle database. This may manifest itself as an internal server error when clicking an action on the Information Analyzer Web UI. Cause On an Oracle environment the metadata repository user (default name: xmeta) doesn't have the permission to access the objects under the Information Governance Dashboard(CMVIEWS, IGVIEWS, IAVIEWS, etc.,) schemas by default which causes exceptions such as the following when trying to query a SQL view: [Oracle]ORA-01031: insufficient privileges [Oracle]ORA-00942: table or view does not exist Missing privileges to access a SQL view can cause actions on the Information Analyzer Web UI such as 'Find data sets' to fail since these actions query the SQL views to retrieve values from the metadata repository based on the privileges of th...

Configure ODI 11g Local Agent: Today we are going create and configure Local Agent in ODI 11g. So open your odi studio and proceed as per below screenshot. Before doing any modification to the odiparams.bat file, take a backup of this. So that in case of any problem you can put this file again. We need to change the value for below pointed line in the screenshot. Just modify the bold values only but not others. Now open command prompt and go to ODI_HOME\oracledi\agent\bin. For encoding master repository password in windows use " encode your_master_repo_pwd ". For unix use " sh encode.sh your_master_repo_pwd " REM # Repository Connection Information REM # set ODI_MASTER_DRIVER=oracle.jdbc.OracleDriver set ODI_MASTER_URL= jdbc:oracle:thin:@localhost:1521:xe set ODI_MASTER_USER= ODI_MASTER1 set ODI_MASTER_ENCODED_PASS= bSyphW25OZr9ggsHRfvfy REM # REM # User credentials for agent startup program REM # set ODI_SUPERVISOR=SUPE...

Problem(Abstract) Attempts to launch DataStage client tools (DS Designer, DS Administrator, DS Director) results in a certificate warning. Symptom After installing Information Server Client, users might see a certificate warning when launching the client tools. Cause Certificate must be installed otherwise the client connection is flagged as untrusted. Environment Information Server Client Diagnosing the problem User must select and install certification Resolving the problem Click "View Certificate" Select the PARENT certificate and click "View Certificate". Note that if child certificate is selected, the installation will be successful however the issue will persist. Click "Install Certificate..." Select "Place all certificates in the following store" Click "Browse" Select "Trusted Root C...

Problem(Abstract) Istool command fails with "java.net.SocketTimeoutException: Read timed out" Symptom Command: /opt/IBM/InformationServer/Clients/istools/cli/istool.sh export -domain UHQTETL02:9445 -authfile '/home/BICCBLD/.ds_auth' -ar export-uhqtetl01-20150720.isx -up -ds '-incdep "UHQTETL01/BICC_DEV/Jobs/*/*.*"' –verbose Beginning Export Export failed: Read timed out; nested exception is: java.net.SocketTimeoutException: Read timed out Cause Some import operations take longer than the 10 minute default client timeout setting. Resolving the problem To resolve this issue, do the following: 1) Log in to the Engine server where the istool command is executed from 2) Go to .../ASBNode/eclipse/plugins/com.ibm.iis.client/ 3) Do a vi on iis.client.site.properties file 4) Locate "com.ibm.iis.http.soTimeout" entry. If it not present, then create it at the bottom ...

Question Where are the log files for IBM InfoSphere Information Governance Catalog found? Cause The log file names changed because InfoSphere Information Governance Catalog replaces IBM InfoSphere Business Glossary and IBM InfoSphere Workbench. Answer On the Services tier: If running WebSphere Application Server Liberty Profile Look in .../IBM/InformationServer/wlp/usr/servers/iis/logs/ : igc.log (with any .1, .2, ...) igc-admin-services.log (with any .1, .2, ...) omd-importer.log (with any .1, .2, ...) messages.log     // often helps with "unknown errors" in the user interface Look in .../IBM/InformationServer/wlp/usr/servers/iis/ for memory heap dumps and java core dumps  // often helps when out of memory and the server hangs   If running WebSphere Application Server Network Deployment...

[oracle@localhost ~]$ lsnrctl LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 18-JAN-2012 22:45:15 Copyright (c) 1991, 2005, Oracle.  All rights reserved. Welcome to LSNRCTL, type "help" for information. LSNRCTL> reload Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost.localdomain)(PORT=1521))) TNS-12541: TNS:no listener  TNS-12560: TNS:protocol adapter error   TNS-00511: No listener    Linux Error: 111: Connection refused LSNRCTL> service            Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost.localdomain)(PORT=1521))) TNS-12541: TNS:no listener  TNS-12560: TNS:protocol adapter error   TNS-00511: No listener    Linux Error: 111: Connection refused This problem is related with IP address. To solve, just follow the following simple steps:- [oracle@localhost ~]$ su - root Password: [root@localhost ~]# vi /etc/hosts         (copy & paste the below line) 127.0.0.1       ...

Before you can change the SERVICE_NAME in your TNSNAMES.ORA file you have to make sure that the SERVICE_NAMES parameter on the database is configured appropriately. You can display the current value as follows: SQL> show parameter service_names By default the SERVICE_NAMES parameter is a concatenation of the DB_NAME and DB_DOMAIN parameters. However, you can change it to whatever you'd like and it can take multiple values. For example: ALTER SYSTEM SET SERVICE_NAMES='application_a.your.domain','application_b.your.domain' SCOPE=BOTH; Using SERVICE_NAMES is a good way to isolate applications for tracing and metrics measurement.

Step 1 - Set the CC_MSG_LEVEL environment variable and restart ASBAgent 1. Make a backup of the dsenv file (typically located at /opt/IBM/InformationServer/Server/DSEngine/dsenv) 2. Edit the dsenv file, adding the following lines to the end of the file: CC_MSG_LEVEL=1; export CC_MSG_LEVEL 3. Source and export the dsenv file 4. Ensure no users are importing metadata, viewing data or testing connections (i.e. no design-time activities are on-going) 5. Restart the ASBAgent. To restart the agent:      1. Become root      2. cd /opt/IBM/InformationServer/ASBNode/bin      3. Execute ". ./NodeAgents_env_DS.sh". Notice the period at the beginning.      4. Execute "./NodeAgents.sh restart"      Step 2 - For IIS versions 11.3 .0 or later 1. If your IIS version is 9.1.2 or earlier jump to step 6. 2. Become root on engine tier. 3. cd /opt/IBM/InformationServer/ASBNode/conf 4. Add the following 1 line at the tail of fil...

Error description When converting Information Server from a stand-alone LDAP configuration to a Federated user registry that includes the same LDAP registry, the Information Server security roles previously assigned to LDAP users and groups are no longer seen by Information Server for the same users and groups. Likewise, any Business Glossary asset permissions or Steward assignments no longer work. In addition, errors occur in the Information Server Web Console when opening Users or Groups. Additional problems occur if a user or group previously assigned a role no longer exists in the configured LDAP registry. Local fix Some of the issues are caused by a known WAS issue and require a WAS iFix ( PM89827 ) to be installed. This iFix also requires a configuration change to WAS to enable it. However, this only addresses the issues caused when a user or group no longer exists in the external LDAP registry and only fixes the issue when attributes are not mappe...

One of the best tools for quickly finding files by filename is the locate command. The locate command reads one or more databases prepared by updatedb and writes file names matching at least one of the patterns to standard output, one per line. Pre-Flight Check These instructions are intended specifically for installing mlocate on CentOS 7. I'll be working from a Liquid Web Self Managed CentOS 7 server, and I'll be logged in as root. Step 1: Install mlocate As a matter of best practice we'll update our packages: yum -y update Then let's install mlocate and any required packages: yum -y install mlocate Step 2: Updating mlocate The following command will update the search databases: updatedb mlocate installs a cron job that will run daily to update search databases at: /etc/cron.daily/mlocate.cron

The htop utility in Linux allows you to interactively monitor the processes in real time. It's very similar to top but has some extra features that makes it an even better command line utility for process monitoring. Here is an excerpt from the man page of htop :        Htop is a free (GPL) ncurses-based process viewer for Linux. It  is similar to top, but allows you to scroll vertically and horizon‐ tally, so you can see all the processes running on  the  system,  along with their full command lines. Tasks  related  to  processes  (killing,  renicing) can be done without entering their PIDs. The htop utility is not bundled by default in Linux distributions but it can be easily downloaded and installed.  Once the download and installation is done, this utility can be run through command line by just typing in 'htop'. Here is how an htop window looks like :                                            The whole window above can be divided into three sections. ...

Intermittent failure of Information Analyzer column analysis jobs and metadata import through IMAM while using the DataDirect DB2 wire protocol Drivers included for Information Server 11.3.1.2 Abstract Information Analyzer column analysis jobs and metadata import through IMAM intermittently fail while using DataDirect Drivers that are included for Information Server 11.3.1.2 The following errors are seen : 1) IMAM imports fail through ODBC connector on LINUX with the following exception : [4/20/15 9:17:25:341 EDT] 000000b9 cas E CDICC0415E: Failed to send the request to the handler: Error unmarshaling return header; nested exception is: java.io.EOFException [4/20/15 9:17:25:345 EDT] 000000b9 mif E IMAM_MIF> There was an error testing the data connection using the connector CAS/ODBCConnector__3.5 com.ibm.iis.cas.shared.exceptions.CommunicationException: Failed to send the request to the handler: Error unmarshaling return header; nested exception is: ...

​Open the eclipse.ini file and add the below lines: - vm yourdrive\java\bin ​

To apply any of the DB2 Enterprise Server Edition , DB2 Advanced Enterprise Server Edition , DB2 Workgroup Server Edition , or DB2 Advanced Workgroup Server Edition licenses: Install the DB2 Version 10.5 – Workgroup, Enterprise, and Advanced Editions common image using the DB2 Setup wizard. Run the db2licm -a command, to apply the relevant licenses for either the DB2 Enterprise Server Edition , DB2 Advanced Enterprise Server Edition , DB2 Workgroup Server Edition , or DB2 Advanced Workgroup Server Edition . Windows db2install_path \bin\db2licm -a filename where db2install_path is the DB2 installation path, filename is the full path name and file name for the license certificate file that corresponds to the DB2 product edition you have purchased. Linux or UNIX INSTHOME /sqllib/adm/db2licm -a filename where INSTHOME represents the home directory of the instance owner and filename is the full path name and file name for the license certificate file that corre...

Here we are going to discuss how to delete the profile in Websphere Application server environment. I used the following to remove application server profile. Note: Before deleting profile we need to stop all services associate with it. e.g. Stop the Application server and webServer if configured. Procedure: First list all profiles on a server: List the profile using one of these commands Windows: was_install_dir\bin\ manageprofiles.bat –listProfiles UNIX/Linux: was_install_dir/bin/ manageprofiles.sh –listProfiles Remove a WebSphere Application Server profile: Delete the profile using one of these commands: On Windows: was_install_dir\bin\ manageprofiles.bat –delete –profileName profile On UNIX/Linux: was_install_dir/bin/ manageprofiles.sh –delete –profileName profile Ensure that references to the deleted profile are removed from the profile registry by running the following command: ...

Issue: When I import the following sql create statement mysql > CREATE TABLE IF NOT EXISTS ` erp `.` je_menus ` ( -> ` id ` INT ( 11 ) NOT NULL AUTO_INCREMENT , -> ` name ` VARCHAR ( 100 ) NOT NULL , -> ` description ` VARCHAR ( 255 ) NOT NULL , -> ` live_start_date ` DATETIME NULL DEFAULT NULL , -> ` live_end_date ` DATETIME NULL DEFAULT NULL , -> ` notes ` VARCHAR ( 255 ) NULL , -> ` create_date ` TIMESTAMP NOT NULL DEFAULT '0000-00-00 00:00:00' , -> ` created_by ` INT ( 11 ) NOT NULL , -> ` update_date ` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP , -> ` updated_by ` INT ( 11 ) NOT NULL , -> ` status ` VARCHAR ( 45 ) NOT NULL , -> PRIMARY KEY (` id `) ) -> ENGINE = InnoDB ; giving following error ERROR 1067 (42000): Invalid default value for 'create_date...

grep 'temporary password' /var/log/mysqld.log Sort date (newest date) You may see something like this; [root@SERVER ~]# grep 'temporary password' /var/log/mysqld.log 2016-01-16T18:07:29.688164Z 1 [Note] A temporary password is generated for root@localhost: O,k5.marHfFu 2016-01-22T13:14:17.974391Z 1 [Note] A temporary password is generated for root@localhost: b5nvIu!jh6ql 2016-01-22T15:35:48.496812Z 1 [Note] A temporary password is generated for root@localhost: (B*=T!uWJ7ws 2016-01-22T15:52:21.088610Z 1 [Note] A temporary password is generated for root@localhost: %tJXK7sytMJV 2016-01-22T16:24:41.384205Z 1 [Note] A temporary password is generated for root@localhost: lslQDvgwr3/S 2016-01-22T22:11:24.772275Z 1 [Note] A temporary password is generated for root@localhost: S4u+J,Rce_0t  [root@SERVER ~]# mysql_secure_installation Securing the MySQL server deployment. Enter password for user root: The existing password for the user account root has expired. Please s...