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

Read more »

Selecting DataStage job log results in error: Error Selecting from log file RT_LOG

When trying to view a job log in DataStage Director, an error similar to the following is received:

Error selecting from log file RT_LOGnn
Command was: SSELECT RT_LOGnn WITH @ID LIKE '1NON' COUNT.SU
Error was: Internal data error. File <path_to>/RT_LOGnn/<filename>':
Computed blink of 0xnnnn does not match expected blink of 0xnnnn! Detected within group starting at address 0xnnnnnn!
The error message received indicates that the log file for the job is corrupted.

Read more »

Oracle Interview Questions - Part-1

1. What are the components of physical database structure of Oracle database?
Oracle database is comprised of three types of files. One or more datafiles, two or more redo log files, and one or more control files.

2. What are the components of logical database structure of Oracle database?
There are tablespaces and database’s schema objects.

3. What is a tablespace?
A database is divided into Logical Storage Unit called tablespaces. A tablespace is used to grouped related logical structures together.

Read more »

Delete All PuTTY Sessions Together

When you are swapping an old computer with a new computer, you may end-up transferring all PuTTY sessions to new computer. Once you’ve transferred all PuTTY sessions, execute “putty -cleanup” from the command line as shown below.

Read more »

Execute an SQL script file in SQLPlus - Oracle

To execute a script file in SQLPlus, type @ and then the file name.

SQL > @{file}

For example, if your file was called script.sql, you'd type the following command at the SQL prompt:

SQL > @script.sql

The above command assumes that the file is in the current directory. ( the current directory is usually the directory that you were located in before you launched SQLPlus.)

Read more »

DataStage-Director: Unable to open DICT 'RT_LOG###'

When attempting to open a job log in Director, user gets the following error message: Error selecting from log file RT_LOG### Error was: Unable to open DICT 'RT_LOG###'. This is because the D_RT_LOG file is missing from the projects directory.

Read more »

MQ queue naming standards

The naming of the WebSphere MQ queues is an important part of Q replication setup. It may be that your site already has a naming standard for MQ queues, but if it does not, then here are some thoughts on the subject.

Queues are related to Q Capture and Q Apply programs, so it would be useful to have that fact reflected in the name of the queues.

Read more »

Putty Sessions Time Out due to Inactivity

The ssh client PuTTY can be configured to maintain a connection and not time out due to inactivity.

 

To set up a new connection with "keep alives" to maintain your connection follow the steps below:

1. Open the PuTTy application and navigate to the Options panel.
2. Select Connection
3. In the field Sending null packets to keep session active change the default value from 0 to 1800 (30 minutes)

Read more »