[z/OS v-whatever] Admin Task Scheduler, XML, LOBs

Comrades,

I'm curious about parts of the DB2 product which I have never used. I'm doing a bit of exploring in the manuals in my free time (ha!) and looking at stuff in DB2 which I haven't seen used by people who I'm in touch with. So:

Has anyone on list made use of the Admin Task Scheduler; XML; LOBs? Other than to define them for others? I'd eventually like to do some creating and using of these things for the exercise, in the same way which one learns new programming languages in advance of actually using them (well, some of us do it that way!).

Any pointers to examples of DDL/DML/application code would be appreciated. I'm going to check out the manuals and redbooks as I can find them, of course (although with redbooks, either suggestions or a link to the Sekrit Massster Index of DB2 Redbooks would be nice, too).

--Phil Sevetson
**This e-mail, including any attachments, may be confidential, privileged, or otherwise legally protected. It is intended only for the addressee. If you received this e-mail in error or from someone who was not authorized to send it to you, do not disseminate, copy, or otherwise use this e-mail or its attachments. Please notify the sender immediately by reply e-mail and delete the e-mail from your system.**

My client has been using LOBS, XML objects for well over 10 years with all types of sizes and issues. To be honest, V12 is better but still not there.


For example, you cannot unload a lob from an image copy tape still. Copying LOBs is still more of an effort than it should be. Compression of LOBS requires a special hardware cost feature on Z/OS. Doesn't work at all like regular data compression. you should absolutely define all LOB columns as Nullable. If nullable then when you want to zero out the LOB value but keep the rest of the row, it doesn't take an entire page for the ' ' value. Just a null ptr. Much savings on space.


Those are a few things we've found.


Thanks Myron W. Miller


________________________________
From: Sevetson, Phil <[login to unmask email]>
Sent: Monday, February 5, 2018 10:42 AM
To: [login to unmask email]
Subject: [DB2-L] - [z/OS v-whatever] Admin Task Scheduler, XML, LOBs


Comrades,



I’m curious about parts of the DB2 product which I have never used. I’m doing a bit of exploring in the manuals in my free time (ha!) and looking at stuff in DB2 which I haven’t seen used by people who I’m in touch with. So:



Has anyone on list made use of the Admin Task Scheduler; XML; LOBs? Other than to define them for others? I’d eventually like to do some creating and using of these things for the exercise, in the same way which one learns new programming languages in advance of actually using them (well, some of us do it that way!).



Any pointers to examples of DDL/DML/application code would be appreciated. I’m going to check out the manuals and redbooks as I can find them, of course (although with redbooks, either suggestions or a link to the Sekrit Massster Index of DB2 Redbooks would be nice, too).



--Phil Sevetson

**This e-mail, including any attachments, may be confidential, privileged, or otherwise legally protected. It is intended only for the addressee. If you received this e-mail in error or from someone who was not authorized to send it to you, do not disseminate, copy, or otherwise use this e-mail or its attachments. Please notify the sender immediately by reply e-mail and delete the e-mail from your system.**
-----End Original Message-----

Ouch. Good to know, but not good to hear. Thanks, Myron.

