Problems importing PxDB2 stage type
Posted: Thu Sep 18, 2008 5:27 am
Got a problem importing a stage type, the PxDB2.
I discovered that the PxDB2 stage in a production project on a production server has extra options when compared to my dev project on the dev server.
It looks like a patch was applied to production, but not dev. I've located the patch that delivered the enhanced PxDB2 stage.
However, if I try to add the patch to the dev project, I'm having trouble
Following the instructions, I import a new PxDB2 stage type from the supplied dsx file.
After importing the new PxDB2 stage type to my dev project I checked the properties of the Stage type and i can see the additional options, as expected.
However if I add the stage to to a parallel job the properties of the stage are all wrong. The stage doesn't appear with the right properties defaulted, what should be mutually exclusive options appear together, most of the expected properties are missing and so it's a bit of a mess!
If I then re-import the backup of the PxDB2 file, to the dev project, everything is ok again (except I'm back to a version of PxDB2 that's different from the production one).
To add to the mix the project I'm importing into is a USS project, so the PxDB2 stage is supposed to have some "special" properties, only applicable to USS.
There is obviously something I'm missing! I'm assuming I can import a stage type to an individual project without importing to all projects on the same server?
I haven't stop/started DataStage since the patch instructions don't mention that. Is that a red herring anyway?
Anyone got any pointers?
Thanks!
I discovered that the PxDB2 stage in a production project on a production server has extra options when compared to my dev project on the dev server.
It looks like a patch was applied to production, but not dev. I've located the patch that delivered the enhanced PxDB2 stage.
However, if I try to add the patch to the dev project, I'm having trouble
![Confused :?](./images/smilies/icon_confused.gif)
Following the instructions, I import a new PxDB2 stage type from the supplied dsx file.
After importing the new PxDB2 stage type to my dev project I checked the properties of the Stage type and i can see the additional options, as expected.
However if I add the stage to to a parallel job the properties of the stage are all wrong. The stage doesn't appear with the right properties defaulted, what should be mutually exclusive options appear together, most of the expected properties are missing and so it's a bit of a mess!
If I then re-import the backup of the PxDB2 file, to the dev project, everything is ok again (except I'm back to a version of PxDB2 that's different from the production one).
To add to the mix the project I'm importing into is a USS project, so the PxDB2 stage is supposed to have some "special" properties, only applicable to USS.
There is obviously something I'm missing! I'm assuming I can import a stage type to an individual project without importing to all projects on the same server?
I haven't stop/started DataStage since the patch instructions don't mention that. Is that a red herring anyway?
Anyone got any pointers?
![Rolling Eyes :roll:](./images/smilies/icon_rolleyes.gif)