Orchadmin Command for Deleting Dataset file from server:

Orchadmin is a command line utility provided by datastage to research on data sets.

Using this command, you can view,copy,delete,modify the dataset through Command.

Resolving problems logging in to the WebSphere Application Server administrative console

Symptoms
You cannot log in to the WebSphere Application Server administrative console of an WebSphere Application Server installation that is running InfoSphere Information Server.

Causes
There are multiple reasons why the login fails.

Environment
This advice applies to all environments that are supported by InfoSphere Information Server.

Diagnosing the problem
Ensure that you are using the default IBM WebSphere Application Server administrator user name and password. If you are not sure of the WebSphere Application Server administrator user name, you can view the WebSphere Application Server security.xml file.

Attention: Do not modify this file.
The security.xml file is in the following directory:

Operating system Directory
Linux /IBM/WebSphere/AppServer/profiles/profile_name/config/cells/cell
Windows \IBM\WebSphere\AppServer\profiles\profile_name\config\cells\cell

profile_name is the name of the WebSphere Application Server profile being used (the default name is InfoSphere). cell is the name of the WebSphere Application Server cell.

The user name is specified by the serverId attribute in the userRegistries element of the active user registry. Ensure that you are looking at the serverId of the active user registry. To find the active user registry in the security.xml file, look for the activeUserRegistry string in the file. The file contains an entry that is similar to activeUserRegistry=UserRegistry, where the UserRegistry value depends on your configuration. Search the remainder of the security.xml file for this value, which determines the current active user registry. Ensure that you can access the registry. For example, if you are using an LDAP user registry, ensure that the LDAP server is running and that you can connect to it. If you are using the InfoSphere Information Server internal registry, ensure that the database server that is used by InfoSphere Information Server is running and that you can access it.

Resolving the problem
If the user name or password is invalid or unknown:

Change the password.

If your installation is configured to use the InfoSphere Information Server internal user registry, enter the following DirectoryAdmin command to change the password:
Operating system Command

Linux install_home/ASBServer/bin/DirectoryAdmin.sh -user -userid wasadmin_username -password wasadmin_password
Windows install_home\ASBServer\bin\DirectoryAdmin -user -userid wasadmin_username -password wasadmin_password

If your installation is configured to use an external user registry (such as a local operating system user registry or an LDAP user registry), use operating system or LDAP utilities to change the password. Enter the following AppServerAdmin command to update the WebSphere Application Server and InfoSphere Information Server configurations:
Operating system Command

Linux 
install_home/ASBServer/bin/AppServerAdmin.sh -was -user username -password password
Windows 
install_home\ASBServer\bin\AppServerAdmin -was -user username -password password

Wasadmin Password Change using security.xml file

    Wasadmin password changing options or Open websphere without prompting the password : If you forgot the password for websphere console or not able to stop services tire due to wasadmin password change. then you can follow, below option to rest your password.DK®

Datastage 11.5 Newly added features

Datastage 11.5 New features for IIS common components

This post will help you to understand the changes/enhancement made on IIS 11.5 for connectivity services, administration services, and deployment services to support its data integration and data governance capabilities. As part of IIS V11.5, the following common platform enhancements have been made.

DirectoryAdmin command for reset isadmin/wasadmin passwords

Reset isadmin/wasadmin passwords using DirectoryAdmin tool:

This post will help you to understand DirectoryAdmin tool in details . If you lost user password for default id’s (isadmin/wasadmin) and not able to login to InfoSphere Information Server (IIS) console or IBM WebSphere Application Server (WAS) Administrator console then follow below mentioned steps to reset your passwords.DK®

Passwords change for IBM Datastage default users on Windows

Change the passwords for IBM Datastage default users on Windows :  This post will help you to learn correct procedure to change the passwords for each of my IBM InfoSphere Information Server users (Db2admin,wasadmin, isadmin, xmeta, iadb).DK®

Datastage Version 11.3 job compatibility fixed

Datastage Version 11.3 job compatibility fixed : IBM DataStage version 11.3 introduce new features and functions that affect existing Version 9.1 or older version of the jobs. This post will help you to fix those issues in Datastage 11.3.DK®

BigData-Loading Data into Hive Table

BigData-Loading Data to Hive table concept:

Hive is designed to enable easy data summarization and ad-hoc analysis of large volumes of data It uses a query language called Hive-QL which is similar to SQL. 

COLLECT STATISTICS IN TERADATA

COLLECT STATISTICS IN TERADATA: This post will help you to understand collect stats importance in teradata database.DK®

Read multiple files using sequential file stage

How to read multiple files using single DataStage job? DK®

This article provides different ways of reading multiple files (having same or different metadata) using a single job.DK®