DB2 11.1 for Windows scheduled processing

Daniel Luksetich

DB2 11.1 for Windows scheduled processing
What are people using these days to schedule and run scripts on DB2 for
Windows? I am moving from AIX with lots of glorious korn shell scripts,
cron, and mail. I've got some very basic powershell stuff going and that may
be possible. It looks like ember is really blazing the trail in that area.



Some of the functions I am looking into are backups, cross loads, remote
stored procedure calls, local procedure calls. DB2 automation only goes so
far. I'll definitely need scripts.



Thanks,

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



Philip Gunning

DB2 11.1 for Windows scheduled processing
(in response to Daniel Luksetich)
Windows scheduler


> IBM Champion for Analytics
> Certified Information Systems Security Professional(CISSP)
> Certification Number 539059
> Certified Advanced DB2 DBA v10.5
> Certified Database Adminstrator, DB2 11.1
> IBM DB2 LUW Support Page -- https://www.ibm.com/analytics/us/en/technology/db2/db2-linux-unix-windows.html
> Skype: DB2LUW
> Twitter: DB2LUW
> Direct +1.610.451.5801
> IDUG DB2-L Hall of Fame
> www.philipkgunning.com
> IBM Business Partner
>
Sent from my iPhone

> On Aug 1, 2017, at 2:49 PM, Daniel L Luksetich <[login to unmask email]> wrote:
>
> What are people using these days to schedule and run scripts on DB2 for Windows? I am moving from AIX with lots of glorious korn shell scripts, cron, and mail. I’ve got some very basic powershell stuff going and that may be possible. It looks like ember is really blazing the trail in that area.
>
> Some of the functions I am looking into are backups, cross loads, remote stored procedure calls, local procedure calls. DB2 automation only goes so far. I’ll definitely need scripts.
>
> Thanks,
> 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
>
>
> 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
>

Daniel Luksetich

