Each IIS component has a primary function in the InfoSphere architecture, which can be synopsized as follows: Application Function Blueprint Director IBM InfoSphere Blueprint Director is aimed at the Information Architect designing solution architectures for information-intensive projects. Cognos (If purchased) Governance Dashboard (Framework Manager Model provided by IBM), Semantics, Analytics, and Reporting Data Architect Data Architect is an enterprise data modeling and integration design tool. You can use it to discover, model, visualize, relate, and standardize diverse and distributed data assets, including dimensional models. Data Click Data Click is an exciting new capability that helps novices and business users retrieve …
Tag
Showing: 11 - 20 of 46 RESULTS
Technology2
Infosphere Information Server (IIS) – Metadata Repository Databases
This is a snippet of very useful information, which is buried in the IBM documentation. So, I thought I would bring it up a level for those of you who may be making decisions regarding Information server installations (IIS). The table below provides an excerpt of the IBM IIS repository databases placement and guidance. Please, keep in mind that which of these databases may be required for your installation may be a subset of these database depending upon your IIS product offering license. Metadata Repository Databases Repository or Database Description Default Database And Schema Active Infosphere Information Server Metadata Repository …
InfoSphere – JobRun Table, Run Type Codes
The JobRun table contains details of information about the IBM InfoSphere DataStage and QualityStage jobs that have run or are currently running. Column name RunType Column Type Code Reference (Ref) Column Description Column distinguishes a normal run from a validate or reset run. Source View runtyperef Source View Structure RUNTYPECODE Varchar(3 OCTETS) RUNTYPENAME Varchar(32 OCTETS) RUNTYPEDESCRIPTION Varchar(255 OCTETS) Current Values RUNTYPECODE RUNTYPENAME RUNTYPEDESCRIPTION ?!? Invalid value A non-numeric value was found ??? Unknown value An out-of-range numeric value was found RES Reset Reset run RUN Run Normal run mode VAL Validate Validation-only run Related Links JobRun table Job run audit …
Infosphere – decimal_from_string Conversion Error
This is another one of those nebulas error, which can kick out of DataStage, DataQuality, and/or DataClick. This error can be particularly annoying because it doesn’t identify the field or even the precise command, which is causing the error. So, there can be more than a field and/or more than one command causing the problem. Error Conversion error calling conversion routine decimal_from_string data may have been lost Resolution To resolve this error, check for the correct formatting (date format, decimal, and null value handling) before passing to DataStage StringToDate, DateToString, DecimalToString or StringToDecimal functions. Additionally, even if the formatting is …
Productivity Tip – Quickly create a new surrogate key file
This productivity tip, is how we can quickly create a new surrogate key file in Linux. This example is leveraging native capabilities of Red Hat Enterprise Linux (RHEL) to skip a few commands, by using an existing surrogate key file to create a new surrogate file with a minimum of keys strokes and command line entries. Creating a New Surrogate Key File From an Existing File The basic process consists of just a few steps: Navigate to the location of your existing surrogate key files Copy an existing surrogate file Empty the new surrogate key file Navigate to the location of …
Productivity Tip – Changing Owner and Groups on Surrogate Key File
This practice tip, is how we quickly update surrogate key file owner and group in Linux. This example is leveraging native capabilities of Red Hat Enterprise Linux (RHEL) to skip a few commands, by using a combined command to set both the owner and group of a surrogate key file in a single command. Surrogate Key File Owners and Groups To ensure the DataStage has access to the path and Surrogate files, ensure the ‘dsadm’ (owner) and ‘dstage’ (group) have access to the surrogate key files Setting Surrogate Key File Owners and Groups You can change the ownership and group …
Surrogate Key File Effective Practices
Here are a few thoughts on effectively working with IBM Infosphere, Information Server, DataStage surrogate key files, which may prove useful for developers. Placement The main thing about placement is that it be in a consistent location. Developers and production support teams should need to guess or look up where it is for every DataStage project. So, it is best to put the surrogate keys in same base path and that each project has its own subfolder to facilitate migrations and to reduce the possibility of human error. Here Is the patch structure, which is commonly use: Path /data/SRKY/<<Project Name>> …
Netezza Connector Stage, Table name required warning for User-defined SQL Write mode
Recently, while working at a customer site and I encountered an anomaly in the Netezza Connector stage, when choosing ‘User-defined SQL’ write mode, the ‘Table name’ displays a caution/warning even though a table name should not be required. If you are using a user-defined SQL statement and/or have parametrized your SQL scripts to make the job reusable, each SQL and/or SQL script would have its own schema and table name being passed in. After some investigation, a workaround was found, which both allows you to populate table name and leverage with different schema and table names within your SQL statement and/or. Table …
Essbase Connector Error – Client Commands are Currently Not Being Accepted
While investigating a recent Infosphere Information Server (IIS), Datastage, Essbase Connect error I found the explanations of the probable causes of the error not to be terribly meaningful. So, now that I have run our error to ground, I thought it might be nice to jot down a quick note of the potential cause of the ‘Client Commands are Currently Not Being Accepted’ error, which I gleaned from the process. Error Message Id IIS-CONN-ESSBASE-01010 Error Message An error occurred while processing the request on the server. The error information is 1051544 (message on contacting or from application:[<<DateTimeStamp>>]Local////3544/Error(1013204) Client Commands are …
What are the Infosphere DataStage job status log values?
These are the job status codes seen when running Infosphere Datastage jobs and sequences. Additional information regarding a specific job or sequence error can be seen in Director. Table of dsjob utility Status Codes dsjob utility Status Codes Log/Status Description Job State Comments 0 Running Not Runnable This is the only status that means the job is actually running 1 Finished Runnable Job finished a normal run with no warnings 2 Finished (See Log) Runnable Job finished a normal run with warnings 3 Aborted Not Runnable Job finished a normal run with a fatal error 4 Queued …