Sponsored Content
Full Discussion: HPUX-Datastage
Operating Systems HP-UX HPUX-Datastage Post 302748937 by roopeshvp on Thursday 27th of December 2012 05:46:22 AM
Old 12-27-2012
HPUX-Datastage

Hi All,
I am new to datastage just managing to modify packages with my prior knowledge in ETL tools like DTS and SSIS.
Now have ran in to a connectivity issue between datastage and unidata DB.
Software environment-
Datastage 7.5.2 running on windows server accessing unidata 7 on HP UX machine.

I am able to connect to my unidata DB on the PROD HP UX server.
But when i change the connection to the TEST HP UX server the connection fails with the error
'ds_udtopen()unable to execute file select 30105 UDT error'
'ds.udtopen GCI $udtopen error 24'
The user ID i use to connect has access to Unidata in HP UX TEST box and i can connect to it from my unix emulator. But it fails from datastage.
Can you pleas tell what could the possible problem, are there any configuration of this user account that i need to do between datastage and unidata?

Thanks in advance!!
Roopesh
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

dsjob command to execute DataStage jobs

Hi Friends, I am using a dsjob command in a unix script to invoke DataStage jobs. DataStage server jobs (version 7.5.2) The command looks like thisL: $DSBinPath/dsjob -server :$SERVER_PORTID -run -mode NORMAL -jobstatus -param INPUT_GCDB_DIR=$InputFilePath -param... (0 Replies)
Discussion started by: sureshg_sampat
0 Replies

2. UNIX for Advanced & Expert Users

invoke windows datastage dsjob from unix

hello, i have a windows server with datastage. In another machine, unix machine, i have a shell script that need to invoke the datastage dsjob. Can anyone help me? (0 Replies)
Discussion started by: anaconga
0 Replies

3. Shell Programming and Scripting

can we use routines of datastage in unix script

Hi all, My aim is to get the log details of datastage job using unix scipt. we know that DSjob are used to get the log details from datastage universe through the adminstrator.can we call that DSjob rountine in our unix script. Thanks in advance Regards, NimmyRaju:) (0 Replies)
Discussion started by: nimmyraju
0 Replies

4. Shell Programming and Scripting

Need Script to Use CPUs on a HPUX server to simulate Workload Manager on HPUX.

I am running HPUX and using WLM (workload manager). I want to write a script to fork CPUs to basically take CPUs from other servers to show that the communication is working and CPU licensing is working. Basically, I want to build a script that will use up CPU on a server. Any ideas? (2 Replies)
Discussion started by: cpolikowsky
2 Replies

5. UNIX and Linux Applications

Datastage TX

hi,does anybody familiar with datastage tx.? added your particular question: I have to modify a map to drop a timestamp from the filename variable and pass that value down to the transform/validation maps. thanks,, Edit/Delete Message (1 Reply)
Discussion started by: sonja
1 Replies

6. HP-UX

pwage-hpux-T for Trusted HPUX servers

I'm sharing this in case anybody needs it. Modified from the original solaris pwage script. This modified hpux script will check /etc/password file on hpux trusted systems search /tcb and grep the required u_succhg field. Calculate days to expiry and notify users via email. original solaris... (2 Replies)
Discussion started by: sparcguy
2 Replies

7. Shell Programming and Scripting

passing parameters from a script to a datastage job

We have a requirement as follows. We have created a datastage job that will be doing the select operation from table (select query from a table). The datastage job is being invoked by a unix shell script(ksh). We are passing the "table name (STUD_DETAILS)" and a "where clause condition... (4 Replies)
Discussion started by: kmanivan82
4 Replies

8. UNIX for Advanced & Expert Users

Datastage Installation Problem

HI, I am trying to install IBM infosphere Datastage on my machine. which is # uname -a Linux "hostname" 2.6.18-238.el5 #1 SMP Sun Dec 19 14:22:44 EST 2010 x86_64 x86_64 x86_64 GNU/Linux AS per the IBM DOC, we need to install the WAS (Websphere Administration Server ) and then proceed... (4 Replies)
Discussion started by: amarn48
4 Replies

9. AIX

Which tool is best tfor practicing Datastage?

I am new to unix. I started learning unix. Where can we practice unix commands. Is there any free online tools are available? or Is there any free software ? (14 Replies)
Discussion started by: lucky20
14 Replies

