DB2 Dying on OS390?

[ML]

I have recently been looking on dice.com (and other sites) and noticed
a striking difference in the number of listings for DB2 DBAs for the
OS390 platform. Most of the listings are AIX.

Anyone else notice this? Also, is DB2 on OS390 dying?

--
ML

[Serge Rielau]

ML wrote:

I have recently been looking on dice.com (and other sites) and noticed
a striking difference in the number of listings for DB2 DBAs for the
OS390 platform. Most of the listings are AIX.

Anyone else notice this? Also, is DB2 on OS390 dying?

Not according to last years revenue numbers...

It's by design that DB2 for LUW gains compared to DB2 for zOS.
After all DB2 for LUW was 0% 15 years ago...

I find job postings to have a very high variance. It's hard to derive a
strict correlation just by looking at a few months or even a year.

Cheers
Serge

PS: Could it be that the search criteria is 390? It's zOS now...

--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab

[Mark A]

"ML" <li*********@gmail.comwrote in message
news:11**********************@k78g2000cwa.googlegr oups.com...

>I have recently been looking on dice.com (and other sites) and noticed
a striking difference in the number of listings for DB2 DBAs for the
OS390 platform. Most of the listings are AIX.

Anyone else notice this? Also, is DB2 on OS390 dying?
--
ML

Actually the number of DBA jobs for DB2 OS/390 is growing because the DBA's
are dying.

[Serge Rielau]

Mark A wrote:

"ML" <li*********@gmail.comwrote in message
news:11**********************@k78g2000cwa.googlegr oups.com...

>I have recently been looking on dice.com (and other sites) and noticed
a striking difference in the number of listings for DB2 DBAs for the
OS390 platform. Most of the listings are AIX.

Anyone else notice this? Also, is DB2 on OS390 dying?
--
ML

Actually the number of DBA jobs for DB2 OS/390 is growing because the DBA's
are dying.

*lol*I think it's called "freedom 55"
--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab

[ML]

On Feb 18, 4:55 pm, Serge Rielau <[e-mail]:

ML wrote:

I have recently been looking on dice.com (and other sites) and noticed
a striking difference in the number of listings for DB2 DBAs for the
OS390 platform. Most of the listings are AIX.

Anyone else notice this? Also, is DB2 on OS390 dying?

Not according to last years revenue numbers...

It's by design that DB2 for LUW gains compared to DB2 for zOS.
After all DB2 for LUW was 0% 15 years ago...

I find job postings to have a very high variance. It's hard to derive a
strict correlation just by looking at a few months or even a year.

Cheers
Serge

PS: Could it be that the search criteria is 390? It's zOS now...

--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab

Yes, I included zOS in searches. The bottom line is that right now
there are BY FAR more listings for DB2 on AIX than OS/390 or zOS. In
addition, the former of the two is sparce with listings.

--
ML

[ML]

On Feb 19, 7:24 am, "ML" <[e-mail]:

On Feb 18, 4:55 pm, Serge Rielau <[e-mail]:

ML wrote:

I have recently been looking on dice.com (and other sites) and noticed
a striking difference in the number of listings for DB2 DBAs for the
OS390 platform. Most of the listings are AIX.

Anyone else notice this? Also, is DB2 on OS390 dying?

Not according to last years revenue numbers...

It's by design that DB2 for LUW gains compared to DB2 for zOS.
After all DB2 for LUW was 0% 15 years ago...

I find job postings to have a very high variance. It's hard to derive a
strict correlation just by looking at a few months or even a year.

Cheers
Serge

PS: Could it be that the search criteria is 390? It's zOS now...

--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab

Yes, I included zOS in searches. The bottom line is that right now
there are BY FAR more listings for DB2 on AIX than OS/390 or zOS. In
addition, the former of the two is sparce with listings.

--
ML

Should read "the latter of the two".

--
ML

[Tonkuma]

Please see follwing sites. They include DB2 for LUW and DB2 for z/OS.
But, I feel there are equal or more articles and discussions about DB2
for z/OS in these sites.
IDUG(International DB2 User Group)
http://www.idug.org/wps/portal/idug
DB2 Magazine
http://www.db2mag.com/

[Mark A]

"ML" <li*********@gmail.comwrote in message
news:11*********************@m58g2000cwm.googlegro ups.com...

Yes, I included zOS in searches. The bottom line is that right now
there are BY FAR more listings for DB2 on AIX than OS/390 or zOS. In
addition, the former of the two is sparce with listings.
--
ML

There may be more job "openings" for DB2 on Linux, UNIX, Windows (LUW) than
for DB2 on OS/390 and z/OS, but that does not mean that there are more jobs
for DB2 LUW. The turnover rate (and suicide rate) for DBA's on DBA for LUW
is much higher because it does not have these civilized features available
in DB2 for z/OS:

1. Alter Index, especially to make an index clustered.

2. Unique index that can be made to allow nulls.

3. A way to start a database in read-only mode.

[Anurag]

On Feb 18, 9:02 pm, "ML" <[e-mail]:

I have recently been looking on dice.com (and other sites) and noticed
a striking difference in the number of listings for DB2 DBAs for the
OS390 platform. Most of the listings are AIX.

Anyone else notice this? Also, is DB2 on OS390 dying?

--
ML

I will put it this way - "DBAs for DB2 on OS390 are dying"; they are a
rare and most sought after breed.
My company cannot expand its OS390 DBA team because you do not find a
DBA pool;
whereas DB2 on LUW team is making merry because you are able to find
LUW DBAs (of course, there is work on distributed platform).