From: Myron Miller [mailto:[login to unmask email]
Sent: Monday, February 05, 2018 10:51 AM
To: [login to unmask email]
Subject: [DB2-L] - RE: [z/OS v-whatever] Admin Task Scheduler, XML, LOBs


My client has been using LOBS, XML objects for well over 10 years with all types of sizes and issues. To be honest, V12 is better but still not there.



For example, you cannot unload a lob from an image copy tape still. Copying LOBs is still more of an effort than it should be. Compression of LOBS requires a special hardware cost feature on Z/OS. Doesn't work at all like regular data compression. you should absolutely define all LOB columns as Nullable. If nullable then when you want to zero out the LOB value but keep the rest of the row, it doesn't take an entire page for the ' ' value. Just a null ptr. Much savings on space.



Those are a few things we've found.


Thanks Myron W. Miller

________________________________
From: Sevetson, Phil <[login to unmask email]<mailto:[login to unmask email]>>
Sent: Monday, February 5, 2018 10:42 AM
To: [login to unmask email]<mailto:[login to unmask email]>
Subject: [DB2-L] - [z/OS v-whatever] Admin Task Scheduler, XML, LOBs


Comrades,



I'm curious about parts of the DB2 product which I have never used. I'm doing a bit of exploring in the manuals in my free time (ha!) and looking at stuff in DB2 which I haven't seen used by people who I'm in touch with. So:



Has anyone on list made use of the Admin Task Scheduler; XML; LOBs? Other than to define them for others? I'd eventually like to do some creating and using of these things for the exercise, in the same way which one learns new programming languages in advance of actually using them (well, some of us do it that way!).



Any pointers to examples of DDL/DML/application code would be appreciated. I'm going to check out the manuals and redbooks as I can find them, of course (although with redbooks, either suggestions or a link to the Sekrit Massster Index of DB2 Redbooks would be nice, too).



--Phil Sevetson
**This e-mail, including any attachments, may be confidential, privileged, or otherwise legally protected. It is intended only for the addressee. If you received this e-mail in error or from someone who was not authorized to send it to you, do not disseminate, copy, or otherwise use this e-mail or its attachments. Please notify the sender immediately by reply e-mail and delete the e-mail from your system.**
-----End Original Message-----
**This e-mail, including any attachments, may be confidential, privileged, or otherwise legally protected. It is intended only for the addressee. If you received this e-mail in error or from someone who was not authorized to send it to you, do not disseminate, copy, or otherwise use this e-mail or its attachments. Please notify the sender immediately by reply e-mail and delete the e-mail from your system.**

Phil,

I've used XML and LOBs fairly extensively in Db2 for z/OS. They are working
fairly well, although they are very hard to move from DB2 to another
database, at least without a tool. Even with a tool they could present a
challenge. However, within the DB2 family they work quite well and are easy
to move from one DB to another.



No task scheduler experience.



I recently started playing with native REST. Very Cool! Haven't addressed
the security yet.



Dan



Daniel L Luksetich

DanL Database Consulting



IBM GOLD Consultant

IBM Champion for Analytics

IDUG Content Committee Past-Chairman

IBM Certified Database Adminstrator - DB2 11 DBA for z/OS

IBM Certified System Administrator - DB2 11 for z/OS

IBM Certified Application Developer - DB2 11 for z/OS

IBM Certified Advanced Database Administrator - DB2 10.1 for Linux UNIX and
Windows



From: Sevetson, Phil [mailto:[login to unmask email]
Sent: Monday, February 5, 2018 9:42 AM
To: [login to unmask email]
Subject: [DB2-L] - [z/OS v-whatever] Admin Task Scheduler, XML, LOBs



Comrades,



I'm curious about parts of the DB2 product which I have never used. I'm
doing a bit of exploring in the manuals in my free time (ha!) and looking at
stuff in DB2 which I haven't seen used by people who I'm in touch with. So:



Has anyone on list made use of the Admin Task Scheduler; XML; LOBs? Other
than to define them for others? I'd eventually like to do some creating and
using of these things for the exercise, in the same way which one learns new
programming languages in advance of actually using them (well, some of us do
it that way!).



Any pointers to examples of DDL/DML/application code would be appreciated.
I'm going to check out the manuals and redbooks as I can find them, of
course (although with redbooks, either suggestions or a link to the Sekrit
Massster Index of DB2 Redbooks would be nice, too).



--Phil Sevetson

**This e-mail, including any attachments, may be confidential, privileged,
or otherwise legally protected. It is intended only for the addressee. If
you received this e-mail in error or from someone who was not authorized to
send it to you, do not disseminate, copy, or otherwise use this e-mail or
its attachments. Please notify the sender immediately by reply e-mail and
delete the e-mail from your system.**

-----End Original Message-----

That's right, I am forced to use DSN1COPY to move LOBs from a production
image copy to a test table.

Dan



Daniel L Luksetich

DanL Database Consulting



IBM GOLD Consultant

IBM Champion for Analytics

IDUG Content Committee Past-Chairman

IBM Certified Database Adminstrator - DB2 11 DBA for z/OS

IBM Certified System Administrator - DB2 11 for z/OS

IBM Certified Application Developer - DB2 11 for z/OS

IBM Certified Advanced Database Administrator - DB2 10.1 for Linux UNIX and
Windows



From: Myron Miller [mailto:[login to unmask email]
Sent: Monday, February 5, 2018 9:51 AM
To: [login to unmask email]
Subject: [DB2-L] - RE: [z/OS v-whatever] Admin Task Scheduler, XML, LOBs



My client has been using LOBS, XML objects for well over 10 years with all
types of sizes and issues. To be honest, V12 is better but still not
there.



For example, you cannot unload a lob from an image copy tape still. Copying
LOBs is still more of an effort than it should be. Compression of LOBS
requires a special hardware cost feature on Z/OS. Doesn't work at all like
regular data compression. you should absolutely define all LOB columns as
Nullable. If nullable then when you want to zero out the LOB value but keep
the rest of the row, it doesn't take an entire page for the ' ' value. Just
a null ptr. Much savings on space.



Those are a few things we've found.



Thanks Myron W. Miller



_____

From: Sevetson, Phil <[login to unmask email] <mailto:[login to unmask email]> >
Sent: Monday, February 5, 2018 10:42 AM
To: [login to unmask email] <mailto:[login to unmask email]>
Subject: [DB2-L] - [z/OS v-whatever] Admin Task Scheduler, XML, LOBs



Comrades,



I'm curious about parts of the DB2 product which I have never used. I'm
doing a bit of exploring in the manuals in my free time (ha!) and looking at
stuff in DB2 which I haven't seen used by people who I'm in touch with. So:



Has anyone on list made use of the Admin Task Scheduler; XML; LOBs? Other
than to define them for others? I'd eventually like to do some creating and
using of these things for the exercise, in the same way which one learns new
programming languages in advance of actually using them (well, some of us do
it that way!).



Any pointers to examples of DDL/DML/application code would be appreciated.
I'm going to check out the manuals and redbooks as I can find them, of
course (although with redbooks, either suggestions or a link to the Sekrit
Massster Index of DB2 Redbooks would be nice, too).



--Phil Sevetson

**This e-mail, including any attachments, may be confidential, privileged,
or otherwise legally protected. It is intended only for the addressee. If
you received this e-mail in error or from someone who was not authorized to
send it to you, do not disseminate, copy, or otherwise use this e-mail or
its attachments. Please notify the sender immediately by reply e-mail and
delete the e-mail from your system.**

-----End Original Message-----



-----End Original Message-----

Hey, how's it going?

  Just one quick note. I also got headaches moving LOBs and XMLs and then switched to move them from one Db2 to another by using the cross loader utility (connecting them together through the communications DB and then using a cursor to unload from one table and load into the other subsystem). The second least-ugly option was unloading to zFSs and moving them between partitions.

  However... depending on the content of the XML and LOB, I would also prefer to use Content OnDemand Manager (yep,the famous CMOD). What I have seen at least on this side, is that most LOB and XML content is meant to be "final" and archived, so for that CMOD is more convenient.

Haven't used the admin task either, and I'd like to play with REST too given those new articles that were released.

 

Regards,

Javier Estrada Benavides, Mexico

IBM Champion

IBM Certified System Administrator - DB2 11 for z/OS

IBM Certified Database Administrator - DB2 11 DBA for z/OS

Hi Phil,

Regarding the Db2 Administrative scheduler:

I have seen limited use of it as customer sites, as most shops have a batch scheduler (e.g., IBM TWS) which they use for everything.

For a DBA the administrative scheduler could be interesting to schedule (non-production?) stuff since it is under the control of the DBAs rather than operation/automation people. Just the other day I learned that one of our developers uses it to submit a JCL that "touches" some of his datasets, so they are never migrated by HSM :) It will probably otherwise be difficult to convince the operation/automation people to schedule that JCL...

In addition, the Db2 Administrative Scheduler is supported by IBM Db2 Automation Tool for the Autonomics Director. Automation Tool also has an ISPF interface for the scheduler, which is administrated by stored procedures.

Best regards,

Jørn Thyssen

Rocket Software
77 Fourth Avenue • Waltham, MA • 02451 • USA
E: [login to unmask email] • W: www.rocketsoftware.com 

Views are personal. 

Thanks, Jørn.
--Phil S.

From: Jørn Thyssen [mailto:[login to unmask email]
Sent: Tuesday, February 06, 2018 12:15 PM
To: [login to unmask email]
Subject: [DB2-L] - RE: [z/OS v-whatever] Admin Task Scheduler, XML, LOBs


Hi Phil,

Regarding the Db2 Administrative scheduler:

I have seen limited use of it as customer sites, as most shops have a batch scheduler (e.g., IBM TWS) which they use for everything.

For a DBA the administrative scheduler could be interesting to schedule (non-production?) stuff since it is under the control of the DBAs rather than operation/automation people. Just the other day I learned that one of our developers uses it to submit a JCL that "touches" some of his datasets, so they are never migrated by HSM :) It will probably otherwise be difficult to convince the operation/automation people to schedule that JCL...

In addition, the Db2 Administrative Scheduler is supported by IBM Db2 Automation Tool for the Autonomics Director. Automation Tool also has an ISPF interface for the scheduler, which is administrated by stored procedures.

Best regards,

Jørn Thyssen

Rocket Software
77 Fourth Avenue • Waltham, MA • 02451 • USA
E: [login to unmask email]<mailto:[login to unmask email]> • W: www.rocketsoftware.com http://www.rocketsoftware.com

Views are personal.

-----End Original Message-----
**This e-mail, including any attachments, may be confidential, privileged, or otherwise legally protected. It is intended only for the addressee. If you received this e-mail in error or from someone who was not authorized to send it to you, do not disseminate, copy, or otherwise use this e-mail or its attachments. Please notify the sender immediately by reply e-mail and delete the e-mail from your system.**