DSXchange

In short, doing a partial load from an existing table def and then saving back the new "definition" to Manager functions correctly. When queried in MetaStage, it produces "Where-Used" results that are accurate. I have not seen any issues with this process. As mentioned earlier, t...

My replies are specifically towards outputs/sequential files. Not Hash Files. A 2GB hash file seems fairly large. Can it be useful at that size in most cases? I think we shy away from hash files when they are excessively large.

-KJ

Kevin Janes

Ray, we ran into a situation where we were creating sequential output files that exceeded 2GB and the job would just blow up. Ascential Advanced Engineering has us change the 64BIT flag in uvconfig to fix the problem. It has worked without any problems ever since. We hammer on DataStaqe with over 50...

There is a parameter in the "uvconfig" file (filepath DataStage/DSEngine) that by default is set to 32 Bit even when installed on Unix/AIX. The parameter is 64BIT_FILES. Set it to 1 to exceed the 2GB limit. We ran into this same problem. Save the changes to uvconfig. Stop and restart your ...

A situation that does not present itself well to subscribed practices is when you may load a table layout (meta data) into a DataStage stage as a basis for that stage, but then alter it, using only what you need. For instance, say a table has 400 columns at the source level but you only need 100 of ...

There is a Compile All version for DataStage 6. Do not use the Compile All version for DataStage 5 if you are now using v6. It is not compatible. The people at http://www.datastageexchange.com would have more information. I am not sure if there is a cost or not. They are the same people that run/sup...

From a development perspective, DataStage v6 is not much different from v5 [:)]. Version 6 has some new features that have been mentioned in this forum but the foundation is the same. This is in regards to DataStage Server side jobs and even DataStage/390. As a general consideration, coding parallel...

I can tell you that DataStage on AIX flies. It utilizes multiple processors (SMP) and exploits hashing very well. I do not work for Ascential but can testify that DataStage is very scalable and can handle large volumes of data and complex ETL better than any environment I have seen in many years. Wi...

I read the same news items about 6 months ago and called the contact in the document and the product manager. Same answer. Just metadata for now.....

Kevin Janes

I read the same news items about 6 months ago and called the contact in the document and the product manager. Same answer. Just metadata for now.....

Kevin Janes

From what I have been told by Ascential, it currently only has to do with metadata. There doesn't appear to be any "integration" from an ETL perspective with DataStage yet.



Kevin Janes

There is a way to facilitate what you are talking about which is accessing mainframe DB2 from a server side job. If you have a DB2 Connect gateway on an AIX box for instance, that points to a mainframe instance of DB2, you can drop the DB2 stage into your server side design pallete and connect to ma...

I agree. You don't want to try and build relationships and query the base MetaStage tables. You would have to understand the data model and the relationships between the object classes and know how the keys of each table are related, etc... You would basically be re-creating metastage but in a relat...

Even with all of the metadata in MetaStage, you may be challenged to produce the report you are interested in because MetaStage is very much object class oriented. To do impact analysis, you have to choose a super class from which to query based on a metabroker (i.e. DataStage, ERWin, B.O., etc...)....

Barbara is correct. I have verified this during beta testing. We decided to take the leap to version 6 to eliminate any future incompatibility issues. As of this afternoon we will be fully upgraded to DataStage and MetaStage v6 in development and production. We did not run into any upgrade issues go...