Question on DB2 LOBs and OAM

Lizette Koehler

Question on DB2 LOBs and OAM
I am working on reviewing the potential of using DB2 LOBs in OAM.



Currently at DB2 V10 z/OS V2.1





I was wondering if those that have done this, can provide any guidance,
gotcha's, etc. that will help me evaluate, plan out, and implement this process.



Was this worth doing? Why or why not



Any issues that needed to be known before implementation? Any DB2 facilities
that need to be updated before using this?



Anything my storage admins (that is me) needs to know?




Thanks







Lizette Koehler

statistics: A precise and logical method for stating a half-truth inaccurately



Philip Sevetson

Question on DB2 LOBs and OAM
(in response to Lizette Koehler)
**please note my email address change**
Lizette,

OAM=Object Attribute Memory Computing? Operations Administration and Maintenance Computing?

Philip Sevetson
Computer Systems Manager
5 Manhattan West (33rd St at 10th Ave)
New York, NY 10001-2632
212-857-1688 w
917-991-7052 c
212-857-1659 f
[cid:[login to unmask email]

From: Lizette Koehler [mailto:[login to unmask email]
Sent: Monday, October 30, 2017 9:40 AM
To: [login to unmask email]
Subject: [DB2-L] - Question on DB2 LOBs and OAM


I am working on reviewing the potential of using DB2 LOBs in OAM.



Currently at DB2 V10 z/OS V2.1





I was wondering if those that have done this, can provide any guidance, gotcha's, etc. that will help me evaluate, plan out, and implement this process.



Was this worth doing? Why or why not



Any issues that needed to be known before implementation? Any DB2 facilities that need to be updated before using this?

Anything my storage admins (that is me) needs to know?



Thanks







Lizette Koehler

statistics: A precise and logical method for stating a half-truth inaccurately



-----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.**
Attachments

  • image001.png (3.3k)

Raymond Bell

Question on DB2 LOBs and OAM
(in response to Philip Sevetson)
Optical Access Method. It's a PITA, last time I got involved - which was... 15+ years ago, in Germany. Fun times - not! Can't remember the details but it was a major hassle. Storing low-value objects on 'cheap' media made sense when DASD was worth more than gold but it's not worth the hassle.

Lizette, just bung it on DASD and save yourself a world of hurt.

Cheers,


Raymond
PS: Oh-oh-oh, Ama... Er, a not-very-cryptic clue as to where this was. The Good Dr. Ebert, if he's still lurking from foreign Orange lands, may remember more than me about OAM.

Raymond Bell
DB2 Database Administrator | IT Operations | Technology | RBS

From: Sevetson, Phil [mailto:[login to unmask email]
Sent: 30 October 2017 14:06
To: '[login to unmask email]'
Subject: [DB2-L] - RE: Question on DB2 LOBs and OAM


*********************************************
" This message originates from outside our organisation. Consider carefully whether you should click on any links, open any attachments or reply. If in doubt, forward to ~ Phishing"
*********************************************

**please note my email address change**
Lizette,

OAM=Object Attribute Memory Computing? Operations Administration and Maintenance Computing?

Philip Sevetson
Computer Systems Manager
5 Manhattan West (33rd St at 10th Ave)
New York, NY 10001-2632
212-857-1688 w
917-991-7052 c
212-857-1659 f
[cid:[login to unmask email]

From: Lizette Koehler [mailto:[login to unmask email]
Sent: Monday, October 30, 2017 9:40 AM
To: [login to unmask email]<mailto:[login to unmask email]>
Subject: [DB2-L] - Question on DB2 LOBs and OAM


I am working on reviewing the potential of using DB2 LOBs in OAM.



Currently at DB2 V10 z/OS V2.1





I was wondering if those that have done this, can provide any guidance, gotcha's, etc. that will help me evaluate, plan out, and implement this process.



Was this worth doing? Why or why not



Any issues that needed to be known before implementation? Any DB2 facilities that need to be updated before using this?

Anything my storage admins (that is me) needs to know?



Thanks







Lizette Koehler

statistics: A precise and logical method for stating a half-truth inaccurately



-----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.**
-----End Original Message-----
The Royal Bank of Scotland plc. Registered in Scotland No 90312. Registered Office: 36 St Andrew Square, Edinburgh EH2 2YB. The Royal Bank of Scotland is authorised by the Prudential Regulation Authority, and regulated by the Financial Conduct Authority and Prudential Regulation Authority. The Royal Bank of Scotland N.V. is authorised and regulated by the De Nederlandsche Bank and has its seat at Amsterdam, the Netherlands, and is registered in the Commercial Register under number 33002587. Registered Office: Gustav Mahlerlaan 350, Amsterdam, The Netherlands. The Royal Bank of Scotland N.V. and The Royal Bank of Scotland plc are authorised to act as agent for each other in certain jurisdictions.

National Westminster Bank Plc. Registered in England No. 929027. Registered Office: 135 Bishopsgate, London EC2M 3UR. National Westminster Bank Plc is authorised by the Prudential Regulation Authority, and regulated by the Financial Conduct Authority and the Prudential Regulation Authority.

The Royal Bank of Scotland plc and National Westminster Bank Plc are authorised to act as agent for each other.

This e-mail message is confidential and for use by the addressee only. If the message is received by anyone other than the addressee, please return the message to the sender by replying to it and then delete the message from your computer. Internet e-mails are not necessarily secure. The Royal Bank of Scotland plc, The Royal Bank of Scotland N.V., National Westminster Bank Plc or any affiliated entity (“RBS” or “us”) does not accept responsibility for changes made to this message after it was sent. RBS may monitor e-mails for business and operational purposes. By replying to this message you give your consent to the monitoring of your e-mail communications with us.

Whilst all reasonable care has been taken to avoid the transmission of viruses, it is the responsibility of the recipient to ensure that the onward transmission, opening or use of this message and any attachments will not adversely affect its systems or data. No responsibility is accepted by RBS in this regard and the recipient should carry out such virus and other checks as it considers appropriate.

Visit our website at www.rbs.com http://www.rbs.com
Attachments

  • image001.png (3.3k)

Lizette Koehler

Question on DB2 LOBs and OAM
(in response to Philip Sevetson)
Object Access Method - part of dfsms



Lizette





From: Sevetson, Phil [mailto:[login to unmask email]
Sent: Monday, October 30, 2017 7:06 AM
To: [login to unmask email]
Subject: [DB2-L] - RE: Question on DB2 LOBs and OAM



**please note my email address change**

Lizette,



OAM=Object Attribute Memory Computing? Operations Administration and Maintenance
Computing?



Philip Sevetson

Computer Systems Manager

5 Manhattan West (33rd St at 10th Ave)

New York, NY 10001-2632

212-857-1688 w

917-991-7052 c

212-857-1659 f





From: Lizette Koehler [mailto:[login to unmask email]
Sent: Monday, October 30, 2017 9:40 AM
To: [login to unmask email] <mailto:[login to unmask email]>
Subject: [DB2-L] - Question on DB2 LOBs and OAM



I am working on reviewing the potential of using DB2 LOBs in OAM.



Currently at DB2 V10 z/OS V2.1





I was wondering if those that have done this, can provide any guidance,
gotcha's, etc. that will help me evaluate, plan out, and implement this process.



Was this worth doing? Why or why not



Any issues that needed to be known before implementation? Any DB2 facilities
that need to be updated before using this?

Anything my storage admins (that is me) needs to know?




Thanks







Lizette Koehler

statistics: A precise and logical method for stating a half-truth inaccurately





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

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

Daniel Luksetich

Question on DB2 LOBs and OAM
(in response to Lizette Koehler)


my only experience with OAM has been with VARCHAR FOR BIT DATA fields.
Worked pretty well. It might be the better option if not really
processing LOBs within DB2. I'm using LOBs currently at two customer
sites and there are additional hoops to jump through with regards to
just about everything. If you have the option of configuring OAM to go
the VARCHAR route then I would suggest you explore it, especially since
you are DB2 10 for z/OS.

Dan

On 10.30.2017 09:45, Lizette Koehler wrote:

> Object Access Method - part of dfsms
>
> Lizette
>
> FROM: Sevetson, Phil [mailto:[login to unmask email]
> SENT: Monday, October 30, 2017 7:06 AM
> TO: [login to unmask email]
> SUBJECT: [DB2-L] - RE: Question on DB2 LOBs and OAM
>
> **please note my email address change**
>
> Lizette,
>
> OAM=Object Attribute Memory Computing? Operations Administration and Maintenance Computing?
>
> Philip Sevetson
>
> Computer Systems Manager
>
> 5 Manhattan West (33rd St at 10th Ave)
>
> New York, NY 10001-2632
>
> 212-857-1688 w
>
> 917-991-7052 c
>
> 212-857-1659 f
>
> FROM: Lizette Koehler [mailto:[login to unmask email]
> SENT: Monday, October 30, 2017 9:40 AM
> TO: [login to unmask email]
> SUBJECT: [DB2-L] - Question on DB2 LOBs and OAM
>
> I am working on reviewing the potential of using DB2 LOBs in OAM.
>
> Currently at DB2 V10 z/OS V2.1
>
> I was wondering if those that have done this, can provide any guidance, gotcha's, etc. that will help me evaluate, plan out, and implement this process.
>
> Was this worth doing? Why or why not
>
> Any issues that needed to be known before implementation? Any DB2 facilities that need to be updated before using this?
>
> Anything my storage admins (that is me) needs to know?
>
> Thanks
>
> Lizette Koehler
>
> statistics: A precise and logical method for stating a half-truth inaccurately
>
> -----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.**
>
> -----End Original Message-----
>
> -----End Original Message-----


Links:
------
[1] http://www.idug.org/p/fo/st/?post=183541&amp;anc=p183541#p183541
[2] http://www.idug.org/p/fo/si/?topic=19
[3] http://www.idug.org/p/us/to/
[4] http://www.ESAIGroup.com/idug
[5] http://www.idug.org/p/cm/ld/fid=2

Carol Anne Sutfin

Question on DB2 LOBs and OAM
(in response to Lizette Koehler)
O.A.M. is used to store large objects like document from scanning or computer generated documents. It uses Db2 table spaces to store these and maintains reference points to these by "Indexes" you define.It provides the ability to define retention times for various groups of documents.
Documents can be divided into different groups for different retention and storage type.  Storage can be DASD, tape, optical disc or any other media available.
IBM'S On-demand uses O.A.M. for storage management. 
It does require some care and feeding.
Carol Sutfin

Sent from my Samsung Galaxy , an AT&T LTE smartphone
-------- Original message --------From: Lizette Koehler <[login to unmask email]> Date: 10/30/17 8:39 AM (GMT-06:00) To: [login to unmask email] Subject: [DB2-L] - Question on DB2 LOBs and OAM
I am working on reviewing the potential of using DB2 LOBs in OAM.  Currently at DB2 V10  z/OS V2.1  I was wondering if those that have done this, can provide any guidance, gotcha’s, etc. that will help me evaluate, plan out, and implement this process. Was this worth doing?  Why or why not Any issues that needed to be known before implementation?  Any DB2 facilities that need to be updated before using this?

Anything my storage admins (that is me) needs to know? 
Thanks   Lizette Koehlerstatistics: A precise and logical method for stating a half-truth inaccurately 
Site Links:
View post online  
View mailing list online  
Start new thread via email  
Unsubscribe from this mailing list  
Manage your subscription  


This email has been sent to: [login to unmask email]

Setup a data refresh task in less time than it takes to make a cup of coffee + save up to 90% in CPU

ESAi's BCV5 & XDM fast data refresh & Test Data Mgmt products will make you a hero to users. See

http://www.ESAIGroup.com/idug



Use of this email content is governed by the terms of service at:
http://www.idug.org/p/cm/ld/fid=2

Javier Estrada Benavides

RE: Question on DB2 LOBs and OAM
(in response to Daniel Luksetich)

Hey:

   Looks like inevitably the word CMOD will pop out so I might as well just bring it up. In the process of installing and configuring a CMOD environment on z/OS you have to go trough all that OAM/DB2 config which is what you're looking at, not a trivial task and it requires that for this topic the Db2 and the storage teams work as one.

From what I can quickly think of, the hardest part goes to the storage team in setting up the CBROAM parmlib member, and any exits if that's applicable to your site (especially the cbrhadux exit), the rest is setting up the SMS routines and not-so-hard configs. On the other side, the Db2 JCLs are straightforward to work with so it shouldn't be much of a problem.

At least from my experience, the troubleshooting comes first from the Db2 side and then to the storage team, so again, both departments will have to "merge" on this.

 

BTW.. I'm a happy OAM/CMOD admin as well

 

Regards,

Javier Estrada Benavides, Mexico

IBM Certified System Administrator - DB2 11 for z/OS

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

Ruediger Kurtz

AW: Question on DB2 LOBs and OAM
(in response to Lizette Koehler)
Lizette,

we did some testing with LOB-tablespaces and, from what I can recall, decided to go that way because we saw no degradation performance-wise.

You do remember that you will have to IPL with LOB=P, at least one had to IPL way back in 2012/13 or so.

As we have partitioned our OAM-tablespaces (104 parts per TS) and had 30 odd (OAM-)storage-groups we got bitten pretty badly by throwing in quite a number of new datasets, but increasing the number of open datasets helped.

Sorry I haven’t got any more details handy, but it’s quite a while I’ve been working with OAM.

Hth

Rüdiger




Rüdiger Kurtz
Abteilung Informatik – Betrieb

HUK-COBURG
Bahnhofsplatz
96444 Coburg
Telefon: 09561 96-44148
Telefax: 09561 96-44104
E-Mail: [login to unmask email]
Internet: www.huk.de
________________________________
HUK-COBURG Haftpflicht-Unterstützungs-Kasse kraftfahrender Beamter Deutschlands a. G. in Coburg
Reg.-Gericht Coburg HRB 100; St.-Nr. 9212/101/00021
Sitz der Gesellschaft: Bahnhofsplatz, 96444 Coburg
Vorsitzender des Aufsichtsrats: Prof. Dr. Heinrich R. Schradin.
Vorstand: Klaus-Jürgen Heitmann (Sprecher), Stefan Gronbach, Dr. Hans Olav Herøy, Dr. Jörg Rheinländer (stv.), Sarah Rössler, Daniel Thomas (stv.).
________________________________
Diese Nachricht enthält vertrauliche und/oder rechtlich geschützte Informationen.
Wenn Sie nicht der richtige Adressat sind oder diese Nachricht irrtümlich erhalten haben,
informieren Sie bitte sofort den Absender und vernichten Sie diese Nachricht.
Das unerlaubte Kopieren sowie die unbefugte Weitergabe dieser Nachricht ist nicht gestattet.

This information may contain confidential and/or privileged information.
If you are not the intended recipient (or have received this information in error) please notify the
sender immediately and destroy this information.
Any unauthorized copying, disclosure or distribution of the material in this information is strictly forbidden.
-----End Original Message-----