DataStage Error - Cannot authenticate user

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

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

 

There are several possible causes of this problem.

• The user name is invalid.
• The password is invalid or has expired.
• The user has no suite user role.
• Credential mapping is required, but has not been defined for this user.
• The user has no DataStage role or has the incorrect DataStage role.

Get list of locked item on DataStage Server with Script

This script can be run with or without any argument and provide the list of Job, item locked in DataStage environment by any user. This script will help release the locks if user doesn't locked the item.

Script Name : DSgetJobLocks.sh
Usage : ./DSgetJobLocks.sh [one or more argument]

Dummy Data Generation using Row Generator in DataStage - 2

By default the Row Generator stage runs sequentially, generating data in a single partition. You can, however, configure it to run in parallel and meaningful data.

We are using the same job design as in Dummy Data Generation using Row Generator in DataStage - 1


a) Job Design :

How many places u can call Routines?

Routines can be called at the following places:

a) In the job properties There is an option to call the Before and After job subroutines.
b) In the job sequence there is an activity called "Routine Activity".From there also the routines could be called.
c) In the derivation part of theTransformer of a parallel job "parallel routines"can be called.
d) In the derivation part of theTransformer of a server job "server routines"can be called.
f)In the server job stages also before and after job subroutines can be called.
g)We have called routines from user variable activity of a sequence as well.(Here basically transforms are called which return a value to the variable of the user variable activity after their execution.)

Search the string in the file : Linux/Unix

Here, I am going to share a small shell utility which will ask source file name and the pattern which need to be searched in file and give the formatted output with the line no with line. You can select the no of lines which display before and after the string.

Lock/Unlock Oracle Users

In spite of deleting an oracle user, we can LOCK it. In that way the user won’t be accessible. In future if we want we can UNLOCK it.

create a user named JACK which is LOCKED:
SQL> create user jack identified by jack account lock;
User created.

Teradata Users

 In Teradata, a user is the same as a database with one exception. A user is able to logon to the system and a database cannot. Therefore, to authenticate the user, a password must be established. The password is normally established at the same time that the CREATE USER statement is executed. 

The password can also be changed using a MODIFY USER command.

First time IIS User Setup - DataStage 8.7

Typical users list:

• wasadmin
• isadmin
• db2inst1,db2iadm1
• db2fenc1,db2fadm1
• dasusr1,dasadm1
• xmeta,xmeta (db owner)
• xmetasr (staging area)
• iauser,iadb (db user)
• dsadm,dstage

How to save User Name in Putty Sessions

1. Clicked on Any Saved Session and Load it 
2. Click Connection > Data in the Category navigation tree.

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:

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

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:

DataStage Error: Job xxx is being accessed by another user

DataStage Error:  Job xxx is being accessed by another user  

Take below steps to get rid of locks in datastage --

• In web console check active sessions and if job is listed disconnect session.
  
  To view all active sessions:
  
  In the Web console, click the Administration tab.
  In the Navigation pane, select Session Management > Active Sessions
  

IBM InfoSphere DataStage Roles

Suite component roles

DataStage and QualityStage Administrator

Can perform the following tasks: 

·         Assign project roles to InfoSphere DataStage suite users in the InfoSphere DataStage Administrator client

·         Use the Administrator client to create, delete, and configure projects

·         Mark projects as protected

Create Users and Groups for IBM Information Server[DataStage]

To create users and groups for IBM Information Server:

1.      On the computer where you installed the clients, log in to the Web console, which is on the computer where the domain is installed.

o        Windows: Click Start > IBM Information Server > IBM Information Server Web Console and log in to the console with your suite administrator credentials.

o        Linux or UNIX: Open Microsoft Internet Explorer on a Windows computer and go to the URL of the Web console. Log in to the Web console with your suite administrator credentials. The URL takes the form http://host_server:port. host_server is the name or IP address of the computer where the domain is installed. port is the port number for the Web console. The default port number is 9080.