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 4  4169 
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
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
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
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
This thread has been closed and replies have been disabled. Please start a new discussion. |
