DSXchange

copying the whole filesystem.
no new names or directories. dismounting old, mounting new.
I don't see anything sensitive to devices.

any suggestions?

uvsh works just fine.
why do you think a cp -p by root would not work? Datastage is not sensitive to devices...

Ande

moving from one data device to another, Datastage was brought down, the /opt/dstage/Ascential filesystem was copied -p by root to the new device. now cannot log into any client, including admin, by any id, including dsadm. can start and stop the server using /bin/uv; can get into universe using uvsh...

a misguided attempt to remove user permissions in DB2, resulted in a major mess. Remaining is the referenced problem. They returned execute and bind to dsadm and I reran the bind to db2 successfully. I can access the database (designer view) with no problem as dsadm. Users get the referenced error. ...

I'm having the same problem and wondering what the problem is. My LIBPATH: /.dslibs:/opt/dstage/Ascential/DataStage/branded_odbc/lib:/opt/dstage/Ascential/DataStage/DSEngine/lib:/opt/dstage/Ascential/DataStage/DSEngine/uvdlls:/opt/dstage/Ascential/DataStage/DSEngine/java/jre/bin/classic:/opt/dstage/...

very often a permissions problem can occur if the file delivery or processing has changed or someone has modified a umask.
Since loads are done under the dba's id, not the user's, make sure the group and other permissions are read on the file being loaded.

Ande

I am able stop and start the server wiith the following commands. (it asks for dsadm password) $DSHOME/bin/uv -admin -stop $DSHOME/bin/uv -admin -start I don't think it should ask you for password. Try to start the engine while loged in as root. We have similar problems as you (something missconfig...

well, if all you have on DB2 is some example data, you're fine. Now if you really have a partitioned db2 database, your path is wrong an pointing to the wrong set of db2 libraries and sqllib. Partition number 0 is usually used for the DB2 catalog. One partition does not make a partitioned database. ...

The db2nodes dataset is in the sqllib directory. Check your db2 path. The file will have the node, host, and partition number. The host, has to exactly match your specifications of fastname. Some files have more that one name specified and that's okay, as long qs you have a fastname matching that sp...

Also make sure the server host names in the db2 nodes configuration files exactly match the host names in the datastage configuration file.

Ande

I think it all depends on what you're doing when the year matches.
You can use a lookup stage. You might be better off doing an outer join with the table(s).

Ande

okay; an 'educated' guess.
1. Check permissions to catalog tables
2. Verify configuration file has all the nodes of the database defined.

It looks like confusion over the node definitions and descriptions.
Do other jobs against these table(s) run clean?

You might have to resort to writing the file out to a temporary space and then reading it back in, keeping the grouping information that you desire. We've done some of this using external routines, so DataStage doesn't even see the writing and reading. The problem, as I see it, doing this in DataSta...

Sounds like you're moving less than the number of characters defined into a character field. If a character column is say, 10 characters, and you move 5 characters into that field, what would you expect to be in the rest of the field? Probably your default fill character, usually a null '\0' or blan...

well, you know as well as I do (or probably better, if you are Brian) that C is intregal to C++.
We use both plain C and C++ contrruction in our external routines.