DSXchange

Thank you for the reply guys.

There are some issues with the hard disk somehow as we found out this when tried to run Disk Error Checking. After scan disk and let windows fixes the issue itself, the problem seems to be gone.

Much appreciated for your help and ideas.

Chulett, Thanks for your response. This dataset was created successfully last week and we continued using it as the source data without any issue. However, once we tried to read this file again on Monday, we got this error. We logged this with support already and waiting for them to investigate. Ant...

Got below error while trying to read input datasets. It seems like somehow the input dataset was crashed. Internal Error: (blockSizeActual >= v4BlockHeader::size ()): datamgr/partition.C: 474 Also, we get the error message while trying to view this dataset from Data Set Management: Unknown error rea...

Hi Ray, Thank you for the quick reply. For the topic 'Strip out all the character', I actually mean to remove all the alphabetic character from the input string. Having done more search from your clue on using Convert(), I can find other topic discussing about this. I have tried below solution form ...

Hi guys,

Is there anyway to strip out all the character from the input string in PX job? Below is the sample of input and expected output:

input output
abx123 123
x345sdf 345
x3c5b4 354

Thanks in advance for your help.

Hi Ray, Thank you for prompt response. Is there any way to attach the new Parameter Set that create manually to the Data Connection? There is only 3 options available in Associated Parameter Set section in Data Connection. 1. Create&Attache - This allows new parameter set to create and attach to...

Hi Guys, I have a problem on how to configure the parameter set using environment variable. As in the server job, we can create the list of environment variable such as database connection details as pass them to the job from the batch sequence. However, in PX, for the job using parameter set, there...

Hi Guys,

Thank all for the answer.

Cheers,

Hi guys, Does anybody know where the job reports are saved in the unix server? As in DS v8, when generating job reports, they will be saved in the server. I tried to connect to reporting consoles, but could not figure out how to find the relative path in the unix where the reports have been saved. T...

Hi Chulette,

Thank you for helping me investigate.

I try to bring the .odbc.ini backup file back and add the new ODBC connection one by one, and it seems working fine now.

I believe it should be some invalid character in corrupted .odbc.ini file.

Cheers,

Hi Chulett, The file is there in /opt2/IBM/InformationServer/Server/branded_odbc/lib. -rwxr-xr-x 1 bfsdsad bfsdstage 614946 Sep 5 09:54 VMmsss23.so The file IVVM.LIC also exists in /opt2/IBM/InformationServer/Server/branded_odbc. -rwxrwxr-x 1 bfsdsad bfsdstage 2096 Sep 5 09:54 IVVM.LIC Cheers

Hi Guys, Today, this error comes up when I try to connect to SQL Server via an ODBC. This connection used to work before, however, when I try to connect today, it just doesn't work. Here is the entry in .odbc.ini. [MARS_298] Driver=/opt2/IBM/InformationServer/Server/branded_odbc/lib/VMmsss23.so Desc...

Hi,

I think first of all you should try to seperate the insert and update to different stream. For insert process, try to use DB2 Loader utility to load data instead of normal insert function.

With this design, it should improve your job performance.

Cheers,

Hi Guys, Having generated the job report as HTML using DataStage functionality, I found that the result in Full Job Description is automatically wrap-up to be one line message instead of proper format which we define the job. I try to insert HTML line break <br> option in the full description; howev...

Hi Admins, Since the forum is getting bigger and bigger everyday, would it be possible to add more filter on the forum to filter out more detail such as which OS or DS version that we want to search in? As gurus encourage people to use Search functionality, and I am one of the seachmaniac, I think i...