[OT] What Db2 / database topics are important to learn (today)?

Lockwood Lyon

[OT] What Db2 / database topics are important to learn (today)?
Dear Esteemed List,

I am writing a book based on my experiences with a multitude of database packages over several decades, including IMS, DB2 and Db2. It is meant to be both humorous and instructive, a combination of musings and lessons learned. Not a DBA guide per se, nor a manual or textbook. Perhaps best described as a collection of stories on useful topics.

However, since I've been away from the daily DBA/DB2/Db2 grind for over a year it suddenly struck me that I may (horrors!), without knowing it, be totally out-of-touch with what database administrators and developers need to know now and in the future.

What do DBAs need to know? Relational DB theory? How best to implement business rules and data constraints? SQL syntax (for correct use of outer joins, NOT (or not), tuning, etc.)? Interfaces and APIs? Big data considerations? Cloud? Data federation? Or won't DBAs exist in the future due to autonomics, etc.?

I would appreciate any and all ideas anyone has regarding what to include in such a book.

As your ideas may not be strictly relevant to the list, I've marked the post Off Topic. Listers may respond to me directly if they wish.

Thanks!

- Lock Lyon ([login to unmask email])


Philip Sevetson

[OT] What Db2 / database topics are important to learn (today)?
(in response to Lockwood Lyon)
**please note my email address change**
Lock,

So… you don’t think small, do you?

Someone, and it might have been Craig Mullins, elucidated a seven (?) layer hierarchy of database purposes. The bottom layer is “recoverability,” and I think the second layer is “security” and the third “availability.” I’m not sure on anything except the bottom. But it’s the fundamental justification for using a database to store things, and I think any reinventing-the-wheel discussion of data and database needs to start with that.

Also, there’s the general “why do you use a database?” - http://databasemanagement.wikia.com/wiki/DBMS_Functions