-- anurag

[Serge Rielau]

Mark A wrote:

"ML" <li*********@gmail.comwrote in message
news:11*********************@m58g2000cwm.googlegro ups.com...

>Yes, I included zOS in searches. The bottom line is that right now
there are BY FAR more listings for DB2 on AIX than OS/390 or zOS. In
addition, the former of the two is sparce with listings.
--
ML

There may be more job "openings" for DB2 on Linux, UNIX, Windows (LUW) than
for DB2 on OS/390 and z/OS, but that does not mean that there are more jobs
for DB2 LUW. The turnover rate (and suicide rate) for DBA's on DBA for LUW
is much higher because it does not have these civilized features available
in DB2 for z/OS:

1. Alter Index, especially to make an index clustered.

2. Unique index that can be made to allow nulls.

3. A way to start a database in read-only mode.

Uh a DB2 vs DB2 flame war.... ;-)

Cheers
Serge
--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab

[Mark A]

"Serge Rielau" <sr*****@ca.ibm.comwrote in message
news:53*************@mid.individual.net...

Uh a DB2 vs DB2 flame war.... ;-)

Cheers
Serge
--
Serge Rielau

No flame war. These problems could be easily fixed.

[Mark A]

"Anurag" <an**********@gmail.comwrote in message
news:11********************@k78g2000cwa.googlegrou ps.com...

I will put it this way - "DBAs for DB2 on OS390 are dying"; they are a
rare and most sought after breed.
My company cannot expand its OS390 DBA team because you do not find a
DBA pool;
whereas DB2 on LUW team is making merry because you are able to find
LUW DBAs (of course, there is work on distributed platform).

-- anurag

How about someone who is an IBM Certified DBA on LUW and z/OS? (like me).

[BobTheDataBaseBoy]

ML wrote:

I have recently been looking on dice.com (and other sites) and noticed
a striking difference in the number of listings for DB2 DBAs for the
OS390 platform. Most of the listings are AIX.

Anyone else notice this? Also, is DB2 on OS390 dying?

--
ML

well, yes and no. some of the replies are along the lines of "z/OS
brings in more money". that was sortta true last time I looked. it is
also true that this is generated from far, far fewer installations.
now, those z/OS installations *tend* to be populated with hoary COBOL
programmers who use DB2 as a file surrogate, and where the "DBA" was/is
one of said COBOL programmers. this is absolutely true in the financial
services industry, where I currently toil. it's worth noting that DB2
is about the only database that is allowed in the mainframe world. once
IBM has gotten all of those 1970s VSAM systems switched over, there
won't be much left to do. I never seen any info on how much *new*
development is happening on Z machines running z/OS, either from IBM or
the usual sources. doesn't surprise me.

so, what a DBA in the z/OS world tends to do is back up the "files" then
run a "job". not much more. stored procedures, functions,
normalization, database design (all that database stuff; woe betide the
DBA that tries to enforce naming requirements on a herd of COBOL
programmers): nope.

in the *nix world, on the other hand, database design and the like is
more frequent. sometimes referred to as green fields work.

in the end, it depends on what you want to do as a DBA: back up files
and run jobs, or take an active part in databased systems development.

[Mark Townsend]

Serge Rielau wrote:

>
I find job postings to have a very high variance. It's hard to derive a
strict correlation just by looking at a few months or even a year.

Hmm - I have been using job postings as a measure of tracking popularity
for over a decade and I definitely think they provide a good
correlation. Why do you think they have very high variance ?

[Mark A]

"Mark Townsend" <ma***********@sbcglobal.netwrote in message
news:45************@sbcglobal.net...

Hmm - I have been using job postings as a measure of tracking popularity
for over a decade and I definitely think they provide a good correlation.
Why do you think they have very high variance ?

One reason may be that job openings are also a reflection of job turnover,
not just popularity.

[DA Morgan]

Mark A wrote:

"ML" <li*********@gmail.comwrote in message
news:11*********************@m58g2000cwm.googlegro ups.com...

>Yes, I included zOS in searches. The bottom line is that right now
there are BY FAR more listings for DB2 on AIX than OS/390 or zOS. In
addition, the former of the two is sparce with listings.
--
ML

There may be more job "openings" for DB2 on Linux, UNIX, Windows (LUW) than
for DB2 on OS/390 and z/OS, but that does not mean that there are more jobs
for DB2 LUW. The turnover rate (and suicide rate) for DBA's on DBA for LUW
is much higher because it does not have these civilized features available
in DB2 for z/OS:

1. Alter Index, especially to make an index clustered.

2. Unique index that can be made to allow nulls.

3. A way to start a database in read-only mode.

Thanks ... I needed that. ;-)
--
Daniel A. Morgan
University of Washington
da******@x.washington.edu
(replace x with u to respond)

[Mark A]

"DA Morgan" <da******@psoug.orgwrote in message
news:11***************@bubbleator.drizzle.com...

Thanks ... I needed that. ;-)
--
Daniel A. Morgan

Don't get too excited, because Oracle does not even have clustered indexes
in the same way that DB2 has.

Oracle does have Index Ordered Tables (too expensive to maintain if you have
even moderate insert or update activity). Oracle table clustering is similar
in theory to DB2's MDC (Multi-Dimensional Clustering), but MDC is much
better.