DSXchange

On a DataStage Windows platform, a team memeber recently developed two jobs 1) Extracts xml files and via XML Hierarchical Data stage load into into a SQL server table where one of the target colums is defined as datatype XML in SQL Server (write from Datastage as SQL type LongNVarChar) 2) Read data...

As I said it was first time I had come across it in my long IT career. Speaking to an IT friend, they said it is most likely it comes from source where software generated the column name rather the column names being coded. I am surprised more DSXchange members have not come across the situation - i...

This is the first time I have dealt with database columns that are prefixed with number. SQL Server table CREATE TABLE [dbo].[Test_Table2]( [Col1] [varchar](30) NULL, [123Col2] [varchar](30) NULL ) ON [PRIMARY] Testing job Row Generator -> Copy -> ODBC In Test 1 I only passed Col1 through the copy s...

Thank you Mike and everyone else for your advice. You have pointed out my oversight. once I had decided on a multi server topology, that I would need consider a db2 client / db2 catalog / dsenv configuration if we wanted to use the DB2 connector stage, even if it was to access the installation repos...

Our source XML data has multiple records with each record having nested listed elements We are required to map all the listed elements fo a given record to a single output for each record Using the Hierarchical Data Stage we are limited to mapping 1 level. Is there a different approach we should be ...

Mike I can start a DB2 session on Server1 (Repository,Services)
Logon to Repository server as root
su - db2inst1

I cannot start a db2 session on the Server2. Have I made a mistake during the installation on teh two servers

Hi Mike Looks like we are on the right track now db2 list database directory works as expeted When I excute db2 list node directory I get "SQL1027N The node directory cannot be found" So from Server1 (Repository,services) I need to issue the db2 catalog commands db2 catalog database xmeta ...

DB2 connector will also use the catalog information. If you read the documentation that if DB2 client fails to connect to the server then DB2 Connector will also fail. Try to catalog xmeta on engine then try running the job again. Are you able to provide the detailed commands steps I will need to d...

I have installed 11.3.1.1 on Redhat with two server topology Server1 (Repository, services), Server2 (Engine). Default install repository db2 v10.5 The installation has been successfully, installation test jobs have run successfully. I now wish to create a test job with db2 as a source I have config...

It appears that the db2profile had not been run to set the environmental variables. once it had been run I was able to execute db2stop and db2start commands

I have just done a fresh install, installing DB2 10.5 by the installation program I have been able to access db2 and execute connect to xmeta and iadb I have been unable to execute db2stop command as db2inst1 - I get the error message SQL1092N authorization-ID does not have the authority to perform ...

I have a need to inport file definition sequential files that are stored on a shared network drive I have tried mapping the network drive, then tried to access the mapped drive in from Directory field on the import Meta data (Sequential) window ,but mapped drive is not displayed What is the correct ...

I have noticed that the JOBRUN.RunStartTimestamp, JOBRUN.RUNENDTIMESTAMP are behind by 11 hours. I have check the Linux time and Job log event time and they are correct and the same. I have checked the reference guide and can not see where the Time can be changed Any advice to advance the DSODB time...

I have
Database:dsodb
Username:dsodb

Unsure what the instance should be

Successful was from ./DSAppWatcher.sh -test This morning I was successful in testing the connection to xmeta Instance: db2inst1 DataBase:xmeta User: db2inst1 I am now trying to do a similar connection to dsodb, but can not seem to get the following combination correct to do a connection test via db2...