That’s all fundamentals. For brand-spanking-new stuff? Managing extreme storage requirements, understanding how new machine-learning and data-science practices are going to change what we’re expected to provide.

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: Lock Lyon [mailto:[login to unmask email]
Sent: Friday, October 27, 2017 1:33 PM
To: [login to unmask email]
Subject: [DB2-L] - [OT] What Db2 / database topics are important to learn (today)?

Dear Esteemed List,

I am writing a book based on my experiences with a multitude of database packages over several decades, including IMS, DB2 and Db2. It is meant to be both humorous and instructive, a combination of musings and lessons learned. Not a DBA guide per se, nor a manual or textbook. Perhaps best described as a collection of stories on useful topics.

However, since I've been away from the daily DBA/DB2/Db2 grind for over a year it suddenly struck me that I may (horrors!), without knowing it, be totally out-of-touch with what database administrators and developers need to know now and in the future.

What do DBAs need to know? Relational DB theory? How best to implement business rules and data constraints? SQL syntax (for correct use of outer joins, NOT (or not), tuning, etc.)? Interfaces and APIs? Big data considerations? Cloud? Data federation? Or won't DBAs exist in the future due to autonomics, etc.?

I would appreciate any and all ideas anyone has regarding what to include in such a book.

As your ideas may not be strictly relevant to the list, I've marked the post Off Topic. Listers may respond to me directly if they wish.

Thanks!

- Lock Lyon ([login to unmask email]<mailto:[login to unmask email]>)



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

David Baldon

[OT] What Db2 / database topics are important to learn (today)?
(in response to Philip Sevetson)
I’m always suspicious of posts that start with “Esteemed List”…lol ��

From: Sevetson, Phil [mailto:[login to unmask email]
Sent: Friday, October 27, 2017 1:00 PM
To: '[login to unmask email]' <[login to unmask email]>
Subject: [DB2-L] - RE: [OT] What Db2 / database topics are important to learn (today)?

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

So… you don’t think small, do you?

Someone, and it might have been Craig Mullins, elucidated a seven (?) layer hierarchy of database purposes. The bottom layer is “recoverability,” and I think the second layer is “security” and the third “availability.” I’m not sure on anything except the bottom. But it’s the fundamental justification for using a database to store things, and I think any reinventing-the-wheel discussion of data and database needs to start with that.

Also, there’s the general “why do you use a database?” - http://databasemanagement.wikia.com/wiki/DBMS_Functions https://urldefense.proofpoint.com/v2/url?u=http-3A__databasemanagement.wikia.com_wiki_DBMS-5FFunctions&d=DwMFaQ&c=UrUhmHsiTVT5qkaA4d_oSzcamb9hmamiCDMzBAEwC7E&r=KigCN-TlaQoAQDZrna0ZVLUX9H9vZpSibySEyujWvHQ&m=i9lq1W_EcBtfk-udjpa2zZ-fwvehpXdLczbJS50rrFE&s=pL-yLcs0xSF7eFTDVb7QHrBweot2h3kDA3DNdxchMQI&e=

That’s all fundamentals. For brand-spanking-new stuff? Managing extreme storage requirements, understanding how new machine-learning and data-science practices are going to change what we’re expected to provide.

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: Lock Lyon [mailto:[login to unmask email]
Sent: Friday, October 27, 2017 1:33 PM
To: [login to unmask email]<mailto:[login to unmask email]>
Subject: [DB2-L] - [OT] What Db2 / database topics are important to learn (today)?

Dear Esteemed List,

I am writing a book based on my experiences with a multitude of database packages over several decades, including IMS, DB2 and Db2. It is meant to be both humorous and instructive, a combination of musings and lessons learned. Not a DBA guide per se, nor a manual or textbook. Perhaps best described as a collection of stories on useful topics.

However, since I've been away from the daily DBA/DB2/Db2 grind for over a year it suddenly struck me that I may (horrors!), without knowing it, be totally out-of-touch with what database administrators and developers need to know now and in the future.

What do DBAs need to know? Relational DB theory? How best to implement business rules and data constraints? SQL syntax (for correct use of outer joins, NOT (or not), tuning, etc.)? Interfaces and APIs? Big data considerations? Cloud? Data federation? Or won't DBAs exist in the future due to autonomics, etc.?

I would appreciate any and all ideas anyone has regarding what to include in such a book.

As your ideas may not be strictly relevant to the list, I've marked the post Off Topic. Listers may respond to me directly if they wish.

Thanks!

- Lock Lyon ([login to unmask email]<mailto:[login to unmask email]>)



-----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.**
________________________________
Attachment Links: image001.png (3 k) https://urldefense.proofpoint.com/v2/url?u=http-3A__www.idug.org_p_fo_do_-3Fdownload-3D1-26fid-3D8878&d=DwMFaQ&c=UrUhmHsiTVT5qkaA4d_oSzcamb9hmamiCDMzBAEwC7E&r=KigCN-TlaQoAQDZrna0ZVLUX9H9vZpSibySEyujWvHQ&m=i9lq1W_EcBtfk-udjpa2zZ-fwvehpXdLczbJS50rrFE&s=KPLUbacFfwb-mape_jpvV4qGDMGPaFIi_-Y-r8eKcGQ&e=
Site Links: View post online https://urldefense.proofpoint.com/v2/url?u=http-3A__www.idug.org_p_fo_st_-3Fpost-3D183515-26anc-3Dp183515-23p183515&d=DwMFaQ&c=UrUhmHsiTVT5qkaA4d_oSzcamb9hmamiCDMzBAEwC7E&r=KigCN-TlaQoAQDZrna0ZVLUX9H9vZpSibySEyujWvHQ&m=i9lq1W_EcBtfk-udjpa2zZ-fwvehpXdLczbJS50rrFE&s=qhGX10boVMjx3pWB5F72f60XcqVzxG5L_PECI2a7CIA&e= View mailing list online https://urldefense.proofpoint.com/v2/url?u=http-3A__www.idug.org_p_fo_si_-3Ftopic-3D19&d=DwMFaQ&c=UrUhmHsiTVT5qkaA4d_oSzcamb9hmamiCDMzBAEwC7E&r=KigCN-TlaQoAQDZrna0ZVLUX9H9vZpSibySEyujWvHQ&m=i9lq1W_EcBtfk-udjpa2zZ-fwvehpXdLczbJS50rrFE&s=7jB5PzxvWws6ZD1O_hSZfP50r99Nii4aec-1s9myF08&e= Start new thread via email<mailto:[login to unmask email]> Unsubscribe from this mailing list<mailto:[login to unmask email]?Subject=Unsubscribe> Manage your subscription https://urldefense.proofpoint.com/v2/url?u=http-3A__www.idug.org_p_us_to_&d=DwMFaQ&c=UrUhmHsiTVT5qkaA4d_oSzcamb9hmamiCDMzBAEwC7E&r=KigCN-TlaQoAQDZrna0ZVLUX9H9vZpSibySEyujWvHQ&m=i9lq1W_EcBtfk-udjpa2zZ-fwvehpXdLczbJS50rrFE&s=UODWjeJz5epxyScfJQRF6FDtOL0I8G31LZfCHnTB0UU&e=

This email has been sent to: [login to unmask email]<mailto:[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 https://urldefense.proofpoint.com/v2/url?u=http-3A__www.ESAIGroup.com_idug&d=DwMFaQ&c=UrUhmHsiTVT5qkaA4d_oSzcamb9hmamiCDMzBAEwC7E&r=KigCN-TlaQoAQDZrna0ZVLUX9H9vZpSibySEyujWvHQ&m=i9lq1W_EcBtfk-udjpa2zZ-fwvehpXdLczbJS50rrFE&s=KAqpdmxZxSxFQ6A6eLBu49rRSHV1KYf3-cRHI0mP4G8&e=

Use of this email content is governed by the terms of service at:
http://www.idug.org/p/cm/ld/fid=2 https://urldefense.proofpoint.com/v2/url?u=http-3A__www.idug.org_p_cm_ld_fid-3D2&d=DwMFaQ&c=UrUhmHsiTVT5qkaA4d_oSzcamb9hmamiCDMzBAEwC7E&r=KigCN-TlaQoAQDZrna0ZVLUX9H9vZpSibySEyujWvHQ&m=i9lq1W_EcBtfk-udjpa2zZ-fwvehpXdLczbJS50rrFE&s=WJmuyqWwGqOBTnNuwzyXcH6zYEKJ3OjE8IAhdyXVn6o&e=

________________________________
Attachments

  • image001.png (3.3k)

Lockwood Lyon

[OT] What Db2 / database topics are important to learn (today)?
(in response to Philip Sevetson)
Phil,

I did the "Four Laws of Database Administration" back in 2006 (!). They were, in order of importance:

Recoverability
Availability
Security
Performance

If Craig published an updated 7-layer version, I'd love to see it.

Thanks for your ideas.

- Lock

From: Sevetson, Phil [mailto:[login to unmask email]
Sent: Friday, October 27, 2017 2:00 PM
To: '[login to unmask email]'
Subject: [DB2-L] - RE: [OT] What Db2 / database topics are important to learn (today)?

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

So… you don’t think small, do you?

Someone, and it might have been Craig Mullins, elucidated a seven (?) layer hierarchy of database purposes. The bottom layer is “recoverability,” and I think the second layer is “security” and the third “availability.” I’m not sure on anything except the bottom. But it’s the fundamental justification for using a database to store things, and I think any reinventing-the-wheel discussion of data and database needs to start with that.

Also, there’s the general “why do you use a database?” - http://databasemanagement.wikia.com/wiki/DBMS_Functions

That’s all fundamentals. For brand-spanking-new stuff? Managing extreme storage requirements, understanding how new machine-learning and data-science practices are going to change what we’re expected to provide.

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

Attachments

  • image001.png (3.3k)