Designing a support model for DataStage

A forum for discussing DataStage<sup>®</sup> basics. If you're not sure where your question goes, start here.

Moderators: chulett, rschirm, roy

Post Reply
mloaiza
Participant
Posts: 2
Joined: Thu Mar 01, 2007 5:16 pm

Designing a support model for DataStage

Post by mloaiza »

I am preparing to release somo datastage jobs onto production environment. Prior to that I need to define a support model. Basically I know I must have different levels of support:

- Level 1 for issues that can be resolved by the Help Desk analyst
- Level 2 for issues that requiere a datastage analyst intervention
- Level 3 for new developments or changes

What I am trying to figure out is a list of activities or problems that corresponds to each level. For instance: a failed job must go to level 2, a requirement for a new interface must go to level 3, and so on.

There are not many things that come to my mind to design a support model that covers all the possible issues
DSguru2B
Charter Member
Charter Member
Posts: 6854
Joined: Wed Feb 09, 2005 3:44 pm
Location: Houston, TX

Post by DSguru2B »

Welcome Aboard,
Well I would say, for any error that does'nt require manual intervention falls in the first category. For any error that requires a DataStage analyst to review the error message and act would come under second category. Any enhancements to the code would come under third category. The third category usually requires flows through a process of change controls and format signoffs from business etc.
Creativity is allowing yourself to make mistakes. Art is knowing which ones to keep.
kcbland
Participant
Posts: 5208
Joined: Wed Jan 15, 2003 8:56 am
Location: Lutz, FL
Contact:

Post by kcbland »

You have lots of issues to classify here's just a few:
  • disk contention causing jobs to die
    out of disk space issues
    database availability
    unable to grow database table
    unable to grow database table index
    unable to insert row, primary key violation
    unable to insert row, null value supplied to non-nullable column
    too many warning messages in DS job
    unable to start job in time error
    job exceeds Abort After N Rows settting in job
    file not found
    file column definitions don't match physical file
    abnormal terminations
Kenneth Bland

Rank: Sempai
Belt: First degree black
Fight name: Captain Hook
Signature knockout: right upper cut followed by left hook
Signature submission: Crucifix combined with leg triangle
Post Reply