Desperately seeking cross-reference bewteen UDB and OS/390 DB2

Michele Saffer

Desperately seeking cross-reference bewteen UDB and OS/390 DB2
I am an OS/390 DBA using version 6. I am also trying to support UDB on a
Unix platform. I keep beating my head against the wall trying to figure out
how to do the things that I know how to do in the OS/390 world, but don't
know how to do in the UDB world. For example, it took me a while, but I
finally figured out that the CHECK DATA utility on OS/390 is a SET INTEGRITY
SQL statement in UDB. I'm now trying to figure out how to free a package.
In addition to help with this, I'm wondering whether there is some
documentation somewhere that I can get my hands on to help me with the next
thing I can't figure out. Surely I'm not the only mainframer with a need
for this sort of thing. I have searched the list archives and looked for
something on the IBM web site, but I don't see anything.

Thanks,
Michele Saffer
ACS-Inc.



Steve Westfall

Re: Desperately seeking cross-reference bewteen UDB and OS/390 DB2
(in response to Michele Saffer)
Michele,

You can use the SQL "DROP PACKAGE <package-name>" statement in UDB.

I'd recommend downloading the PDF versions of the Command Reference and the
SQL Reference from IBM's web site.

Steve Westfall
Equifax, Inc.




"Saffer, Michele"
<[login to unmask email] To: [login to unmask email]
S-INC.COM> cc:
Sent by: DB2 Data Subject: Desperately seeking cross-reference bewteen UDB and OS/390 DB2
Base Discussion
List
<[login to unmask email]>


12/19/2001 12:50
PM
Please respond to
DB2 Data Base
Discussion List





. . . I'm now trying to figure out how to free a package.
In addition to help with this, I'm wondering whether there is some
documentation somewhere that I can get my hands on to help me with the next
thing I can't figure out. Surely I'm not the only mainframer with a need
for this sort of thing. I have searched the list archives and looked for
something on the IBM web site, but I don't see anything.

Thanks,
Michele Saffer
ACS-Inc.








Russell Collins

Re: Desperately seeking cross-reference bewteen UDB and OS/390 DB2
(in response to Steve Westfall)
There are books with that help with this. I have worked on the mainframe
and also the UDB versions on DB2. IBM has a book called DB2 Universal
Database / Database Administration Certification Guide. This covers DB2 UDB
for Unix, Windows, and OS/2. It may just seem like a certification guide
but I used it as a good reference for the things that I am doing.


Russell Collins
eCommerce Technology Austin
http://www.ectaustin.com/



-----Original Message-----
From: DB2 Data Base Discussion List [mailto:[login to unmask email]On Behalf Of
Saffer, Michele
Sent: Wednesday, December 19, 2001 12:51 PM
To: [login to unmask email]
Subject: Desperately seeking cross-reference bewteen UDB and OS/390 DB2


I am an OS/390 DBA using version 6. I am also trying to support UDB on a
Unix platform. I keep beating my head against the wall trying to figure out
how to do the things that I know how to do in the OS/390 world, but don't
know how to do in the UDB world. For example, it took me a while, but I
finally figured out that the CHECK DATA utility on OS/390 is a SET INTEGRITY
SQL statement in UDB. I'm now trying to figure out how to free a package.
In addition to help with this, I'm wondering whether there is some
documentation somewhere that I can get my hands on to help me with the next
thing I can't figure out. Surely I'm not the only mainframer with a need
for this sort of thing. I have searched the list archives and looked for
something on the IBM web site, but I don't see anything.

Thanks,
Michele Saffer
ACS-Inc.








Jim Wankowski

Re: Desperately seeking cross-reference bewteen UDB and OS/390 DB2
(in response to Russell Collins)
Hi Michele
I have written a presentation for IDUG and other DB2 seminars comparing the
architectural differences of DB2 on OS/390 vs. UNix/NT. I would be more
than happy to send you a copy. Just drop me an Email and let me know.
Also if you are interested in a tool set for administering DB2 on multiple
platforms check out Quest Central for DB2 on our web site WWW.QUEST.COM/DB2
and download a free trial.
Thanks

Jim Wankowski
Quest Software



Raymond Bell

Re: Desperately seeking cross-reference bewteen UDB and OS/390 DB2
(in response to Jim Wankowski)
Hi Jim,

I suspect you'll get a lot of requests for this fantastic sounding document
- I know I'd like a copy - so would you mind posting it in the documents
bit of DB2-L?

Cheers and thanks in advance,


Raymond



Jim Wankowski
<jim.wankowski@ To: [login to unmask email]
QUEST.COM> cc:
Sent by: DB2 Subject: Re: Desperately seeking cross-reference bewteen UDB and
Data Base OS/390 DB2
Discussion List
<[login to unmask email]
>


20/12/01 09:28
Please respond
to DB2 Data
Base Discussion
List





Hi Michele
I have written a presentation for IDUG and other DB2 seminars comparing the
architectural differences of DB2 on OS/390 vs. UNix/NT. I would be more
than happy to send you a copy. Just drop me an Email and let me know.
Also if you are interested in a tool set for administering DB2 on multiple
platforms check out Quest Central for DB2 on our web site WWW.QUEST.COM/DB2
and download a free trial.
Thanks

Jim Wankowski
Quest Software