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-----