Scribd Logo
Upload

Welcome to Scribd!

  • 505 views

    DSSharing - Datastage Admin Commands

    Uploaded by

    Karen Macias
    The document provides a list of DataStage administrator commands and their descriptions to help find information like job and object counts, list jobs in a project, clear logs, find jobs using a hashed file as input or output, view and insert data into hashed files, and more. The commands can be used to manage and troubleshoot DataStage projects and jobs.

    Copyright:

    Attribution Non-Commercial (BY-NC)
    Download as PDF, TXT or read online from Scribd

    DSSharing - Datastage Admin Commands

    Uploaded by

    Karen Macias
    505 views3 pages
    The document provides a list of DataStage administrator commands and their descriptions to help find information like job and object counts, list jobs in a project, clear logs, find jobs using a hashed file as input or output, view and insert data into hashed files, and more. The commands can be used to manage and troubleshoot DataStage projects and jobs.

    Original Title

    DSSharing_ Datastage Admin Commands

    Copyright

    © Attribution Non-Commercial (BY-NC)

    Available Formats

    PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    The document provides a list of DataStage administrator commands and their descriptions to help find information like job and object counts, list jobs in a project, clear logs, find jobs using a hashed file as input or output, view and insert data into hashed files, and more. The commands can be used to manage and troubleshoot DataStage projects and jobs.

    Copyright:

    Attribution Non-Commercial (BY-NC)
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    505 views3 pages

    DSSharing - Datastage Admin Commands

    Uploaded by

    Karen Macias
    The document provides a list of DataStage administrator commands and their descriptions to help find information like job and object counts, list jobs in a project, clear logs, find jobs using a hashed file as input or output, view and insert data into hashed files, and more. The commands can be used to manage and troubleshoot DataStage projects and jobs.

    Copyright:

    Attribution Non-Commercial (BY-NC)
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    of 3

    9/29/13

    Share 0

    DSSharing: Datastage Admin Commands


    More Next Blog Create Blog

    DSSharing
    Monday, 28 January 2013

    Datastage Admin Commands


    Using DataStage Administrator commands to find:

    Command Description
    DS Proj ect Obj ect counts

    Command
    SELECT COUNT(*) FROM DS_JOBS; SELECT COUNT(*) FROM DS_JOBOBJECTS;

    Total Pageviews
    List all j obs in a DS proj ect SELECT JOBNO, @ID, CATEGORY, NAME FROM DS_JOBS

    3 6 7 6
    About Me

    Clear Log From Administrator

    select JOBNO from DS_JOBS w here NAME='Name of the j ob' CLEAR.FILE RT_Logxx w here xx is JOBNO.

    CLEAR HASH FILE.

    CLEAR.FILE <HASHED FILE NAME>

    prasoon

    select DS_JOBS.NAME AS JOB_NAME FMT '35L' from DS_JOBOBJECTS,DS_JOBS w here Find how many Jobs are using giv en Hashed file as INPUT DS_JOBOBJECTS.OLETYPE = 'CHashedInput' and DS_JOBOBJECTS.OBJIDNO = DS_JOBS.JOBNO and EVAL DS_JOBOBJECTS."@RECORD<6>" = 'hashed file name' group by JOB_NAME;

    Hi Guys, Welcome to DSShare blog.My na is Prasoon and i have created this blog to s datastage concepts.I will appriciated your comments on posts. View my complete profile

    select DS_JOBS.NAME AS JOB_NAME FMT '35L' from DS_JOBOBJECTS,DS_JOBS w here Find how many Jobs are using giv en Hashed file as OUTPU DS_JOBOBJECTS.OLETYPE = 'CHashedOutput' and DS_JOBOBJECTS.OBJIDNO = DS_JOBS.JOBNO and EVAL DS_JOBOBJECTS."@RECORD<6>" = 'hashed file name' group by JOB_NAME;

    CNET News.co Feed Technolo News

    select DS_JOBS.NAME AS JOB_NAME FMT '35L' from DS_JOBOBJECTS, DS_JOBS w here Find how many Jobs are using giv en Hashed file as INPUT and OUTPUT DS_JOBOBJECTS.OLETYPE in ('CHashedOutput','CHashedInput') and DS_JOBOBJECTS.OBJIDNO = DS_JOBS.JOBNO and EVAL DS_JOBOBJECTS."@RECORD<6>" = 'Hashed file name' group by JOB_NAME;

    View column data in a hashed file

    SELECT COLUMN_NAME FROM HASHED_FILE_NAME

    Free Backlinks

    List metadata of hashfile

    SELECT "FIELD", "FIELD.TYPE", "FIELD.DEF", "FIELD.CONV", "FIELD.HEAD", "FIELD.FMT", "FIELD.ASSOC" FROM DICT hashedfile ORDER BY "FIELD.NO", "TYPE";

    Insert data into the hashfile

    INSERT INTO HASHED_FILE_NAME (COLUMN_NAME) VALUES ('VALUE');

    Find w hich user modified the j ob last

    SELECT INSTANCE, DTM, MODIFIER FROM DS_AUDIT WHERE CLASS = '2' AND INSTANCE LIKE 'JOB NAME';

    List all the proj ects in DataStage.. With Ow ner

    SELECT @ID, NAME FMT '40L' FROM UV.ACCOUNT;

    CNET News How the 'carstache' turned into marketing magic for Lyft Author pleads: Please don't buy my new novel on Amazon (Q&A) Bad Beats: Why was the original

    Reset surrogate key generated using Keymgmt function in Datastage

    UPDATE SDKSequences USING DICT VOC SET F1 = '1' WHERE @ID = 'Your_Sequence_Name';

    List all the surrogate key v ariables used in datastage proj

    SELECT * FROM SDKSequences;

    Apple Google Microsoft

    List Datastage error message decsription, giv en error me

    SELECT * FROM SYS.MESSAGE WHERE @ID = '081002';

    SELECT DS_JOBS.NAME AS JOB_NAME, DS_JOBS.CATEGORY, DS_JOBOBJECTS.NAME AS

    Is Cupertino sacrificing its core to Los Angeles Times By the time Apple plops a campus the size the Pentagon into this city of 60,000 people Cupertino, Calif., will be more economically dependent on one company than any other

    dsshar.blogspot.com/2013/01/datastage-admin-commands_28.html

    1/3

    9/29/13
    List all j obs using a TABLE

    DSSharing: Datastage Admin Commands


    OBJECT_NAME, DS_JOBOBJECTS.OLETYPE, EVAL DS_JOBOBJECTS."if index(upcase(@RECORD),'TABLE_NAME',1) > 0 then 'FOUND' else ''" AS FOUND FMT '5L' FROM DS_JOBS, DS_JOBOBJECTS WHERE DS_JOBS.JOBNO = DS_JOBOBJECTS.OBJIDNO and FOUND = 'FOUND' GROUP BY JOB_NAME, DS_JOBS.CATEGORY, OBJECT_NAME, DS_JOBOBJECTS.OLETYPE, FOUND;

    Silicon Valley town. Two years after the pro was announced, as the ...

    List Sequencer j obs calling a specified j ob in the proj ect

    @DsServ e >> /etl/Ascential/Datastage/DSEngine/bin/dssearch -lj obs -usedby -r -oc oj <projectname> <jobname> @DsServ e >> /etl/Ascential/Datastage/DSEngine/bin/dssearch -lj obs -uses -r -oc -oj <projectname> <SeqJobname>

    Two Things Apple Got Absolutely Right In T iPhone 5s and iOS 7 Forbes We've certainly had our fun around here wit Apple's Apple's recent product announceme noting, for example that iOS7 seems to trig motion sickness in that small portion of the population susceptible to it. Others have noticed that the iPhone 5c ... Related Articles

    List all j obs called in specified Sequencer j ob

    Posted by prasoon at 06:30 Location: Cape Town, South Africa

    Recommend this on Google

    1 comment:
    Vamsi Krishna 12 February 2013 08:32 Your post is very nice.DO u have any link or material to know complete information about DS_JOBS,DS_JOBOBJECTS,DS_AUDIT etc.As of now i know basic knowledge with the help of dsexchange Reply

    Apple isn't dead yet iPhone 5S and iOS7 The haveGuardian a secret weapon When Steve Jobs was still with us, many commentators yours truly included use complain about the "reality distortion field" surrounded Apple's charismatic leader. Tho in attendance when Jobs launched the devi and services (iPod ... Related Articles

    Apple hires top designer from Nike tuaw.com At Nike, Shaffer was the Studio Director of Innovation Kitchen. This is Nike's research development lab where new product design created. Under Shaffer's lead, Nike was nam the most innovative company in 2013 by Fa Company. Related Articles
    pow ered by

    Enter your comment...

    Comment as:

    Google Account

    Publish

    Preview

    dsshar.blogspot.com/2013/01/datastage-admin-commands_28.html

    2/3

    9/29/13

    DSSharing: Datastage Admin Commands

    Newer Post

    Home
    Subscribe to: Post Comments (Atom)

    Older Post

    Powered by Blogger.

    dsshar.blogspot.com/2013/01/datastage-admin-commands_28.html

    3/3

    You might also like