DSXchange

On some databases you can disable and then enable indexes after the load which is faster than dropping and creating.

EtlStats has several ways to get row counts which may work on version 4. All the jobs that refer to DS_JOBOBJECTS would not work. I think the job which gets row counts from the log file should work with some modification for DS_JOBOBJECTS.

Look at this http://www.dsxchange.com/viewtopic.php? ... hgrp+chmod

Listen it is not our job to solve your problems. We can suggest certain solutions. If you do not want to take our suggestions then fine. Nobody answering these questions is getting paid to do so. We answer them to try and help. We all have our own reasons for answering these questions but I doubt if...

EtlStats has a job named DSJobReportDbDriver. It has a parameter called SeqName. If you put a category name in this parameter it will get all row count for the category. It will email you a report with these row count if you like. Most of the jobs in EtlStats will work for one job, all jobs called b...

One of the jobs in EtlStats will GetRowCountsFromLog but you can write it yourself if you want to.

Do not send me any private messages or email but a migration is no different than loading a data warehouse.

Version Control works the same. Making jobs perform is the same. The data structures look a little different.

I do not have an example but you should be able to use sqlplus to get the values into shell variables. The rest should be easy.

There are no documents about the repository tables. All the SQL I post that runs at TCL against repository tables can be used in a UV stage as a source and written to any table or file. Doing any of this in BASIC either in a routine or job control code takes a lot more knowledge of Universe. The har...

Arnd is correct localuv. You can also start with UV stage. UV stage will let you run SQL against hashed files that you create or part of the repository. You have to trick DataStage in order to import the table definitions. If you import UV table definitions then the repository ones are left out. You...

Download EtlStats from my tips page. It will get you most the way there. You still need a table which will has the table names for each link name because EtlStats has row counts by job name and link name. You may have to build that manually. Otherwise hack the repository or pay Ray or Ken how to do ...

I included this in EtlStats. It is called DsSearch1.sql. SELECT DS_JOBS.NAME AS JOB_NAME, DS_JOBS.CATEGORY, DS_JOBOBJECTS.NAME AS OBJECT_NAME, DS_JOBOBJECTS.OLETYPE, EVAL DS_JOBOBJECTS."if index(upcase(@RECORD),'PIPPO',1) > 0 then 'FOUND' else ''" AS FOUND FMT '5L' FROM DS_...

Nice blog. You get better everyday.

Someone probably did rebuld indexes in DS.TOOLS. If a user is connected then it will delete the indexes but not build them. It needs exclusive access to all repository tables like DS_JOBS in order to build the indexes. Try DS.TOOLS again with all th users out of Designer, Director and Manager.