10. UNIX for Beginners Questions & Answers

How to compile a Datastage Job using Execute Command Stage or Routines in Datastage 11?

I am trying to compile the datastage jobs using the Execute Command stage in datastage 11 or any Routines if possible. My datastage is on Unix machine. So, How can I Compile a datastage job in UNIX from command line or any Routines. Please help me in doing so. Thank you. (1 Reply)
Discussion started by: elena jessi
1 Replies
dtscp(1m)																 dtscp(1m)

NAME
dtscp - DTS control program SYNOPSIS
dtscp NOTES
With the exception of the following subcommands, this command is replaced at Revision 1.1 by the dcecp command. This command may be fully replaced by the dcecp command in a future release of DCE, and may no longer be supported at that time. exit help quit DESCRIPTION
This section describes the commands for the DCE Distributed Time Service (DTS) control program (dtscp). The DTS control program is a com- mand-line interface that enables you to synchronize, adjust, and maintain the system clocks in a distributed network. For a detailed expla- nation of system clock synchronization and management, see the OSF DCE Administration Guide. The DTS control program commands are The advertise command, which configures the DTS server as a global server The change command, which modifies the epoch and sets the local time to a new time The create command, which establishes a DTS entity (a clerk or server) The delete command, which causes DTS to exit on the local node The disable command, which suspends a DTS entity The enable command, which starts a DTS entity The exit command, which ends the dtscp management session and returns you to the system prompt The help command which invokes the dtscp help service. The quit command, which ends the dtscp management session and returns you to the system prompt The set command, which modifies characteristics of a DTS entity The show command, which displays characteristics of a DTS entity The synchronize command, which synchronizes the system clock with the time obtained from DTS servers in the network The unadvertise command, which removes the global server entry The update command, which gradually adjusts the system clock to a new time For more information on any of the above dtscp commands, see the appropriate reference page in this chapter. You can use control program commands from within the control program or from the system prompt. To enter DTS commands from within the con- trol program, first start the control program by entering the dtscp command. For example: $ dtscp dtscp> At this prompt you can enter any control program command; for example: dtscp> show current time To leave the control program and return to the system prompt, enter the exit command. To enter DTS commands from the system prompt (interactively or in a command procedure) enter the dtscp command with an internal command of the control program as the first argument. The control program executes the command without displaying the control program prompt. For example, you can enter the synchronize command as follows: $ dtscp synchronize Some dtscp commands have optional arguments or attributes; there may also be optional variables for the arguments and attributes. See the following sample command: dtscp> update time 1990-08-03-05:45:28.000+01:00I00.500 / / / Command [Argument] Variable -------- [Attribute] Abbreviations You can enter as few as three characters for each DTS command or argument; DTS commands and arguments are unique for three characters or more. For example, rather than entering the command enable set clock true, you can enter the following abbreviated command: dtscp> ena set clo tru Attributes The dtscp set and show commands have several attributes--pieces or sets of data associated with them. The attribute groups are categorized as follows: Set or show the entity's operation. Show the number of occurrences of an event since the entity was enabled. Show the current state of the entity. (The DTS entity has four status attributes.) Show the global servers known by this DTS entity. Show the local servers known by this DTS entity. Individual attributes within each of the previously listed groups are described in the reference pages for the set and show commands. The show command also allows you to specify attribute groups. Time Stamps All responses to commands contain a timestamp. The following example shows a typical DTS time display: 1993-03-16-14:29:47.52000-05:00I000.003 The timestamp uses the DTS format that is explained in Chapter 15 of the OSF DCE Administration Guide--Core Components. In this example, the year is 1993, the day is March 16, and the time is 14 hours, 29 minutes, and 47.52 seconds. A negative Time Differential Factor (TDF) of 5 hours and an inaccuracy of 3 milliseconds are included in the timestamp. An inaccuracy value of I----- indicates an infinite inaccu- racy. This value appears in time displays before a node's initial synchronization or after you enter the change command without specifying an inaccuracy value. RELATED INFORMATION
Commands: advertise, change, create, delete, disable, enable, exit, help, set, show, synchronize, quit, unadvertise, update Books: OSF DCE Administration Guide dtscp(1m)
All times are GMT -4. The time now is 01:26 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy