By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
437,610 Members | 1,672 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 437,610 IT Pros & Developers. It's quick & easy.

DSNTIJMS job in DB2 for z/OS

P: n/a
RdR
Hi,

I am trying to setup an ODBC / JDBC connection to my tables in DB2 for z/OS.
I am running a job called DSNTIJMS and it does not find the database
DSNATPDB, certain procedures sysibm.sql* and the tables sysibm.sqt*. Do I
need to install something in DB2 prior to running this job, IBM suggested I
go to this link and get more information on it. I started to read the 35
books in this link (see below),but in the interest of saving time, I am just
thiniking if anyone already tried this in this newsgroup.

http://www-306.ibm.com/software/data...0/v7books.html

I am using DB2 Version 7.1 for z/OS. All I wanted to do is to have an
external application or other DB2s (non mainframe),and other databases to
have access to the mainframe data through an ODBC or / with JDBC connection.

Any help appreciated.

Thanks,

RdR
Nov 12 '05 #1
Share this Question
Share on Google+
4 Replies


P: n/a
Hello,

this job should actually create the objects you claim that it is missing! It
contains the drop statements for this objects in the first step just to
allow clean re-runs - but if it never run successfully before, it never
created any of this objects and thus this statements MUST fail :-). This is
also the reason, why this first step is totally under comment in the
uncustomized version of this job.

Comment the first step (DSNTICU) out completely or add a RESTART=DSNTIRU -
parm to the JOB-statement to start with the step that actually does what you
want. However, you should carefully revise the CREATE-statements this job
will execute to make sure all parms (WLM-environment, storage group, etc.)
suit the needs of your installation.

Cheers - Walter.
"RdR" <ro*@delrosario.ca> schrieb im Newsbeitrag
news:3R******************@nnrp1.uunet.ca...
Hi,

I am trying to setup an ODBC / JDBC connection to my tables in DB2 for z/OS. I am running a job called DSNTIJMS and it does not find the database
DSNATPDB, certain procedures sysibm.sql* and the tables sysibm.sqt*. Do I
need to install something in DB2 prior to running this job, IBM suggested I go to this link and get more information on it. I started to read the 35
books in this link (see below),but in the interest of saving time, I am just thiniking if anyone already tried this in this newsgroup.

http://www-306.ibm.com/software/data...0/v7books.html

I am using DB2 Version 7.1 for z/OS. All I wanted to do is to have an
external application or other DB2s (non mainframe),and other databases to
have access to the mainframe data through an ODBC or / with JDBC connection.
Any help appreciated.

Thanks,

RdR

Nov 12 '05 #2

P: n/a
RdR
Hi Walter,

Thank you so much for pointing that out. I checked the JCL and saw that the
drop statements were not commented out. Did what you suggested and the job
had a return code of 4 which is the expected result. The Database, procs and
tables are there now.

Again, all my thanks.

RdR

"Walter Schneider" <wa**************@telekom.at.nospam> wrote in message
news:42***********************@newsreader02.highwa y.telekom.at...
Hello,

this job should actually create the objects you claim that it is missing!
It
contains the drop statements for this objects in the first step just to
allow clean re-runs - but if it never run successfully before, it never
created any of this objects and thus this statements MUST fail :-). This
is
also the reason, why this first step is totally under comment in the
uncustomized version of this job.

Comment the first step (DSNTICU) out completely or add a RESTART=DSNTIRU -
parm to the JOB-statement to start with the step that actually does what
you
want. However, you should carefully revise the CREATE-statements this job
will execute to make sure all parms (WLM-environment, storage group, etc.)
suit the needs of your installation.

Cheers - Walter.
"RdR" <ro*@delrosario.ca> schrieb im Newsbeitrag
news:3R******************@nnrp1.uunet.ca...
Hi,

I am trying to setup an ODBC / JDBC connection to my tables in DB2 for

z/OS.
I am running a job called DSNTIJMS and it does not find the database
DSNATPDB, certain procedures sysibm.sql* and the tables sysibm.sqt*. Do I
need to install something in DB2 prior to running this job, IBM suggested

I
go to this link and get more information on it. I started to read the 35
books in this link (see below),but in the interest of saving time, I am

just
thiniking if anyone already tried this in this newsgroup.

http://www-306.ibm.com/software/data...0/v7books.html

I am using DB2 Version 7.1 for z/OS. All I wanted to do is to have an
external application or other DB2s (non mainframe),and other databases
to
have access to the mainframe data through an ODBC or / with JDBC

connection.

Any help appreciated.

Thanks,

RdR


Nov 12 '05 #3

P: n/a
RdR
Also, IBM documentation refer to this job as DSNTIGMS, I can only find
DSNTIJMS in my system, is this a typo?

Thanks,

RdR

"RdR" <ro*@delrosario.ca> wrote in message
news:cw******************@nnrp1.uunet.ca...
Hi Walter,

Thank you so much for pointing that out. I checked the JCL and saw that
the drop statements were not commented out. Did what you suggested and the
job had a return code of 4 which is the expected result. The Database,
procs and tables are there now.

Again, all my thanks.

RdR

"Walter Schneider" <wa**************@telekom.at.nospam> wrote in message
news:42***********************@newsreader02.highwa y.telekom.at...
Hello,

this job should actually create the objects you claim that it is missing!
It
contains the drop statements for this objects in the first step just to
allow clean re-runs - but if it never run successfully before, it never
created any of this objects and thus this statements MUST fail :-). This
is
also the reason, why this first step is totally under comment in the
uncustomized version of this job.

Comment the first step (DSNTICU) out completely or add a
RESTART=DSNTIRU -
parm to the JOB-statement to start with the step that actually does what
you
want. However, you should carefully revise the CREATE-statements this job
will execute to make sure all parms (WLM-environment, storage group,
etc.)
suit the needs of your installation.

Cheers - Walter.
"RdR" <ro*@delrosario.ca> schrieb im Newsbeitrag
news:3R******************@nnrp1.uunet.ca...
Hi,

I am trying to setup an ODBC / JDBC connection to my tables in DB2 for

z/OS.
I am running a job called DSNTIJMS and it does not find the database
DSNATPDB, certain procedures sysibm.sql* and the tables sysibm.sqt*. Do
I
need to install something in DB2 prior to running this job, IBM
suggested

I
go to this link and get more information on it. I started to read the 35
books in this link (see below),but in the interest of saving time, I am

just
thiniking if anyone already tried this in this newsgroup.

http://www-306.ibm.com/software/data...0/v7books.html

I am using DB2 Version 7.1 for z/OS. All I wanted to do is to have an
external application or other DB2s (non mainframe),and other databases
to
have access to the mainframe data through an ODBC or / with JDBC

connection.

Any help appreciated.

Thanks,

RdR



Nov 12 '05 #4

P: n/a
Da is no job like this in the DSN710.SDSNSAMP library - so this may actually
be a typo...
DSNTIJMS will exactly prepare what JDBC and ODBC clients above a certain
level expect from DB2 for z/OS and other RDBMSes...

Cheers - Walter.

"RdR" <ro*@delrosario.ca> schrieb im Newsbeitrag
news:jz******************@nnrp1.uunet.ca...
Also, IBM documentation refer to this job as DSNTIGMS, I can only find
DSNTIJMS in my system, is this a typo?

Thanks,

RdR

"RdR" <ro*@delrosario.ca> wrote in message
news:cw******************@nnrp1.uunet.ca...
Hi Walter,

Thank you so much for pointing that out. I checked the JCL and saw that
the drop statements were not commented out. Did what you suggested and the job had a return code of 4 which is the expected result. The Database,
procs and tables are there now.

Again, all my thanks.

RdR

"Walter Schneider" <wa**************@telekom.at.nospam> wrote in message
news:42***********************@newsreader02.highwa y.telekom.at...
Hello,

this job should actually create the objects you claim that it is missing! It
contains the drop statements for this objects in the first step just to
allow clean re-runs - but if it never run successfully before, it never
created any of this objects and thus this statements MUST fail :-). This is
also the reason, why this first step is totally under comment in the
uncustomized version of this job.

Comment the first step (DSNTICU) out completely or add a
RESTART=DSNTIRU -
parm to the JOB-statement to start with the step that actually does what you
want. However, you should carefully revise the CREATE-statements this job will execute to make sure all parms (WLM-environment, storage group,
etc.)
suit the needs of your installation.

Cheers - Walter.
"RdR" <ro*@delrosario.ca> schrieb im Newsbeitrag
news:3R******************@nnrp1.uunet.ca...
Hi,

I am trying to setup an ODBC / JDBC connection to my tables in DB2 for
z/OS.
I am running a job called DSNTIJMS and it does not find the database
DSNATPDB, certain procedures sysibm.sql* and the tables sysibm.sqt*. Do I
need to install something in DB2 prior to running this job, IBM
suggested
I
go to this link and get more information on it. I started to read the 35 books in this link (see below),but in the interest of saving time, I am just
thiniking if anyone already tried this in this newsgroup.

http://www-306.ibm.com/software/data...0/v7books.html

I am using DB2 Version 7.1 for z/OS. All I wanted to do is to have an
external application or other DB2s (non mainframe),and other databases
to
have access to the mainframe data through an ODBC or / with JDBC
connection.

Any help appreciated.

Thanks,

RdR



Nov 12 '05 #5

This discussion thread is closed

Replies have been disabled for this discussion.