DSXchange

Hi All, We currently have two versions of IIS 8.1 and 11.5. While 8.1 is on the verge of decommissioning. We would like to uninstall Information Analyzer only from both the versions. Any pointers or guide for step by step process? Tried looking at IBM documentation, but could not find anything in de...

Hi All,
I think we have managed to find the issue. The NLS setting once we login to datastage administrator was different in dev compared to prod. So once we made it similar job worked fine

Change was done from UTF8-CS to MS1255-CS (this one looks a default)

Thanks
Sachin

Hi Ernie, This is how string it looks in notepad++ http://i63.tinypic.com/2lks8lj.jpg Oracle database it looks like as below http://i65.tinypic.com/1gma6f.jpg If I convert the string to hex in text editor it looks like http://i63.tinypic.com/mu9zz7.jpg Yes it is moving from Oracle to Netezza via Dat...

Thanks Ernie ! Got the point. I am able to parse this one now. I was using eventid as "repetition key" as I have multiple events within custmoer chat and within events again multiple items are there. But I guess I will have to use item as key in some case and event in some case. Exploring ...

Hi All, I have been trying to parse an xml using a parallel job with following job design. We are v9.1 row gen (holds value of seq file having only single column which is xml) ---> xmlimput ----> seq file I am trying to parse only single tag (newParty) from xml for which xsd looks like as below <xs:...

Thank you Andy and Craig for your replies. We have started investigating from db2 tables perspective in terms of counts etc. and I have below information Table1 Table2 Record count 7595154159 13564905740 daily avg load volume 50-70 million 10-20 million Time taken 20-30 mins 100 mins plus load metho...

Thank you Andy for reply. 1. Record size is as below. Nothing indicating a big record size Field 1 - integer Field 2 - varchar(250) Field 3 - date Field 4 - time Field 5 - timestamp Field 6 - integer Field 7 - integer Field 8 - integer Field 9 - timestamp Field 10 -char(1) 2. Target table count is s...

Hi All,
Any pointers to the above issue will be much appreciated.

Additional information on this job - RCP enabled for this one

Happy to provide additional information required

Hi, We have a multi-instance Db2 bulk loading job which reads a dataset and loads data to Db2 target via DB2 connector stage. No other stages involved in job except these two Other details as below - Approximate volume it handles is around 13 to 15 million records - Time consumed normally - 1 hr 30 ...

Hi All, We have a DS project running on v9.1 and with below configuration file { node "node1" { fastname "server1" pools "" resource disk "/data/Dataset" {pools ""} resource scratchdisk "/data/Temp" {pools ""} } } Currently both r...

Hi Guys, Looks like we have got the root cause for this issue. We have a SFTP script scheduled in crontab which polls for files 24/7 and it uses internally "at command". It looks like we had failure of at daemon and due to this there was huge list of pending processes. Every day it was add...

Hi Guys,
Thanks for your responses so far. We had a look at HA_STATUS as well and did not find anything there except a single old file. That was deleted too ! Directories under projects directory also looks good in terms of group permissions etc

Still talking to service provider as well.

Hi, we are not able to rename also. Just noticed below error while doing so after the process hung. Rename/Delete/Import all does not work IBM.DataStage.RepositoryAccess.ReposAccessException: Error opening file EDW_JPR_DWM_PRODUCT_DIM Talking to official service provider as well. But havent got any ...

Hi, We are not able to delete a job that is causing the problem from designer/director. That process also hungs up. And I missed out in earlier post that we have already rebooted DSengine, and WAS on services tier as well. One more observation is that on services tier we did notice similar expection...

Hi, We are on v9.1.2 and trying to import few jobs after version control in pre-prod environment. Issue is that whenever we import pre-existing job, process hangs at window "clearing job". Nothing happens after that and I need to close the session through task manager. If I try to delete j...