IBM Data Server Manager

Daniel Luksetich

IBM Data Server Manager
Folks,

Data Server Manager is the next generation free tool for DB2 for LUW. Get an
overview at the IDUG web site.

http://bit.ly/1CKYNTW


Daniel L Luksetich
DanL Database Consulting

IBM GOLD Consultant
IBM Champion for Data Management
IDUG Content Committee Chairman
IBM Certified Database Administrator - DB2 11 DBA for z/OS
IBM Certified System Administrator - DB2 11 DBA 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

http://www.db2expert.com http://www.db2expert.com

<https://www.ibm.com/developerworks/mydeveloperworks/profiles/user/DanLukset
ich>
http://www.ibm.com/developerworks/mydeveloperworks/profiles/user/DanLuksetic
h



Philip Sevetson

IBM Data Server Manager
(in response to Daniel Luksetich)
Dan,
Any relevance for the z/OS crowd?

--Phil Sevetson
[login to unmask email]<mailto:[login to unmask email]>
City of New York / Financial Info Svcs Agcy
New York, NY USA 10001

From: Daniel L Luksetich [mailto:[login to unmask email]
Sent: Monday, July 20, 2015 7:10 AM
To: [login to unmask email]
Subject: [DB2-L] - IBM Data Server Manager

Folks,

Data Server Manager is the next generation free tool for DB2 for LUW. Get an overview at the IDUG web site.

http://bit.ly/1CKYNTW


Daniel L Luksetich
DanL Database Consulting

IBM GOLD Consultant
IBM Champion for Data Management
IDUG Content Committee Chairman
IBM Certified Database Administrator - DB2 11 DBA for z/OS
IBM Certified System Administrator - DB2 11 DBA 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

http://www.db2expert.comhttp://www.db2expert.com
http://www.ibm.com/developerworks/mydeveloperworks/profiles/user/DanLuksetich<https://www.ibm.com/developerworks/mydeveloperworks/profiles/user/DanLuksetich>




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

Daniel Luksetich

IBM Data Server Manager
(in response to Philip Sevetson)


Phil,

As for now IBM Data Studio is the tool for the z/OS crowd, and still
very relevant for LUW. We'll have at least one, probably two articles on
Data Studio next week relative to z/OS as well as DB2 for LUW. I'm
afraid I can't say for certain what the future holds for these tools,
but I can give you my opinion. I see Data Studio having legs for at
least the next couple of years, especially on the z/OS side of things.
If Data Server manager sticks I can imagine an eventual migration to
that from Data Studio. That is absolutely just my opinion.

Cheers,

Dan

On 07.20.2015 07:21, Sevetson, Phil wrote:

> Dan,
>
> Any relevance for the z/OS crowd?
>
> --Phil Sevetson
>
> [login to unmask email]
>
> City of New York / Financial Info Svcs Agcy
>
> New York, NY USA 10001
>
> FROM: Daniel L Luksetich [mailto:[login to unmask email]
> SENT: Monday, July 20, 2015 7:10 AM
> TO: [login to unmask email]
> SUBJECT: [DB2-L] - IBM Data Server Manager
>
> Folks,
>
> Data Server Manager is the next generation free tool for DB2 for LUW. Get an overview at the IDUG web site.
>
> http://bit.ly/1CKYNTW [1]
>
> Daniel L Luksetich
>
> DanL Database Consulting
>
> IBM GOLD Consultant
>
> IBM Champion for Data Management
>
> IDUG Content Committee Chairman
>
> IBM Certified Database Administrator - DB2 11 DBA for z/OS
>
> IBM Certified System Administrator - DB2 11 DBA 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
>
> http://www.db2expert.com [2]
>
> http://www.ibm.com/developerworks/mydeveloperworks/profiles/user/DanLuksetich [3]
>
> -----End Original Message-----
>
> -----End Original Message-----


Links:
------
[1] http://bit.ly/1CKYNTW
[2] http://www.db2expert.com/
[3]
https://www.ibm.com/developerworks/mydeveloperworks/profiles/user/DanLuksetich
[4] http://www.idug.org/p/fo/st/post=170730&amp;anc=p170730#p170730
[5] http://www.idug.org/p/fo/si/topic=19
[6] http://www.idug.org/p/us/to/
[7] http://www.idug.org/p/cm/ld/fid=586
[8] http://www.idug.org/p/cm/ld/fid=2

Kirk Hampton

IBM Data Server Manager
(in response to Daniel Luksetich)
Hi Dan,
I just saw a presentation last week at our RUG meeting,
where I thought I understood that Data Server Manager
was the latest follow-on/replacement for Data Studio ?
Did I just get the wrong impression? Come to think of it,
I’m not sure if they specifically mentioned z/OS, but that’s
largely the demographic of our RUG, so I just assumed….

Thanks,

J. Kirk Hampton
DB2 z/OS Sysprog
HCL America
Dallas, Texas
(Unwept, Unhonor'd, and Unsung)


From: Daniel Luksetich [mailto:[login to unmask email]
Sent: Monday, July 20, 2015 9:30 AM
To: [login to unmask email]
Subject: [DB2-L] - RE: IBM Data Server Manager


Phil,

As for now IBM Data Studio is the tool for the z/OS crowd, and still very relevant for LUW. We'll have at least one, probably two articles on Data Studio next week relative to z/OS as well as DB2 for LUW. I'm afraid I can't say for certain what the future holds for these tools, but I can give you my opinion. I see Data Studio having legs for at least the next couple of years, especially on the z/OS side of things. If Data Server manager sticks I can imagine an eventual migration to that from Data Studio. That is absolutely just my opinion.

Cheers,

Dan




On 07.20.2015 07:21, Sevetson, Phil wrote:
Dan,
Any relevance for the z/OS crowd?

--Phil Sevetson
[login to unmask email]<mailto:[login to unmask email]>
City of New York / Financial Info Svcs Agcy
New York, NY USA 10001

From: Daniel L Luksetich [mailto:[login to unmask email]
Sent: Monday, July 20, 2015 7:10 AM
To: [login to unmask email]
Subject: [DB2-L] - IBM Data Server Manager

Folks,

Data Server Manager is the next generation free tool for DB2 for LUW. Get an overview at the IDUG web site.

http://bit.ly/1CKYNTW


Daniel L Luksetich
DanL Database Consulting

IBM GOLD Consultant
IBM Champion for Data Management
IDUG Content Committee Chairman
IBM Certified Database Administrator - DB2 11 DBA for z/OS
IBM Certified System Administrator - DB2 11 DBA 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

http://www.db2expert.comhttp://www.db2expert.com
http://www.ibm.com/developerworks/mydeveloperworks/profiles/user/DanLuksetich<https://www.ibm.com/developerworks/mydeveloperworks/profiles/user/DanLuksetich>




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

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

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


::DISCLAIMER::
----------------------------------------------------------------------------------------------------------------------------------------------------

The contents of this e-mail and any attachment(s) are confidential and intended for the named recipient(s) only.
E-mail transmission is not guaranteed to be secure or error-free as information could be intercepted, corrupted,
lost, destroyed, arrive late or incomplete, or may contain viruses in transmission. The e mail and its contents
(with or without referred errors) shall therefore not attach any liability on the originator or HCL or its affiliates.
Views or opinions, if any, presented in this email are solely those of the author and may not necessarily reflect the
views or opinions of HCL or its affiliates. Any form of reproduction, dissemination, copying, disclosure, modification,
distribution and / or publication of this message without the prior written consent of authorized representative of
HCL is strictly prohibited. If you have received this email in error please delete it and notify the sender immediately.
Before opening any email and/or attachments, please check them for viruses and other defects.

----------------------------------------------------------------------------------------------------------------------------------------------------

Daniel Luksetich

IBM Data Server Manager
(in response to Kirk Hampton)


I think you did get the right impression. I cannot speak for IBM but DSM
seems to be the direction for LUW, and one could assume eventually for
z/OS. That is only my opinion.

Thanks,

Dan

On 07.20.2015 08:27, James Hampton, HCL America wrote:

> Hi Dan,
>
> I just saw a presentation last week at our RUG meeting,
>
> where I thought I understood that Data Server Manager
>
> was the latest follow-on/replacement for Data Studio ?
>
> Did I just get the wrong impression? Come to think of it,
>
> I'm not sure if they specifically mentioned z/OS, but that's
>
> largely the demographic of our RUG, so I just assumed....
>
> Thanks,
>
> J. Kirk Hampton
>
> DB2 z/OS Sysprog
>
> HCL America
>
> Dallas, Texas
>
> (Unwept, Unhonor'd, and Unsung)
>
> FROM: Daniel Luksetich [mailto:[login to unmask email]
> SENT: Monday, July 20, 2015 9:30 AM
> TO: [login to unmask email]
> SUBJECT: [DB2-L] - RE: IBM Data Server Manager
>
> Phil,
>
> As for now IBM Data Studio is the tool for the z/OS crowd, and still very relevant for LUW. We'll have at least one, probably two articles on Data Studio next week relative to z/OS as well as DB2 for LUW. I'm afraid I can't say for certain what the future holds for these tools, but I can give you my opinion. I see Data Studio having legs for at least the next couple of years, especially on the z/OS side of things. If Data Server manager sticks I can imagine an eventual migration to that from Data Studio. That is absolutely just my opinion.
>
> Cheers,
>
> Dan
>
> On 07.20.2015 07:21, Sevetson, Phil wrote:
>
>> Dan,
>>
>> Any relevance for the z/OS crowd?
>>
>> --Phil Sevetson
>>
>> [login to unmask email]
>>
>> City of New York / Financial Info Svcs Agcy
>>
>> New York, NY USA 10001
>>
>> FROM: Daniel L Luksetich [mailto:[login to unmask email]
>> SENT: Monday, July 20, 2015 7:10 AM
>> TO: [login to unmask email]
>> SUBJECT: [DB2-L] - IBM Data Server Manager
>>
>> Folks,
>>
>> Data Server Manager is the next generation free tool for DB2 for LUW. Get an overview at the IDUG web site.
>>
>> http://bit.ly/1CKYNTW [1]
>>
>> Daniel L Luksetich
>>
>> DanL Database Consulting
>>
>> IBM GOLD Consultant
>>
>> IBM Champion for Data Management
>>
>> IDUG Content Committee Chairman
>>
>> IBM Certified Database Administrator - DB2 11 DBA for z/OS
>>
>> IBM Certified System Administrator - DB2 11 DBA 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
>>
>> http://www.db2expert.com [2]
>>
>> http://www.ibm.com/developerworks/mydeveloperworks/profiles/user/DanLuksetich [3]
>>
>> -----End Original Message-----
>>
>> -----End Original Message-----
>
> -----End Original Message-----
>
> ::DISCLAIMER::
> ----------------------------------------------------------------------------------------------------------------------------------------------------
>
> The contents of this e-mail and any attachment(s) are confidential and intended for the named recipient(s) only.
> E-mail transmission is not guaranteed to be secure or error-free as information could be intercepted, corrupted,
> lost, destroyed, arrive late or incomplete, or may contain viruses in transmission. The e mail and its contents
> (with or without referred errors) shall therefore not attach any liability on the originator or HCL or its affiliates.
> Views or opinions, if any, presented in this email are solely those of the author and may not necessarily reflect the
> views or opinions of HCL or its affiliates. Any form of reproduction, dissemination, copying, disclosure, modification,
> distribution and / or publication of this message without the prior written consent of authorized representative of
> HCL is strictly prohibited. If you have received this email in error please delete it and notify the sender immediately.
> Before opening any email and/or attachments, please check them for viruses and other defects.
>
> ----------------------------------------------------------------------------------------------------------------------------------------------------
>
> -----End Original Message-----


Links:
------
[1] http://bit.ly/1CKYNTW
[2] http://www.db2expert.com/
[3]
https://www.ibm.com/developerworks/mydeveloperworks/profiles/user/DanLuksetich
[4] http://www.idug.org/p/fo/st/post=170732&amp;anc=p170732#p170732
[5] http://www.idug.org/p/fo/si/topic=19
[6] http://www.idug.org/p/us/to/
[7] http://www.idug.org/p/cm/ld/fid=586
[8] http://www.idug.org/p/cm/ld/fid=2

Philip Nelson

IBM Data Server Manager
(in response to Philip Sevetson)
While only currently for LUW you can expect z functionality to come along
before long.

So worth keeping a watching brief on it.
On 20 Jul 2015 15:21, "Sevetson, Phil" <[login to unmask email]> wrote:

> Dan,
>
> Any relevance for the z/OS crowd?
>
>
>
> --Phil Sevetson
>
> [login to unmask email]
>
> City of New York / Financial Info Svcs Agcy
>
> New York, NY USA 10001
>
>
>
> *From:* Daniel L Luksetich [mailto:[login to unmask email]
> *Sent:* Monday, July 20, 2015 7:10 AM
> *To:* [login to unmask email]
> *Subject:* [DB2-L] - IBM Data Server Manager
>
>
>
> Folks,
>
>
>
> Data Server Manager is the next generation free tool for DB2 for LUW. Get
> an overview at the IDUG web site.
>
>
>
> http://bit.ly/1CKYNTW
>
>
>
>
>
> Daniel L Luksetich
>
> DanL Database Consulting
>
>
>
> IBM GOLD Consultant
>
> IBM Champion for Data Management
>
> IDUG Content Committee Chairman
>
> IBM Certified Database Administrator - DB2 11 DBA for z/OS
>
> IBM Certified System Administrator - DB2 11 DBA 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
>
>
>
> http://www.db2expert.com
>
>
> http://www.ibm.com/developerworks/mydeveloperworks/profiles/user/DanLuksetich
> <https://www.ibm.com/developerworks/mydeveloperworks/profiles/user/DanLuksetich>
>
>
>
>
>
>
>
>
> -----End Original Message-----
>
> -----End Original Message-----
>

Daniel Luksetich

IBM Data Server Manager
(in response to Daniel Luksetich)
All,

I like to think that I'm a pretty good DBA, and not to shabby at other IT
related technical bits. I've been using IBM Data Studio for many years, and
still use it extensively every single day for management of both Db2 for LUW
and Db2 for z/OS databases. I have been told many times that IBM Data Serer
Manager is the future, and yet every time I attempt to install and configure
IBM Data Server Manager it is a futile exercise. I find the product pretty
much completely useless and unconfigurable. I'm currently on my nth attempt
and am looking at an infinitely spinning donut. Has any one got this product
to actually work, and if so can you guide my to some legitimate
configuration and trouble shooting guides? It shouldn't be that difficult. I
have two Db2 for z/OS connections, one is secure. I have no problems with
that. I've got the connections going, but the navigation and functionality
is stupid at best. I'm attempting to establish connections to a local Db2
for LUW using a secure connection, and it just doesn't work. IBM Data Studio
was 2 minutes to configure the same connection, and so I don't think I'm
defining the connection incorrectly.



Thanks in advance.



Dan



Daniel L Luksetich

DanL Database Consulting



IBM GOLD Consultant

IBM Champion for Analytics

IDUG Content Committee Past-Chairman

IDUG DB2-L Administrator

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



David Simpson

IBM Data Server Manager
(in response to Daniel Luksetich)
I have no advice to give but I'll follow this thread with interest :-)

On May 16, 2019 11:22 AM, Daniel L Luksetich <[login to unmask email]> wrote:
All,
I like to think that I’m a pretty good DBA, and not to shabby at other IT related technical bits. I’ve been using IBM Data Studio for many years, and still use it extensively every single day for management of both Db2 for LUW and Db2 for z/OS databases. I have been told many times that IBM Data Serer Manager is the future, and yet every time I attempt to install and configure IBM Data Server Manager it is a futile exercise. I find the product pretty much completely useless and unconfigurable. I’m currently on my nth attempt and am looking at an infinitely spinning donut. Has any one got this product to actually work, and if so can you guide my to some legitimate configuration and trouble shooting guides? It shouldn’t be that difficult. I have two Db2 for z/OS connections, one is secure. I have no problems with that. I’ve got the connections going, but the navigation and functionality is stupid at best. I’m attempting to establish connections to a local Db2 for LUW using a secure connection, and it just doesn’t work. IBM Data Studio was 2 minutes to configure the same connection, and so I don’t think I’m defining the connection incorrectly.

Thanks in advance.

Dan

Daniel L Luksetich
DanL Database Consulting

IBM GOLD Consultant
IBM Champion for Analytics
IDUG Content Committee Past-Chairman
IDUG DB2-L Administrator
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


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

Bill Gallagher

[External] IBM Data Server Manager
(in response to Daniel Luksetich)
I was able to install and configure it two jobs ago, maybe 4 years ago or so, but I found it completely useless. After kicking the tires with it for a few days, I stopped using it and have never gone back.

Granted, it was an early version of the product, but I found close to zero value in using it.

Bill Gallagher | Senior Systems Engineer, DBA | Data Administration


From: Daniel L Luksetich <[login to unmask email]>
Sent: Thursday, May 16, 2019 12:23 PM
To: [login to unmask email]
Subject: [External] [DB2-L] - IBM Data Server Manager

All,
I like to think that I'm a pretty good DBA, and not to shabby at other IT related technical bits. I've been using IBM Data Studio for many years, and still use it extensively every single day for management of both Db2 for LUW and Db2 for z/OS databases. I have been told many times that IBM Data Serer Manager is the future, and yet every time I attempt to install and configure IBM Data Server Manager it is a futile exercise. I find the product pretty much completely useless and unconfigurable. I'm currently on my nth attempt and am looking at an infinitely spinning donut. Has any one got this product to actually work, and if so can you guide my to some legitimate configuration and trouble shooting guides? It shouldn't be that difficult. I have two Db2 for z/OS connections, one is secure. I have no problems with that. I've got the connections going, but the navigation and functionality is stupid at best. I'm attempting to establish connections to a local Db2 for LUW using a secure connection, and it just doesn't work. IBM Data Studio was 2 minutes to configure the same connection, and so I don't think I'm defining the connection incorrectly.

Thanks in advance.

Dan

Daniel L Luksetich
DanL Database Consulting

IBM GOLD Consultant
IBM Champion for Analytics
IDUG Content Committee Past-Chairman
IDUG DB2-L Administrator
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


-----End Original Message-----
________________________________
This message (including any attachments) may contain confidential, proprietary, privileged and/or private information. The information is intended to be for the use of the individual or entity designated above. If you are not the intended recipient of this message, please notify the sender immediately, and delete the message and any attachments. Any disclosure, reproduction, distribution or other use of this message or any attachments by an individual or entity other than the intended recipient is prohibited.

TRVDiscDefault::1201

Isaac Yassin

IBM Data Server Manager
(in response to Daniel Luksetich)
Ditto.
Tried the DSM few times. Gave up, totally frustrated.
Yes - I do have some misgivings about DS but it beats DSM when you need a
work done.

*Isaac Yassin *
*IBM Gold Consultant*
*IBM Champion for Analytics #ibmchampion*
IBM Certified Solution Expert
IBM Certified System Administrator - DB2 for Z/OS 10, 11, 12
IBM Certified Database Administrator - DB2 for Z/OS 9, 10, 11
IBM Certified Database Administrator - DB2 LUW 10.1
IBM Certified Specialist - PureData System for Analytics v7.1
IDUG Israel RUG co-Chair



On Thu, May 16, 2019 at 7:23 PM Daniel L Luksetich <[login to unmask email]>
wrote:

> All,
>
> I like to think that I’m a pretty good DBA, and not to shabby at other IT
> related technical bits. I’ve been using IBM Data Studio for many years, and
> still use it extensively every single day for management of both Db2 for
> LUW and Db2 for z/OS databases. I have been told many times that IBM Data
> Serer Manager is the future, and yet every time I attempt to install and
> configure IBM Data Server Manager it is a futile exercise. I find the
> product pretty much completely useless and unconfigurable. I’m currently on
> my nth attempt and am looking at an infinitely spinning donut. Has any one
> got this product to actually work, and if so can you guide my to some
> legitimate configuration and trouble shooting guides? It shouldn’t be that
> difficult. I have two Db2 for z/OS connections, one is secure. I have no
> problems with that. I’ve got the connections going, but the navigation and
> functionality is stupid at best. I’m attempting to establish connections to
> a local Db2 for LUW using a secure connection, and it just doesn’t work.
> IBM Data Studio was 2 minutes to configure the same connection, and so I
> don’t think I’m defining the connection incorrectly.
>
>
>
> Thanks in advance.
>
>
>
> Dan
>
>
>
> Daniel L Luksetich
>
> DanL Database Consulting
>
>
>
> IBM GOLD Consultant
>
> IBM Champion for Analytics
>
> IDUG Content Committee Past-Chairman
>
> IDUG DB2-L Administrator
>
> 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
>
>
>
> -----End Original Message-----
>

Daniel Luksetich

IBM Data Server Manager
(in response to Lance Jackson)
I don't think I can use TEP to write SQLPL routines, can I? Can I use it to
define and alter objects, and reverse engineer ERD's from my database? If
so, I'll give it a go.

Dan



Daniel L Luksetich

DanL Database Consulting



IBM GOLD Consultant

IBM Champion for Analytics

IDUG Content Committee Past-Chairman

IDUG DB2-L Administrator

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: Lance D. Jackson <[login to unmask email]>
Sent: Thursday, May 16, 2019 3:36 PM
To: [login to unmask email]
Subject: [DB2-L] - RE: IBM Data Server Manager



Daniel,



I had similar experiences w/ DSM. I suggest switching to Tivoli Enterprise
Portal (TEP) - I'm currently in the process of configuring it, and so far,
so satisfied.



Lance J.



From: Daniel L Luksetich <[login to unmask email] <mailto:[login to unmask email]>
>
Sent: Thursday, May 16, 2019 12:23
To: [login to unmask email] <mailto:[login to unmask email]>
Subject: [DB2-L] - IBM Data Server Manager



All,

I like to think that I'm a pretty good DBA, and not to shabby at other IT
related technical bits. I've been using IBM Data Studio for many years, and
still use it extensively every single day for management of both Db2 for LUW
and Db2 for z/OS databases. I have been told many times that IBM Data Serer
Manager is the future, and yet every time I attempt to install and configure
IBM Data Server Manager it is a futile exercise. I find the product pretty
much completely useless and unconfigurable. I'm currently on my nth attempt
and am looking at an infinitely spinning donut. Has any one got this product
to actually work, and if so can you guide my to some legitimate
configuration and trouble shooting guides? It shouldn't be that difficult. I
have two Db2 for z/OS connections, one is secure. I have no problems with
that. I've got the connections going, but the navigation and functionality
is stupid at best. I'm attempting to establish connections to a local Db2
for LUW using a secure connection, and it just doesn't work. IBM Data Studio
was 2 minutes to configure the same connection, and so I don't think I'm
defining the connection incorrectly.



Thanks in advance.



Dan



Daniel L Luksetich

DanL Database Consulting



IBM GOLD Consultant

IBM Champion for Analytics

IDUG Content Committee Past-Chairman

IDUG DB2-L Administrator

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





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



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

David Simpson

IBM Data Server Manager
(in response to Daniel Luksetich)
You can...

You'll want to do this, though... Setting the SQLFORMAT keeps it from all being placed on one line (will be better for explains and debugging later).

[cid:[login to unmask email]


From: Daniel L Luksetich <[login to unmask email]>
Sent: Thursday, May 16, 2019 12:17 PM
To: [login to unmask email]
Subject: [DB2-L] - RE: IBM Data Server Manager

I don't think I can use TEP to write SQLPL routines, can I? Can I use it to define and alter objects, and reverse engineer ERD's from my database? If so, I'll give it a go.
Dan

Daniel L Luksetich
DanL Database Consulting

IBM GOLD Consultant
IBM Champion for Analytics
IDUG Content Committee Past-Chairman
IDUG DB2-L Administrator
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: Lance D. Jackson <[login to unmask email]<mailto:[login to unmask email]>>
Sent: Thursday, May 16, 2019 3:36 PM
To: [login to unmask email]<mailto:[login to unmask email]>
Subject: [DB2-L] - RE: IBM Data Server Manager

Daniel,

I had similar experiences w/ DSM. I suggest switching to Tivoli Enterprise Portal (TEP) - I'm currently in the process of configuring it, and so far, so satisfied.

Lance J.

From: Daniel L Luksetich <[login to unmask email]<mailto:[login to unmask email]>>
Sent: Thursday, May 16, 2019 12:23
To: [login to unmask email]<mailto:[login to unmask email]>
Subject: [DB2-L] - IBM Data Server Manager

All,
I like to think that I'm a pretty good DBA, and not to shabby at other IT related technical bits. I've been using IBM Data Studio for many years, and still use it extensively every single day for management of both Db2 for LUW and Db2 for z/OS databases. I have been told many times that IBM Data Serer Manager is the future, and yet every time I attempt to install and configure IBM Data Server Manager it is a futile exercise. I find the product pretty much completely useless and unconfigurable. I'm currently on my nth attempt and am looking at an infinitely spinning donut. Has any one got this product to actually work, and if so can you guide my to some legitimate configuration and trouble shooting guides? It shouldn't be that difficult. I have two Db2 for z/OS connections, one is secure. I have no problems with that. I've got the connections going, but the navigation and functionality is stupid at best. I'm attempting to establish connections to a local Db2 for LUW using a secure connection, and it just doesn't work. IBM Data Studio was 2 minutes to configure the same connection, and so I don't think I'm defining the connection incorrectly.

Thanks in advance.

Dan

Daniel L Luksetich
DanL Database Consulting

IBM GOLD Consultant
IBM Champion for Analytics
IDUG Content Committee Past-Chairman
IDUG DB2-L Administrator
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


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

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

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

  • image001.png (61.1k)

David Simpson

IBM Data Server Manager
(in response to David Simpson)
Actually, please ignore... I misread the question.

From: David Simpson <[login to unmask email]>
Sent: Thursday, May 16, 2019 12:19 PM
To: [login to unmask email]
Subject: [DB2-L] - RE: IBM Data Server Manager

You can...

You'll want to do this, though... Setting the SQLFORMAT keeps it from all being placed on one line (will be better for explains and debugging later).

[cid:[login to unmask email]


From: Daniel L Luksetich <[login to unmask email]<mailto:[login to unmask email]>>
Sent: Thursday, May 16, 2019 12:17 PM
To: [login to unmask email]<mailto:[login to unmask email]>
Subject: [DB2-L] - RE: IBM Data Server Manager

I don't think I can use TEP to write SQLPL routines, can I? Can I use it to define and alter objects, and reverse engineer ERD's from my database? If so, I'll give it a go.
Dan

Daniel L Luksetich
DanL Database Consulting

IBM GOLD Consultant
IBM Champion for Analytics
IDUG Content Committee Past-Chairman
IDUG DB2-L Administrator
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: Lance D. Jackson <[login to unmask email]<mailto:[login to unmask email]>>
Sent: Thursday, May 16, 2019 3:36 PM
To: [login to unmask email]<mailto:[login to unmask email]>
Subject: [DB2-L] - RE: IBM Data Server Manager

Daniel,

I had similar experiences w/ DSM. I suggest switching to Tivoli Enterprise Portal (TEP) - I'm currently in the process of configuring it, and so far, so satisfied.

Lance J.

From: Daniel L Luksetich <[login to unmask email]<mailto:[login to unmask email]>>
Sent: Thursday, May 16, 2019 12:23
To: [login to unmask email]<mailto:[login to unmask email]>
Subject: [DB2-L] - IBM Data Server Manager

All,
I like to think that I'm a pretty good DBA, and not to shabby at other IT related technical bits. I've been using IBM Data Studio for many years, and still use it extensively every single day for management of both Db2 for LUW and Db2 for z/OS databases. I have been told many times that IBM Data Serer Manager is the future, and yet every time I attempt to install and configure IBM Data Server Manager it is a futile exercise. I find the product pretty much completely useless and unconfigurable. I'm currently on my nth attempt and am looking at an infinitely spinning donut. Has any one got this product to actually work, and if so can you guide my to some legitimate configuration and trouble shooting guides? It shouldn't be that difficult. I have two Db2 for z/OS connections, one is secure. I have no problems with that. I've got the connections going, but the navigation and functionality is stupid at best. I'm attempting to establish connections to a local Db2 for LUW using a secure connection, and it just doesn't work. IBM Data Studio was 2 minutes to configure the same connection, and so I don't think I'm defining the connection incorrectly.

Thanks in advance.

Dan

Daniel L Luksetich
DanL Database Consulting

IBM GOLD Consultant
IBM Champion for Analytics
IDUG Content Committee Past-Chairman
IDUG DB2-L Administrator
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


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

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

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

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

Daniel Luksetich

IBM Data Server Manager
(in response to Isaac Yassin)
So it seems I am not alone. Has anyone had success with this product? I am still using Data Studio extensively, but have found lately it is unreliable for generating DDL for more recent Db2 for z/OS features. Also, the last time I had a problem with IBM Data Studio IBM outright said NO to fixing it. So, my hopes for the future are fading. I know we have Zowe and DevOps for z/OS. I’m always reluctant when putting on open source code due to the installation and configuration issues that always seem to arise, and the DevOps tool I believe is not free. It’s frustrating because 99% of my SQL Server work is done via SQL Server Management Studio, and 1% is done via Visual Studio and SQL Server Integration Services, including some Db2 work! I wish we had a similar tool for Db2.

Dan



Daniel L Luksetich

DanL Database Consulting



IBM GOLD Consultant

IBM Champion for Analytics

IDUG Content Committee Past-Chairman

IDUG DB2-L Administrator

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: Isaac Yassin <[login to unmask email]>
Sent: Thursday, May 16, 2019 11:53 AM
To: [login to unmask email]
Subject: [DB2-L] - RE: IBM Data Server Manager



Ditto.

Tried the DSM few times. Gave up, totally frustrated.

Yes - I do have some misgivings about DS but it beats DSM when you need a work done.



Isaac Yassin

IBM Gold Consultant

IBM Champion for Analytics #ibmchampion

IBM Certified Solution Expert

IBM Certified System Administrator - DB2 for Z/OS 10, 11, 12

IBM Certified Database Administrator - DB2 for Z/OS 9, 10, 11

IBM Certified Database Administrator - DB2 LUW 10.1

IBM Certified Specialist - PureData System for Analytics v7.1

IDUG Israel RUG co-Chair







On Thu, May 16, 2019 at 7:23 PM Daniel L Luksetich <[login to unmask email] <mailto:[login to unmask email]> > wrote:

All,

I like to think that I’m a pretty good DBA, and not to shabby at other IT related technical bits. I’ve been using IBM Data Studio for many years, and still use it extensively every single day for management of both Db2 for LUW and Db2 for z/OS databases. I have been told many times that IBM Data Serer Manager is the future, and yet every time I attempt to install and configure IBM Data Server Manager it is a futile exercise. I find the product pretty much completely useless and unconfigurable. I’m currently on my nth attempt and am looking at an infinitely spinning donut. Has any one got this product to actually work, and if so can you guide my to some legitimate configuration and trouble shooting guides? It shouldn’t be that difficult. I have two Db2 for z/OS connections, one is secure. I have no problems with that. I’ve got the connections going, but the navigation and functionality is stupid at best. I’m attempting to establish connections to a local Db2 for LUW using a secure connection, and it just doesn’t work. IBM Data Studio was 2 minutes to configure the same connection, and so I don’t think I’m defining the connection incorrectly.



Thanks in advance.



Dan



Daniel L Luksetich

DanL Database Consulting



IBM GOLD Consultant

IBM Champion for Analytics

IDUG Content Committee Past-Chairman

IDUG DB2-L Administrator

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





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



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

Attachments

  • ~WRD000.jpg (<1k)

Ian Bjorhovde

IBM Data Server Manager
(in response to Daniel Luksetich)
Dan,

DSM is usable, and for monitoring it’s certainly well ahead of Data Studio.  Executing SQL and collecting explains is usable, but using it for every day administration is not great.  I’ve found that it can be somewhat flaky if you’re running on Windows (DSM creates a Windows Service and I’ve had problems where I had to unconfigure DSM and reconfigure it).  Linux is better.  And if you can use Docker, it’s quite easy to get a running installation using the IBM-provided image on Docker Store.

Configuring connections with SSL TLS is a pain, because DSM requires that you specify a Java Keystore (aka “truststore”) and the password for the keystore.  (It’s required even if the SSL certificate your Db2 server is using is signed by a root CA that’s already in the default keystore!).


Ian Bjorhovde


On May 16, 2019, 9:23 AM -0700, Daniel L Luksetich <[login to unmask email]>, wrote:
> All,
> I like to think that I’m a pretty good DBA, and not to shabby at other IT related technical bits. I’ve been using IBM Data Studio for many years, and still use it extensively every single day for management of both Db2 for LUW and Db2 for z/OS databases. I have been told many times that IBM Data Serer Manager is the future, and yet every time I attempt to install and configure IBM Data Server Manager it is a futile exercise. I find the product pretty much completely useless and unconfigurable. I’m currently on my nth attempt and am looking at an infinitely spinning donut. Has any one got this product to actually work, and if so can you guide my to some legitimate configuration and trouble shooting guides? It shouldn’t be that difficult. I have two Db2 for z/OS connections, one is secure. I have no problems with that. I’ve got the connections going, but the navigation and functionality is stupid at best. I’m attempting to establish connections to a local Db2 for LUW using a secure connection, and it just doesn’t work. IBM Data Studio was 2 minutes to configure the same connection, and so I don’t think I’m defining the connection incorrectly.
>
> Thanks in advance.
>
> Dan
>
> Daniel L Luksetich
> DanL Database Consulting
>
> IBM GOLD Consultant
> IBM Champion for Analytics
> IDUG Content Committee Past-Chairman
> IDUG DB2-L Administrator
> 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
>
>
> 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]
> ESAi has well-regarded tools for Fast Cloning, Buffer Pool Tuning, Log Analysis, TDM & more.
> BCV4, BCV5, BPA4DB2, ULT4DB2... modern power tools to get the job done faster & easier than ever.
> 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

Lance Jackson

IBM Data Server Manager
(in response to Daniel Luksetich)
Daniel,



I had similar experiences w/ DSM. I suggest switching to Tivoli Enterprise
Portal (TEP) - I'm currently in the process of configuring it, and so far,
so satisfied.



Lance J.



From: Daniel L Luksetich <[login to unmask email]>
Sent: Thursday, May 16, 2019 12:23
To: [login to unmask email]
Subject: [DB2-L] - IBM Data Server Manager



All,

I like to think that I'm a pretty good DBA, and not to shabby at other IT
related technical bits. I've been using IBM Data Studio for many years, and
still use it extensively every single day for management of both Db2 for LUW
and Db2 for z/OS databases. I have been told many times that IBM Data Serer
Manager is the future, and yet every time I attempt to install and configure
IBM Data Server Manager it is a futile exercise. I find the product pretty
much completely useless and unconfigurable. I'm currently on my nth attempt
and am looking at an infinitely spinning donut. Has any one got this product
to actually work, and if so can you guide my to some legitimate
configuration and trouble shooting guides? It shouldn't be that difficult. I
have two Db2 for z/OS connections, one is secure. I have no problems with
that. I've got the connections going, but the navigation and functionality
is stupid at best. I'm attempting to establish connections to a local Db2
for LUW using a secure connection, and it just doesn't work. IBM Data Studio
was 2 minutes to configure the same connection, and so I don't think I'm
defining the connection incorrectly.



Thanks in advance.



Dan



Daniel L Luksetich

DanL Database Consulting



IBM GOLD Consultant

IBM Champion for Analytics

IDUG Content Committee Past-Chairman

IDUG DB2-L Administrator

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





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

Lance Jackson

IBM Data Server Manager
(in response to Daniel Luksetich)
No, sorry. It's primarily for monitoring. DS is your best bet.



From: Daniel L Luksetich <[login to unmask email]>
Sent: Thursday, May 16, 2019 13:17
To: [login to unmask email]
Subject: [DB2-L] - RE: IBM Data Server Manager



I don't think I can use TEP to write SQLPL routines, can I? Can I use it to
define and alter objects, and reverse engineer ERD's from my database? If
so, I'll give it a go.

Dan



Daniel L Luksetich

DanL Database Consulting



IBM GOLD Consultant

IBM Champion for Analytics

IDUG Content Committee Past-Chairman

IDUG DB2-L Administrator

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: Lance D. Jackson <[login to unmask email] <mailto:[login to unmask email]> >

Sent: Thursday, May 16, 2019 3:36 PM
To: [login to unmask email] <mailto:[login to unmask email]>
Subject: [DB2-L] - RE: IBM Data Server Manager



Daniel,



I had similar experiences w/ DSM. I suggest switching to Tivoli Enterprise
Portal (TEP) - I'm currently in the process of configuring it, and so far,
so satisfied.



Lance J.



From: Daniel L Luksetich <[login to unmask email] <mailto:[login to unmask email]>
>
Sent: Thursday, May 16, 2019 12:23
To: [login to unmask email] <mailto:[login to unmask email]>
Subject: [DB2-L] - IBM Data Server Manager



All,

I like to think that I'm a pretty good DBA, and not to shabby at other IT
related technical bits. I've been using IBM Data Studio for many years, and
still use it extensively every single day for management of both Db2 for LUW
and Db2 for z/OS databases. I have been told many times that IBM Data Serer
Manager is the future, and yet every time I attempt to install and configure
IBM Data Server Manager it is a futile exercise. I find the product pretty
much completely useless and unconfigurable. I'm currently on my nth attempt
and am looking at an infinitely spinning donut. Has any one got this product
to actually work, and if so can you guide my to some legitimate
configuration and trouble shooting guides? It shouldn't be that difficult. I
have two Db2 for z/OS connections, one is secure. I have no problems with
that. I've got the connections going, but the navigation and functionality
is stupid at best. I'm attempting to establish connections to a local Db2
for LUW using a secure connection, and it just doesn't work. IBM Data Studio
was 2 minutes to configure the same connection, and so I don't think I'm
defining the connection incorrectly.



Thanks in advance.



Dan



Daniel L Luksetich

DanL Database Consulting



IBM GOLD Consultant

IBM Champion for Analytics

IDUG Content Committee Past-Chairman

IDUG DB2-L Administrator

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





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



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



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

Daniel Luksetich

IBM Data Server Manager
(in response to Ian Bjorhovde)
So, this is the problem I’m currently having. I have a Java keystore that works just fine for Data Studio, but not for DSM.

Dan



Daniel L Luksetich

DanL Database Consulting



IBM GOLD Consultant

IBM Champion for Analytics

IDUG Content Committee Past-Chairman

IDUG DB2-L Administrator

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: Ian Bjorhovde <[login to unmask email]>
Sent: Thursday, May 16, 2019 12:32 PM
To: [login to unmask email]
Subject: [DB2-L] - RE: IBM Data Server Manager



Dan,



DSM is usable, and for monitoring it’s certainly well ahead of Data Studio. Executing SQL and collecting explains is usable, but using it for every day administration is not great. I’ve found that it can be somewhat flaky if you’re running on Windows (DSM creates a Windows Service and I’ve had problems where I had to unconfigure DSM and reconfigure it). Linux is better. And if you can use Docker, it’s quite easy to get a running installation using the IBM-provided image on Docker Store.



Configuring connections with SSL TLS is a pain, because DSM requires that you specify a Java Keystore (aka “truststore”) and the password for the keystore. (It’s required even if the SSL certificate your Db2 server is using is signed by a root CA that’s already in the default keystore!).





Ian Bjorhovde





On May 16, 2019, 9:23 AM -0700, Daniel L Luksetich <[login to unmask email] <mailto:[login to unmask email]> >, wrote:



All,

I like to think that I’m a pretty good DBA, and not to shabby at other IT related technical bits. I’ve been using IBM Data Studio for many years, and still use it extensively every single day for management of both Db2 for LUW and Db2 for z/OS databases. I have been told many times that IBM Data Serer Manager is the future, and yet every time I attempt to install and configure IBM Data Server Manager it is a futile exercise. I find the product pretty much completely useless and unconfigurable. I’m currently on my nth attempt and am looking at an infinitely spinning donut. Has any one got this product to actually work, and if so can you guide my to some legitimate configuration and trouble shooting guides? It shouldn’t be that difficult. I have two Db2 for z/OS connections, one is secure. I have no problems with that. I’ve got the connections going, but the navigation and functionality is stupid at best. I’m attempting to establish connections to a local Db2 for LUW using a secure connection, and it just doesn’t work. IBM Data Studio was 2 minutes to configure the same connection, and so I don’t think I’m defining the connection incorrectly.



Thanks in advance.



Dan



Daniel L Luksetich

DanL Database Consulting



IBM GOLD Consultant

IBM Champion for Analytics

IDUG Content Committee Past-Chairman

IDUG DB2-L Administrator

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





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



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