Conceptual Data Model

A conceptual data model identifies the highest-level relationships between the different entities. Features of conceptual data model include:

• Includes the important entities and the relationships among them.
• No attribute is specified.
• No primary key is specified.

The figure below is an example of a conceptual data model. 

How to use ISTOOL for EXPORT IMPORT in DataStage

Location of command:

UNIX: /opt/IBM/InformationServer/Clients/istools/cli
Windows: IBM\InformationServer\Clients\istools\cli



Export command sample:

domain name: SERVER.us.ibm.com
port no: 9080
DS Server name: SERVER
DS Project name: Test

Connect Oracle Database as SYSDBA

Log into the database via sqlplus with sysdba priv’s with a single command. This can be setup with an alias, if you’d like.

#. Log into the server as the oracle user and ensure you have the effective group of the appropriate DBA group. Typical unix installations have the OS user as ‘oracle’ and the dba group as 'dba' (not to be confused with the ‘oinstall’ group).  

#. Check your account with the unix ‘id’ command. Make sure your environment variables are set to the appropriate database:

Issuing commands to a Queue Manager (runmqsc)

Once we have created a Queue Manager, we will want to perform administrative tasks, such as creating queues, among others. To enable us to communicate with our Queue Manager, we use the RUNMQSC MQ command, which opens the MQSC (MQ Script Center) environment.

After entering the MQSC environment, we can issue one of the following MQSC commands: ALTER, CLEAR, DEFINE, DELETE, DISPLAY, END, PING, REFRESH, RESET, RESOLVE, RESUME, START, STOP, or SUSPEND. Each of these commands has it's own options, which are shown in the following table:

What Service is Running on which Port in Windows

Finding out what application is running on a specific port in Windows is easy by using two command line utilities. By using netstat with the proper switches you can list out all of the ports that are being used and then use Tasklist to list all of the applications that are running. The combination of the two utilities will allow you to figure out which application us using which port.

As an example you can use the below directions to figure out At which port Oracle is running....

Cannot authenticate user in DataStage

When you attempt to start one of the InfoSphere DataStage Administrator clients, the following message is displayed:

Failed to authenticate
the current user against the selected Domain:  Invalid user name (username) or password.

Solutions

Diagnosing DataStage Job Monitor problems

DataStage job run statistics (i.e. rows per second processed) do not update in DataStage Designer or Director clients.

 

Check these details :

This section contains a quick series of diagnosis steps for those familiar with DataStage and Job monitor. If more detail is needed for any step, please refer to the more detailed instructions in the "Resolving the Problem" section:
If customer has checked and verified that the following:

TeraData EXPLAIN Command

The EXPLAIN command is a powerful tool provided with the Teradata database. It is designed to provide an English explanation of what steps the AMP must complete to satisfy the SQL request. The EXPLAIN is based on the PE's execution plan.

The Parsing Engine (PE) does the optimization of the submitted SQL, the creation of the AMP steps and the dispatch to any AMP involved in accessing the data. The EXPLAIN is an SQL modifier; it modifies the way the SQL operates. 

Stopping and Starting Oracle 11g Database Services in Windows

There are lot of services consuming a lot of CPU when an Oracle DB is running on machine. If you are using Oracle for learning/testing purpose only then you do not want to keep it up all the time.

So, here I am sharing 2 batch files for Stopping & Starting the Oracle Services on Windows which can do your work in one click only...

Read/Write/Load Message with MQ : Part-3

Previous posts on "WebSphere MQ"  you can find HERE.

Write Message in the Queue with MQ Stage

TeraData SHOW command

The Teradata Database offers several types of help using an interactive client.

There are times when you need to recreate a table, view, or macro that you already have, or you need to create another object of the same type that is either identical or very similar to an object that is already created. When this is the case, the SHOW command is a way to accomplish what you need. The intent of the SHOW command is to output the CREATE statement that could be used to recreate the object of the type specified.

SHOW TABLE <table-name>; 
Displays the CREATE TABLE statement needed to create this table.

TeraData HELP command

HELP Command in Teradata plays a important role, This is something like “DESCRIBE” command in Oracle and DB2. This will display the object details.

The HELP Command is used to display information about database objects such as
●     Databases and Users
●     Tables
●     Views
●     Macros

HELP retrieves information about these objects from the Data Dictionary. Below are the syntactical options for various forms of the HELP command:

Read/Write/Load Message with MQ : Part-2

Post Linked :

What is MQ Stage ???

Read/Write/Load Message with MQ : Part-1

A) PUT

JDBC connection with Teradata

Today I am going to tell you how to connect to TeraData via JDBC, Here I have used a RazorSQL tool.  For JDBC connection with TeraData, you can find the JDBC drivers here. Teradata JDBC driver enables all Java applications to connect a Teradata database using a well-established industry standard Java Database Connectivity (JDBC) API interface.

A new database connection can be obtained in a standard JDBC way by using java.sql.DriverManager.getConnection method with a proper connection string to get a new instance of java.sql.Connection.

The simplest database connection string would be:

datastage4you QAnT - April2013 - 2

Click here ---> datastage4you QAnT - April2013 - 1

#14. DataStage Server – starting the server
a) DB2
su - db2inst1 -c "db2start“
b) WAS Server
/opt/IBM/WebSphere/AppServer/bin/startServer.sh server1 -user wasadmin -password PASSWORD
c) NODE
/opt/IBM/InformationServer/ASBNode/bin/NodeAgents.sh start
d) Engine
/opt/IBM/InformationServer/Server/DSEngine/bin/uv -admin -start