Database Content Definitions

A lot of scripts ans example to extract information from Control-M tools.
Post Reply
User avatar
DocGoo
Nouveau
Nouveau
Posts: 73
Joined: 08 Sep 2010 12:00

Database Content Definitions

Post by DocGoo » 20 Jun 2013 5:23

I am looking for a breakdown of 3 fields in the CM database. So far I have

----------------------------------------------------------------------------------
STATUS
Y = OK
N = NOTOK

STATE
4 = RUNNING
1 = WAIT CONFIRM

AJFSONSTR
1st Position = Y = INPUT CONDITION
N = NO INPUT CONDITION
2nd Position = Y = YES OUT CONDITION
5th Position = Y = YES AUTOEDIT VARS
8th Position = STEPS ???

14th Position = NO SUBMIT TIME ??
----------------------------------------------------------------------------------

If anyone has more information please let me know. BMC will not help on this one.

Thank you -Goo

User avatar
gglau
Nouveau
Nouveau
Posts: 317
Joined: 13 Jun 2007 12:00

Post by gglau » 20 Jun 2013 6:28

KB article SLN000000165194 has the following lists. The article was published in 2003 for up to v6.4.01. It will be good to know what is in AJFSONSTR.

=============================
All the valid states used CONTROL-M/Server can be found below. Be aware that state definitions may change without notice. Use of these states are for reference only.

0 Wait for Scheduling Criteria to be evaluated
1 Wait for Confirmation from user
2 Submitted to Agent
3 Not submitted to Agent
4 Executing
5 Ended
6 Analyzed Post Processing Steps
7 Disappeared
8 Post Processed
9 Not Found
A Waiting to Rerun
B Waiting for From Time
C Wait for In Condition
D Wait for Resource
E Wait for Submission
F Not used by CONTROL-M/Server
G Retry Submission to Agent
H Wait for Group Scheduling
I Failed To Submit
J Job waiting for Odate
K Job is past its Odate
Z Agent Status is Unknown

STATUS Y means that the job has completed successfully. N means that he has not completed or it has completed unsuccessfully.

HOLDFLAG determines if the job is on hold. Possible values are:
N not on hold
Y on hold
D Job was deleted.

User avatar
DocGoo
Nouveau
Nouveau
Posts: 73
Joined: 08 Sep 2010 12:00

Post by DocGoo » 20 Jun 2013 7:56

Thank you, it would be nice to know ajfsonstr also.

It appears that ajfsonstr is a series of Y and N switches. They appear to be indicators to the job. I got the above position indicators by trial and error. I guess thats what we will have to do.

Lets see if anyone else has any answers.

Thank you --Goo

User avatar
DocGoo
Nouveau
Nouveau
Posts: 73
Joined: 08 Sep 2010 12:00

Post by DocGoo » 20 Jun 2013 11:07

Here is what I have so far.

AJFSONSTR
1st Position = INPUT CONDITION EXIST
2nd Position = OUT CONDITION EXIST
5th Position = AUTOEDIT VARIABLES EXIST
6th Position = SYSOUT HANDLING
Y = COPY
N = NONE
7th Position = POST PROCESSING EXIST
8th Position = TASK TYPE
B = JOB
C = COMMAND
D = DETATCHED
9th
10th
11TH
12th
13TH
14th Position = DESCRIPTION
Y = EXIST
BLANK = NOT EXIST

User avatar
gglau
Nouveau
Nouveau
Posts: 317
Joined: 13 Jun 2007 12:00

Post by gglau » 21 Jun 2013 5:47

I did some modifications at active job to determine the meaning of the field.

1 IN condition
2 OUT condition
3 Control resource
4 Quantitative resource
5 AutoEdit variable
6 SYSOUT handling
7 Post Processing (Shout)
8 On-Do block
9 Do-Condition
10 Do-SetVar
11 Do-Notify
12 Do-Force
13 Do-SYSOUT
14 Active job modified

For each of positions 1 - 13, a 'Y' indicates the entity exists, otherwise an 'N'. For position 14, an 'N' indicates active job has been modified after order, otherwise a blank space.

The list is slightly different from yours. Do you find the same results?

User avatar
DocGoo
Nouveau
Nouveau
Posts: 73
Joined: 08 Sep 2010 12:00

Post by DocGoo » 21 Jun 2013 5:52

Very cool!!!

It looks very close, but I have to change channels now for awhile before I get back to this.

Thanks again,

-Goo

Post Reply