DB2 11.1 for Windows scheduled processing
(in response to Philip Gunning)
Ok, but what are you using for scripting. Powershell? Simple batch job?



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: Philip Gunning [mailto:[login to unmask email]
Sent: Tuesday, August 1, 2017 2:40 PM
To: [login to unmask email]
Subject: [DB2-L] - RE: DB2 11.1 for Windows scheduled processing



Windows scheduler



IBM Champion for Analytics

Certified Information Systems Security Professional(CISSP)

Certification Number 539059

Certified Advanced DB2 DBA v10.5

Certified Database Adminstrator, DB2 11.1

IBM DB2 LUW Support Page -- https://www.ibm.com/analytics/us/en/technology/db2/db2-linux-unix-windows.html

Skype: DB2LUW

Twitter: DB2LUW

Direct +1.610.451.5801

IDUG DB2-L Hall of Fame

www.philipkgunning.com http://www.philipkgunning.com/AskMrDB2

IBM Business Partner



Sent from my iPhone


On Aug 1, 2017, at 2:49 PM, Daniel L Luksetich <[login to unmask email] <mailto:[login to unmask email]> > wrote:

What are people using these days to schedule and run scripts on DB2 for Windows? I am moving from AIX with lots of glorious korn shell scripts, cron, and mail. I’ve got some very basic powershell stuff going and that may be possible. It looks like ember is really blazing the trail in that area.



Some of the functions I am looking into are backups, cross loads, remote stored procedure calls, local procedure calls. DB2 automation only goes so far. I’ll definitely need scripts.



Thanks,

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





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



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

Mary Lo

DB2 11.1 for Windows scheduled processing
(in response to Daniel Luksetich)
We just use a simple batch job (*.bat) with DB2 command in it, for example:
C:\PROGRA~1\IBM\SQLLIB\BIN\db2cmd.exe -c -w -i db2 backup database mydb online to d:\backups

From: Daniel L Luksetich [mailto:[login to unmask email]
Sent: Tuesday, August 01, 2017 3:03 PM
To: [login to unmask email]
Subject: [DB2-L] - RE: DB2 11.1 for Windows scheduled processing

Ok, but what are you using for scripting. Powershell? Simple batch job?

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: Philip Gunning [mailto:[login to unmask email]
Sent: Tuesday, August 1, 2017 2:40 PM
To: [login to unmask email]<mailto:[login to unmask email]>
Subject: [DB2-L] - RE: DB2 11.1 for Windows scheduled processing

Windows scheduler

IBM Champion for Analytics
Certified Information Systems Security Professional(CISSP)
Certification Number 539059
Certified Advanced DB2 DBA v10.5
Certified Database Adminstrator, DB2 11.1
IBM DB2 LUW Support Page -- https://www.ibm.com/analytics/us/en/technology/db2/db2-linux-unix-windows.html
Skype: DB2LUW
Twitter: DB2LUW
Direct +1.610.451.5801
IDUG DB2-L Hall of Fame
www.philipkgunning.com http://www.philipkgunning.com/AskMrDB2
IBM Business Partner
[https://custom.cvent.com/1B8FF20CA3284DDD9E69582158291F1D/files/event/2E8C610B3FBB4C3BA7885291336FD0FF/68acaf4175e748efbd8044fbfea5d3b6.png]
Sent from my iPhone

On Aug 1, 2017, at 2:49 PM, Daniel L Luksetich <[login to unmask email]<mailto:[login to unmask email]>> wrote:
What are people using these days to schedule and run scripts on DB2 for Windows? I am moving from AIX with lots of glorious korn shell scripts, cron, and mail. I’ve got some very basic powershell stuff going and that may be possible. It looks like ember is really blazing the trail in that area.

Some of the functions I am looking into are backups, cross loads, remote stored procedure calls, local procedure calls. DB2 automation only goes so far. I’ll definitely need scripts.

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


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

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

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

Ember Crooks

DB2 11.1 for Windows scheduled processing
(in response to Daniel Luksetich)
Obviously my preference is PowerShell. I find it much more intuitive coming
from KSH/Bash/Perl, even though it has object-orientation features. In
addition to scripting in it on Windows, I do all my DB2 administration from
a PowerShell prompt (unless you have to run db2fodc, which doesn't work
well there).

Batch jobs and I just don't get along. The logic never quite makes sense to
me and file/directory ownership issues often get me. Not really sure if it
is me or batch, but I have spent hours on batch scripting. It is not that I
haven't given it enough effort. Usually with a few hours or days of
diligent effort, I can pick up the logic and feel of a new language and
bash my way through with the help of google - not so with batch.

I prefer to schedule from Task Scheduler on each local server. I have one
client who runs jobs from Data Studio, and based on his experience there, I
would avoid it like the plague. I have another client who keeps scripts on
a central server and executes everything from task scheduler on that
central server for more than 6 production DB2 on windows servers.

PowerShell has some interesting remote features that I've never really
played with, if you're looking for a central server approach:
https://www.howtogeek.com/117192/how-to-run-powershell-commands-on-remote-computers/

Ember Crooks

IBM Champion, Information Management, 2013 - 2017
IBM Gold Consultant, 2014 - 2017

On Tue, Aug 1, 2017 at 2:02 PM, Daniel L Luksetich <[login to unmask email]>
wrote:

> Ok, but what are you using for scripting. Powershell? Simple batch job?
>
>
>
> 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:* Philip Gunning [mailto:[login to unmask email]
> *Sent:* Tuesday, August 1, 2017 2:40 PM
> *To:* [login to unmask email]
> *Subject:* [DB2-L] - RE: DB2 11.1 for Windows scheduled processing
>
>
>
> Windows scheduler
>
>
>
> IBM Champion for Analytics
>
> Certified Information Systems Security Professional(CISSP)
>
> Certification Number 539059
>
> Certified Advanced DB2 DBA v10.5
>
> Certified Database Adminstrator, DB2 11.1
>
> IBM DB2 LUW Support Page -- https://www.ibm.com/
> analytics/us/en/technology/db2/db2-linux-unix-windows.html
>
> Skype: DB2LUW
>
> Twitter: DB2LUW
>
> Direct +1.610.451.5801 <(610)%20451-5801>
>
> IDUG DB2-L Hall of Fame
>
> www.philipkgunning.com http://www.philipkgunning.com/AskMrDB2
>
> IBM Business Partner
>
> [image:
> https://custom.cvent.com/1B8FF20CA3284DDD9E69582158291F1D/files/event/2E8C610B3FBB4C3BA7885291336FD0FF/68acaf4175e748efbd8044fbfea5d3b6.png]
>
> Sent from my iPhone
>
>
> On Aug 1, 2017, at 2:49 PM, Daniel L Luksetich <[login to unmask email]>
> wrote:
>
> What are people using these days to schedule and run scripts on DB2 for
> Windows? I am moving from AIX with lots of glorious korn shell scripts,
> cron, and mail. I’ve got some very basic powershell stuff going and that
> may be possible. It looks like ember is really blazing the trail in that
> area.
>
>
>
> Some of the functions I am looking into are backups, cross loads, remote
> stored procedure calls, local procedure calls. DB2 automation only goes so
> far. I’ll definitely need scripts.
>
>
>
> Thanks,
>
> 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
>
>
>
>
>
> -----End Original Message-----
>
>
> -----End Original Message-----
>
> -----End Original Message-----
>

Philip Sevetson

DB2 11.1 for Windows scheduled processing
(in response to Daniel Luksetich)
**please note my email address change**
Dan,

Powershell, when last I read about it, had a rash of known security holes. I don’t know details.

May I suggest an open source, general purpose programming language with scripting capabilities? Perl, Python, Ruby, and Tcl are generally accepted to have good functionality for scripting.

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: Daniel L Luksetich [mailto:[login to unmask email]
Sent: Tuesday, August 01, 2017 4:03 PM
To: [login to unmask email]
Subject: [DB2-L] - RE: DB2 11.1 for Windows scheduled processing

Ok, but what are you using for scripting. Powershell? Simple batch job?

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: Philip Gunning [mailto:[login to unmask email]
Sent: Tuesday, August 1, 2017 2:40 PM
To: [login to unmask email]<mailto:[login to unmask email]>
Subject: [DB2-L] - RE: DB2 11.1 for Windows scheduled processing

Windows scheduler

IBM Champion for Analytics
Certified Information Systems Security Professional(CISSP)
Certification Number 539059
Certified Advanced DB2 DBA v10.5
Certified Database Adminstrator, DB2 11.1
IBM DB2 LUW Support Page -- https://www.ibm.com/analytics/us/en/technology/db2/db2-linux-unix-windows.html
Skype: DB2LUW
Twitter: DB2LUW
Direct +1.610.451.5801
IDUG DB2-L Hall of Fame
www.philipkgunning.com http://www.philipkgunning.com/AskMrDB2
IBM Business Partner
[https://custom.cvent.com/1B8FF20CA3284DDD9E69582158291F1D/files/event/2E8C610B3FBB4C3BA7885291336FD0FF/68acaf4175e748efbd8044fbfea5d3b6.png]
Sent from my iPhone

On Aug 1, 2017, at 2:49 PM, Daniel L Luksetich <[login to unmask email]<mailto:[login to unmask email]>> wrote:
What are people using these days to schedule and run scripts on DB2 for Windows? I am moving from AIX with lots of glorious korn shell scripts, cron, and mail. I’ve got some very basic powershell stuff going and that may be possible. It looks like ember is really blazing the trail in that area.

Some of the functions I am looking into are backups, cross loads, remote stored procedure calls, local procedure calls. DB2 automation only goes so far. I’ll definitely need scripts.

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


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

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

-----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)
  • image002.png (32.6k)

Ember Crooks

DB2 11.1 for Windows scheduled processing
(in response to Philip Sevetson)
It is nice if you can use Perl. However, it has to be installed on Windows.
For certain purposes, I have to use "lowest common denominator" languages
that are on all servers by default. PowerShell, Batch, and VB are the
choices in that category on Windows.

Ember Crooks

IBM Champion, Information Management, 2013 - 2017
IBM Gold Consultant, 2014 - 2017

On Tue, Aug 1, 2017 at 2:35 PM, Sevetson, Phil <[login to unmask email]> wrote:

> **please note my email address change**
>
> Dan,
>
>
>
> Powershell, when last I read about it, had a rash of known security holes.
> I don’t know details.
>
> May I suggest an open source, general purpose programming language with
> scripting capabilities? Perl, Python, Ruby, and Tcl are generally accepted
> to have good functionality for scripting.
>
>
>
> Philip Sevetson
>
> Computer Systems Manager
>
> 5 Manhattan West (33rd St at 10th Ave)
>
> New York, NY 10001-2632
>
> 212-857-1688 <(212)%20857-1688> w
>
> 917-991-7052 <(917)%20991-7052> c
>
> 212-857-1659 <(212)%20857-1659> f
>
> [image: cid:[login to unmask email]
>
>
>
> *From:* Daniel L Luksetich [mailto:[login to unmask email]
> *Sent:* Tuesday, August 01, 2017 4:03 PM
>
> *To:* [login to unmask email]
> *Subject:* [DB2-L] - RE: DB2 11.1 for Windows scheduled processing
>
>
>
> Ok, but what are you using for scripting. Powershell? Simple batch job?
>
>
>
> 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:* Philip Gunning [mailto:[login to unmask email] <[login to unmask email]>]
>
> *Sent:* Tuesday, August 1, 2017 2:40 PM
> *To:* [login to unmask email]
> *Subject:* [DB2-L] - RE: DB2 11.1 for Windows scheduled processing
>
>
>
> Windows scheduler
>
>
>
> IBM Champion for Analytics
>
> Certified Information Systems Security Professional(CISSP)
>
> Certification Number 539059
>
> Certified Advanced DB2 DBA v10.5
>
> Certified Database Adminstrator, DB2 11.1
>
> IBM DB2 LUW Support Page -- https://www.ibm.com/
> analytics/us/en/technology/db2/db2-linux-unix-windows.html
>
> Skype: DB2LUW
>
> Twitter: DB2LUW
>
> Direct +1.610.451.5801 <(610)%20451-5801>
>
> IDUG DB2-L Hall of Fame
>
> www.philipkgunning.com http://www.philipkgunning.com/AskMrDB2
>
> IBM Business Partner
>
> [image:
> https://custom.cvent.com/1B8FF20CA3284DDD9E69582158291F1D/files/event/2E8C610B3FBB4C3BA7885291336FD0FF/68acaf4175e748efbd8044fbfea5d3b6.png]
>
> Sent from my iPhone
>
>
> On Aug 1, 2017, at 2:49 PM, Daniel L Luksetich <[login to unmask email]>
> wrote:
>
> What are people using these days to schedule and run scripts on DB2 for
> Windows? I am moving from AIX with lots of glorious korn shell scripts,
> cron, and mail. I’ve got some very basic powershell stuff going and that
> may be possible. It looks like ember is really blazing the trail in that
> area.
>
>
>
> Some of the functions I am looking into are backups, cross loads, remote
> stored procedure calls, local procedure calls. DB2 automation only goes so
> far. I’ll definitely need scripts.
>
>
>
> Thanks,
>
> 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
>
>
>
>
>
> -----End Original Message-----
>
>
>
> -----End Original Message-----
>
>
> -----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-----
>
Attachments

  • image001.png (3.3k)
  • image002.png (32.6k)

Philip Gunning

DB2 11.1 for Windows scheduled processing
(in response to Daniel Luksetich)
Basic scripting and .bat files, migrated 100 jobs from Control Center task center to Windows Scheduler, 7 instances 8
Databases.....plenty of stored procedure calls, Each has there own set of scripts but
Wouldn't be hard to parameterize it .....Works well
And these are major production high transaction rate
hADR environments....


> IBM Champion for Analytics
> Certified Information Systems Security Professional(CISSP)
> Certification Number 539059
> Certified Advanced DB2 DBA v10.5
> Certified Database Adminstrator, DB2 11.1
> IBM DB2 LUW Support Page -- https://www.ibm.com/analytics/us/en/technology/db2/db2-linux-unix-windows.html
> Skype: DB2LUW
> Twitter: DB2LUW
> Direct +1.610.451.5801
> IDUG DB2-L Hall of Fame
> www.philipkgunning.com
> IBM Business Partner
>
Sent from my iPhone

> On Aug 1, 2017, at 4:02 PM, Daniel L Luksetich <[login to unmask email]> wrote:
>
> Ok, but what are you using for scripting. Powershell? Simple batch job?
>
> 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: Philip Gunning [mailto:[login to unmask email]
> Sent: Tuesday, August 1, 2017 2:40 PM
> To: [login to unmask email]
> Subject: [DB2-L] - RE: DB2 11.1 for Windows scheduled processing
>
> Windows scheduler
>
>
> IBM Champion for Analytics
> Certified Information Systems Security Professional(CISSP)
> Certification Number 539059
> Certified Advanced DB2 DBA v10.5
> Certified Database Adminstrator, DB2 11.1
> IBM DB2 LUW Support Page -- https://www.ibm.com/analytics/us/en/technology/db2/db2-linux-unix-windows.html
> Skype: DB2LUW
> Twitter: DB2LUW
> Direct +1.610.451.5801
> IDUG DB2-L Hall of Fame
> www.philipkgunning.com
> IBM Business Partner
>
> Sent from my iPhone
>
> On Aug 1, 2017, at 2:49 PM, Daniel L Luksetich <[login to unmask email]> wrote:
>
> What are people using these days to schedule and run scripts on DB2 for Windows? I am moving from AIX with lots of glorious korn shell scripts, cron, and mail. I’ve got some very basic powershell stuff going and that may be possible. It looks like ember is really blazing the trail in that area.
>
> Some of the functions I am looking into are backups, cross loads, remote stored procedure calls, local procedure calls. DB2 automation only goes so far. I’ll definitely need scripts.
>
> Thanks,
> 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
>
>
> -----End Original Message-----
>
> -----End Original Message-----
>
> 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
>

Daniel Luksetich

DB2 11.1 for Windows scheduled processing
(in response to Philip Gunning)
Thanks everyone for the advice!

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: Philip Gunning [mailto:[login to unmask email]
Sent: Tuesday, August 1, 2017 4:24 PM
To: [login to unmask email]
Subject: [DB2-L] - RE: DB2 11.1 for Windows scheduled processing



Basic scripting and .bat files, migrated 100 jobs from Control Center task center to Windows Scheduler, 7 instances 8

Databases.....plenty of stored procedure calls, Each has there own set of scripts but

Wouldn't be hard to parameterize it .....Works well

And these are major production high transaction rate

hADR environments....



IBM Champion for Analytics

Certified Information Systems Security Professional(CISSP)

Certification Number 539059

Certified Advanced DB2 DBA v10.5

Certified Database Adminstrator, DB2 11.1

IBM DB2 LUW Support Page -- https://www.ibm.com/analytics/us/en/technology/db2/db2-linux-unix-windows.html

Skype: DB2LUW

Twitter: DB2LUW

Direct +1.610.451.5801

IDUG DB2-L Hall of Fame

www.philipkgunning.com http://www.philipkgunning.com/AskMrDB2

IBM Business Partner



Sent from my iPhone


On Aug 1, 2017, at 4:02 PM, Daniel L Luksetich <[login to unmask email] <mailto:[login to unmask email]> > wrote:

Ok, but what are you using for scripting. Powershell? Simple batch job?



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: Philip Gunning [mailto:[login to unmask email]
Sent: Tuesday, August 1, 2017 2:40 PM
To: [login to unmask email] <mailto:[login to unmask email]>
Subject: [DB2-L] - RE: DB2 11.1 for Windows scheduled processing



Windows scheduler



IBM Champion for Analytics

Certified Information Systems Security Professional(CISSP)

Certification Number 539059

Certified Advanced DB2 DBA v10.5

Certified Database Adminstrator, DB2 11.1

IBM DB2 LUW Support Page -- https://www.ibm.com/analytics/us/en/technology/db2/db2-linux-unix-windows.html

Skype: DB2LUW

Twitter: DB2LUW

Direct +1.610.451.5801

IDUG DB2-L Hall of Fame

www.philipkgunning.com http://www.philipkgunning.com/AskMrDB2

IBM Business Partner



Sent from my iPhone


On Aug 1, 2017, at 2:49 PM, Daniel L Luksetich <[login to unmask email] <mailto:[login to unmask email]> > wrote:

What are people using these days to schedule and run scripts on DB2 for Windows? I am moving from AIX with lots of glorious korn shell scripts, cron, and mail. I’ve got some very basic powershell stuff going and that may be possible. It looks like ember is really blazing the trail in that area.



Some of the functions I am looking into are backups, cross loads, remote stored procedure calls, local procedure calls. DB2 automation only goes so far. I’ll definitely need scripts.



Thanks,

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





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



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



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



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

Nadir Doctor

DB2 11.1 for Windows scheduled processing
(in response to Daniel Luksetich)
There is another scipting option available which doesn't need a separate
install but hasn't seemed to get very popular so far - coding with rexx on
distributed platforms:

https://www.ibm.com/support/knowledgecenter/SSEPGG_10.5.0/com.ibm.db2.luw.apdv.samptop.doc/doc/r0008934.html


Best Regards,
Nadir



On Thu, Aug 3, 2017 at 6:31 AM, Daniel L Luksetich <[login to unmask email]>
wrote:

> Thanks everyone for the advice!
>
> 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:* Philip Gunning [mailto:[login to unmask email]
> *Sent:* Tuesday, August 1, 2017 4:24 PM
>
> *To:* [login to unmask email]
> *Subject:* [DB2-L] - RE: DB2 11.1 for Windows scheduled processing
>
>
>
> Basic scripting and .bat files, migrated 100 jobs from Control Center task
> center to Windows Scheduler, 7 instances 8
>
> Databases.....plenty of stored procedure calls, Each has there own set of
> scripts but
>
> Wouldn't be hard to parameterize it .....Works well
>
> And these are major production high transaction rate
>
> hADR environments....
>
>
>
> IBM Champion for Analytics
>
> Certified Information Systems Security Professional(CISSP)
>
> Certification Number 539059
>
> Certified Advanced DB2 DBA v10.5
>
> Certified Database Adminstrator, DB2 11.1
>
> IBM DB2 LUW Support Page -- https://www.ibm.com/
> analytics/us/en/technology/db2/db2-linux-unix-windows.html
>
> Skype: DB2LUW
>
> Twitter: DB2LUW
>
> Direct +1.610.451.5801 <(610)%20451-5801>
>
> IDUG DB2-L Hall of Fame
>
> www.philipkgunning.com http://www.philipkgunning.com/AskMrDB2
>
> IBM Business Partner
>
> [image:
> https://custom.cvent.com/1B8FF20CA3284DDD9E69582158291F1D/files/event/2E8C610B3FBB4C3BA7885291336FD0FF/68acaf4175e748efbd8044fbfea5d3b6.png]
>
> Sent from my iPhone
>
>
> On Aug 1, 2017, at 4:02 PM, Daniel L Luksetich <[login to unmask email]>
> wrote:
>
> Ok, but what are you using for scripting. Powershell? Simple batch job?
>
>
>
> 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:* Philip Gunning [mailto:[login to unmask email] <[login to unmask email]>]
>
> *Sent:* Tuesday, August 1, 2017 2:40 PM
> *To:* [login to unmask email]
> *Subject:* [DB2-L] - RE: DB2 11.1 for Windows scheduled processing
>
>
>
> Windows scheduler
>
>
>
> IBM Champion for Analytics
>
> Certified Information Systems Security Professional(CISSP)
>
> Certification Number 539059
>
> Certified Advanced DB2 DBA v10.5
>
> Certified Database Adminstrator, DB2 11.1
>
> IBM DB2 LUW Support Page -- https://www.ibm.com/
> analytics/us/en/technology/db2/db2-linux-unix-windows.html
>
> Skype: DB2LUW
>
> Twitter: DB2LUW
>
> Direct +1.610.451.5801 <(610)%20451-5801>
>
> IDUG DB2-L Hall of Fame
>
> www.philipkgunning.com http://www.philipkgunning.com/AskMrDB2
>
> IBM Business Partner
>
> [image:
> https://custom.cvent.com/1B8FF20CA3284DDD9E69582158291F1D/files/event/2E8C610B3FBB4C3BA7885291336FD0FF/68acaf4175e748efbd8044fbfea5d3b6.png]
>
> Sent from my iPhone
>
>
> On Aug 1, 2017, at 2:49 PM, Daniel L Luksetich <[login to unmask email]>
> wrote:
>
> What are people using these days to schedule and run scripts on DB2 for
> Windows? I am moving from AIX with lots of glorious korn shell scripts,
> cron, and mail. I’ve got some very basic powershell stuff going and that
> may be possible. It looks like ember is really blazing the trail in that
> area.
>
>
>
> Some of the functions I am looking into are backups, cross loads, remote
> stored procedure calls, local procedure calls. DB2 automation only goes so
> far. I’ll definitely need scripts.
>
>
>
> Thanks,
>
> 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
>
>
>
>
>
> -----End Original Message-----
>
>
>
> -----End Original Message-----
>
>
>
> -----End Original Message-----
>
>
> -----End Original Message-----
>
> -----End Original Message-----
>