DB2V7 Z/OS... Running SQL under a IBM Utility?

Ray Gaston

DB2V7 Z/OS... Running SQL under a IBM Utility?

January 28, 2008 10:53 AM

Dear Esteem Listers... Is there an IBM Utility which will allow us
to
run SQL UPDATE statements under it?

We need to UPDATE Production data but want to guaranteed that no
user
can update the same target tables during our updates (in case we
need to
fallback to the UNLOADS taken just before the UPDATES). This is
the
only available "window" scenario. DSNTEP2 probably would not
work
because it is not itself a utility but only a "sample program".
Temporarily revoking/granting "privileges could get clumsy and
complicated. Can someone please help?

The IDUG DB2-L Listserv is only part of your membership in IDUG.
DB2-L list archives, the FAQ, and delivery preferences are at
http://www.idug.org/lsidug under
the Listserv tab. While at the site, you can also access the IDUG
Online Learning Center, Tech Library and Code Place, see the latest
IDUG conference information, and much more. If you have not yet
signed up for Basic Membership in IDUG, available at no cost, click
on Member Services at http://www.idug.org/lsms

Dear Esteem Listers… Is there an IBM Utility which will
allow us to run SQL UPDATE statements under it?

We need to UPDATE Production data but want to guaranteed that no
user can update the same target tables during our updates (in case
we need to fallback to the UNLOADS taken just before the UPDATES).
This is the only available "window" scenario. DSNTEP2 probably
would not work because it is not itself a utility but only a
"sample program". Temporarily revoking/granting "privileges could
get clumsy and complicated. Can someone please help?

The IDUG DB2-L Listserv is only part of your membership in IDUG.
DB2-L list archives, the FAQ, and delivery preferences are at
HYPERLINK "http://www.idug.org/lsidug"www.idug.org
under the Listserv tab. While at the site, you can also access the
IDUG Online Learning Center, Tech Library and Code Place, see the
latest HYPERLINK "http://www.idug.org/lsconf"IDUG
conference information, and much more.
If you have not yet signed up for Basic Membership in IDUG,
available at no cost, click on HYPERLINK "http://www.idug.org/lsms"Member
Services

The IDUG DB2-L Listserv is only part of your membership in IDUG.
DB2-L list archives, the FAQ, and delivery preferences are at
http://www.idug.org/lsidug under
the Listserv tab. While at the site, you can also access the IDUG
Online Learning Center, Tech Library and Code Place, see the latest
IDUG conference information, and much more. If you have not yet
signed up for Basic Membership in IDUG, available at no cost, click
on Member Services at http://www.idug.org/lsms

Phil Grainger

You'll struggle to maintain integrity between the unloads and
the
update, but do make sure you LOCK THE TABLE EXCLUSIVELY to keep
people
out when you DO run the update (and it'll help the update fly
through)

Dear Esteem Listers... Is there an IBM Utility which will allow us
to
run SQL UPDATE statements under it?

We need to UPDATE Production data but want to guaranteed that no
user
can update the same target tables during our updates (in case we
need to
fallback to the UNLOADS taken just before the UPDATES). This is
the
only available "window" scenario. DSNTEP2 probably would not
work
because it is not itself a utility but only a "sample program".
Temporarily revoking/granting "privileges could get clumsy and
complicated. Can someone please help?

The IDUG DB2-L Listserv is only part of your membership in IDUG.
DB2-L
list archives, the FAQ, and delivery preferences are at
www.idug.org
< http://www.idug.org/lsidug >
under the Listserv tab. While at the site,
you can also access the IDUG Online Learning Center, Tech Library
and
Code Place, see the latest IDUG conference information
< http://www.idug.org/lsconf > ,
and much more.
If you have not yet signed up for Basic Membership in IDUG,
available at
no cost, click on Member Services < http://www.idug.org/lsms >

The IDUG DB2-L Listserv is only part of your membership in IDUG.
DB2-L list archives, the FAQ, and delivery preferences are at
http://www.idug.org/lsidug under
the Listserv tab. While at the site, you can also access the IDUG
Online Learning Center, Tech Library and Code Place, see the latest
IDUG conference information, and much more. If you have not yet
signed up for Basic Membership in IDUG, available at no cost, click
on Member Services at http://www.idug.org/lsms

Guido Verbraak

For combining utilities with SQL, you can use DSNUPROC and use the
utility
EXEC SQL to submit your SQL/update statements. After that/ in
between you
can use the other utilities like copy, runstats etc. And it is
possible to
use the lock statement too, like Phil wrote.

Dear Esteem Listers? Is there an IBM Utility which will allow us to
run
SQL UPDATE statements under it?
We need to UPDATE Production data but want to guaranteed that no
user can
update the same target tables during our updates (in case we need
to
fallback to the UNLOADS taken just before the UPDATES). This is the
only
available "window" scenario. DSNTEP2 probably would not work
because it is
not itself a utility but only a "sample program". Temporarily
revoking/granting "privileges could get clumsy and complicated.
Can
someone please help?
Thanks in advance - Ray Gaston
(Con Ed - DBA)
The strategy:
1) PLACE TABLESPACES IN UT R/O Mode
2) IBM UNLOADS (for fallback if needed)
3) SQL UPDATES (via the mystery IBM Utility)
4) IF needed RELOADS.
The SQL:
UPDATE TORU.TABLE1_EMPLOYEE A
SET CDE_EMPLOYEE = (SELECT CDE_EMPLOYEE_NEW
FROM TORU.TABLE2_EMPL_CONVERT B
WHERE (B.CDE_EMPLOYEE_NO= A.CDE_EMPLOYEE ) )
WHERE EXISTS ( SELECT 1
FROM TORU.TABLE2_EMPL_CONVERT B2
WHERE B2.CDE_EMPLOYEE_NO = A.CDE_EMPLOYEE)

The IDUG DB2-L Listserv is only part of your membership in IDUG.
DB2-L
list archives, the FAQ, and delivery preferences are at
www.idug.org under
the Listserv tab. While at the site, you can also access the IDUG
Online
Learning Center, Tech Library and Code Place, see the latest
IDUG
conference information, and much more.
If you have not yet signed up for Basic Membership in IDUG,
available at
no cost, click on Member Services

The IDUG DB2-L Listserv is only part of your membership in IDUG.
DB2-L list archives, the FAQ, and delivery preferences are at
http://www.idug.org/lsidug under
the Listserv tab. While at the site, you can also access the IDUG
Online Learning Center, Tech Library and Code Place, see the latest
IDUG conference information, and much more. If you have not yet
signed up for Basic Membership in IDUG, available at no cost, click
on Member Services at http://www.idug.org/lsms

Dear Esteem Listers... Is there an IBM Utility which will allow us
to
run SQL UPDATE statements under it?

We need to UPDATE Production data but want to guaranteed that no
user
can update the same target tables during our updates (in case we
need to
fallback to the UNLOADS taken just before the UPDATES). This is
the
only available "window" scenario. DSNTEP2 probably would not
work
because it is not itself a utility but only a "sample program".
Temporarily revoking/granting "privileges could get clumsy and
complicated. Can someone please help?

The IDUG DB2-L Listserv is only part of your membership in IDUG.
DB2-L
list archives, the FAQ, and delivery preferences are at
www.idug.org
< http://www.idug.org/lsidug >
under the Listserv tab. While at the site,
you can also access the IDUG Online Learning Center, Tech Library
and
Code Place, see the latest IDUG conference information
< http://www.idug.org/lsconf > ,
and much more.
If you have not yet signed up for Basic Membership in IDUG,
available at
no cost, click on Member Services < http://www.idug.org/lsms >

The IDUG DB2-L Listserv is only part of your membership in IDUG.
DB2-L
list archives, the FAQ, and delivery preferences are at
www.idug.org
< http://www.idug.org/lsidug >
under the Listserv tab. While at the site,
you can also access the IDUG Online Learning Center, Tech Library
and
Code Place, see the latest IDUG conference information
< http://www.idug.org/lsconf > ,
and much more.
If you have not yet signed up for Basic Membership in IDUG,
available at
no cost, click on Member Services < http://www.idug.org/lsms >

The IDUG DB2-L Listserv is only part of your membership in IDUG.
DB2-L list archives, the FAQ, and delivery preferences are at
http://www.idug.org/lsidug under
the Listserv tab. While at the site, you can also access the IDUG
Online Learning Center, Tech Library and Code Place, see the latest
IDUG conference information, and much more. If you have not yet
signed up for Basic Membership in IDUG, available at no cost, click
on Member Services at http://www.idug.org/lsms

Dear Esteem Listers... Is there an IBM Utility which will allow us
to
run SQL UPDATE statements under it?

We need to UPDATE Production data but want to guaranteed that no
user
can update the same target tables during our updates (in case we
need to
fallback to the UNLOADS taken just before the UPDATES). This is
the
only available "window" scenario. DSNTEP2 probably would not
work
because it is not itself a utility but only a "sample program".
Temporarily revoking/granting "privileges could get clumsy and
complicated. Can someone please help?

The IDUG DB2-L Listserv is only part of your membership in IDUG.
DB2-L
list archives, the FAQ, and delivery preferences are at
www.idug.org
< http://www.idug.org/lsidug >
under the Listserv tab. While at the site,
you can also access the IDUG Online Learning Center, Tech Library
and
Code Place, see the latest IDUG conference information
< http://www.idug.org/lsconf > ,
and much more.
If you have not yet signed up for Basic Membership in IDUG,
available at
no cost, click on Member Services < http://www.idug.org/lsms >

The IDUG DB2-L Listserv is only part of your membership in IDUG.
DB2-L list archives, the FAQ, and delivery preferences are at
http://www.idug.org/lsidug under
the Listserv tab. While at the site, you can also access the IDUG
Online Learning Center, Tech Library and Code Place, see the latest
IDUG conference information, and much more. If you have not yet
signed up for Basic Membership in IDUG, available at no cost, click
on Member Services at http://www.idug.org/lsms

You'll struggle to maintain integrity between the unloads and
the
update, but do make sure you LOCK THE TABLE EXCLUSIVELY to keep
people
out when you DO run the update (and it'll help the update fly
through)

Dear Esteem Listers... Is there an IBM Utility which will allow us
to
run SQL UPDATE statements under it?

We need to UPDATE Production data but want to guaranteed that no
user
can update the same target tables during our updates (in case we
need to
fallback to the UNLOADS taken just before the UPDATES). This is
the
only available "window" scenario. DSNTEP2 probably would not
work
because it is not itself a utility but only a "sample program".
Temporarily revoking/granting "privileges could get clumsy and
complicated. Can someone please help?

The IDUG DB2-L Listserv is only part of your membership in IDUG.
DB2-L
list archives, the FAQ, and delivery preferences are at
www.idug.org
< http://www.idug.org/lsidug >
under the Listserv tab. While at the site,
you can also access the IDUG Online Learning Center, Tech Library
and
Code Place, see the latest IDUG conference information
< http://www.idug.org/lsconf > ,
and much more.
If you have not yet signed up for Basic Membership in IDUG,
available at
no cost, click on Member Services < http://www.idug.org/lsms >
The IDUG DB2-L Listserv is only part of your membership in IDUG.
DB2-L
list archives, the FAQ, and delivery preferences are at
www.idug.org
< http://www.idug.org/lsidug >
under the Listserv tab. While at the site,
you can also access the IDUG Online Learning Center, Tech Library
and
Code Place, see the latest IDUG conference information
< http://www.idug.org/lsconf > ,
and much more.
If you have not yet signed up for Basic Membership in IDUG,
available at
no cost, click on Member Services < http://www.idug.org/lsms >

The IDUG DB2-L Listserv is only part of your membership in IDUG.
DB2-L list archives, the FAQ, and delivery preferences are at
http://www.idug.org/lsidug under
the Listserv tab. While at the site, you can also access the IDUG
Online Learning Center, Tech Library and Code Place, see the latest
IDUG conference information, and much more. If you have not yet
signed up for Basic Membership in IDUG, available at no cost, click
on Member Services at http://www.idug.org/lsms

Dear Esteem Listers... Is there an IBM Utility which will allow us
to
run SQL UPDATE statements under it?

We need to UPDATE Production data but want to guaranteed that no
user
can update the same target tables during our updates (in case we
need to
fallback to the UNLOADS taken just before the UPDATES). This is
the
only available "window" scenario. DSNTEP2 probably would not
work
because it is not itself a utility but only a "sample program".
Temporarily revoking/granting "privileges could get clumsy and
complicated. Can someone please help?

The IDUG DB2-L Listserv is only part of your membership in IDUG.
DB2-L
list archives, the FAQ, and delivery preferences are at
www.idug.org
< http://www.idug.org/lsidug >
under the Listserv tab. While at the site,
you can also access the IDUG Online Learning Center, Tech Library
and
Code Place, see the latest IDUG conference information, and much
more.
If you have not yet signed up for Basic Membership in IDUG,
available at
no cost, click on Member Services

The IDUG DB2-L Listserv is only part of your membership in IDUG.
DB2-L
list archives, the FAQ, and delivery preferences are at
www.idug.org
< http://www.idug.org/lsidug >
under the Listserv tab. While at the site,
you can also access the IDUG Online Learning Center, Tech Library
and
Code Place, see the latest IDUG conference information, and much
more.
If you have not yet signed up for Basic Membership in IDUG,
available at
no cost, click on Member Services

The IDUG DB2-L Listserv is only part of your membership in IDUG.
DB2-L
list archives, the FAQ, and delivery preferences are at
www.idug.org
< http://www.idug.org/lsidug >
under the Listserv tab. While at the site,
you can also access the IDUG Online Learning Center, Tech Library
and
Code Place, see the latest IDUG conference information
< http://www.idug.org/lsconf > ,
and much more.
If you have not yet signed up for Basic Membership in IDUG,
available at
no cost, click on Member Services < http://www.idug.org/lsms >

-----------------------------------------
Under Florida law, e-mail addresses are public records. If you
do
not want your e-mail address released in response to a public
records request, do not send electronic mail to this entity.
Instead, contact this office by phone or in writing.

The IDUG DB2-L Listserv is only part of your membership in IDUG.
DB2-L list archives, the FAQ, and delivery preferences are at
http://www.idug.org/lsidug under
the Listserv tab. While at the site, you can also access the IDUG
Online Learning Center, Tech Library and Code Place, see the latest
IDUG conference information, and much more. If you have not yet
signed up for Basic Membership in IDUG, available at no cost, click
on Member Services at http://www.idug.org/lsms

Andy Lankester

No, Phil has it right. There is not a UTILITY that will do this,
and I'm pretty sure that SPUFI will not run UPDATEs if the space is
in UTxx mode.

Easy enough to build a rexx to issue the appropriate LOCK
statements and read in the UPDATES, execute them, and COMMIT.
However beware the UOW size and LOCK ESCALATION. Be careful about
the plan you run the rexx under - it needs to be bound RELEASE
DEALLOCATE if you issue intermediate COMMITs.

Dear Esteem Listers… Is there an IBM Utility which will
allow us to run SQL UPDATE statements under it?

We need to UPDATE Production data but want to guaranteed that no
user can update the same target tables during our updates (in case
we need to fallback to the UNLOADS taken just before the UPDATES).
This is the only available "window" scenario. DSNTEP2 probably
would not work because it is not itself a utility but only a
"sample program". Temporarily revoking/granting "privileges could
get clumsy and complicated. Can someone please help?

The IDUG DB2-L Listserv is only part of your membership in IDUG.
DB2-L list archives, the FAQ, and delivery preferences are at
HYPERLINK "http://www.idug.org/lsidug"www.idug.org
under the Listserv tab. While at the site, you can also access the
IDUG Online Learning Center, Tech Library and Code Place, see the
latest HYPERLINK "http://www.idug.org/lsconf"IDUG
conference information, and much more.
If you have not yet signed up for Basic Membership in IDUG,
available at no cost, click on HYPERLINK "http://www.idug.org/lsms"Member
Services

The IDUG DB2-L Listserv is only part of your membership in IDUG.
DB2-L list archives, the FAQ, and delivery preferences are at
HYPERLINK "http://www.idug.org/lsidug"www.idug.org
under the Listserv tab. While at the site, you can also access the
IDUG Online Learning Center, Tech Library and Code Place, see the
latest HYPERLINK "http://www.idug.org/lsconf"IDUG
conference information, and much more.
If you have not yet signed up for Basic Membership in IDUG,
available at no cost, click on HYPERLINK "http://www.idug.org/lsms"Member
Services
The IDUG DB2-L Listserv is only part of your membership in IDUG.
DB2-L list archives, the FAQ, and delivery preferences are at
HYPERLINK "http://www.idug.org/lsidug"www.idug.org
under the Listserv tab. While at the site, you can also access the
IDUG Online Learning Center, Tech Library and Code Place, see the
latest HYPERLINK "http://www.idug.org/lsconf"IDUG
conference information, and much more.
If you have not yet signed up for Basic Membership in IDUG,
available at no cost, click on HYPERLINK "http://www.idug.org/lsms"Member
Services

The IDUG DB2-L Listserv is only part of your membership in IDUG.
DB2-L list archives, the FAQ, and delivery preferences are at
http://www.idug.org/lsidug under
the Listserv tab. While at the site, you can also access the IDUG
Online Learning Center, Tech Library and Code Place, see the latest
IDUG conference information, and much more. If you have not yet
signed up for Basic Membership in IDUG, available at no cost, click
on Member Services at http://www.idug.org/lsms

For combining utilities with SQL, you can use DSNUPROC and use
the
utility EXEC SQL to submit your SQL/update statements. After that/
in
between you can use the other utilities like copy, runstats etc.
And it
is possible to use the lock statement too, like Phil wrote.

Dear Esteem Listers... Is there an IBM Utility which will allow us
to
run SQL UPDATE statements under it?

We need to UPDATE Production data but want to guaranteed that no
user
can update the same target tables during our updates (in case we
need to
fallback to the UNLOADS taken just before the UPDATES). This is
the
only available "window" scenario. DSNTEP2 probably would not
work
because it is not itself a utility but only a "sample program".
Temporarily revoking/granting "privileges could get clumsy and
complicated. Can someone please help?

The IDUG DB2-L Listserv is only part of your membership in IDUG.
DB2-L
list archives, the FAQ, and delivery preferences are at
www.idug.org
< http://www.idug.org/lsidug >
under the Listserv tab. While at the site,
you can also access the IDUG Online Learning Center, Tech Library
and
Code Place, see the latest IDUG conference information
< http://www.idug.org/lsconf > ,
and much more.
If you have not yet signed up for Basic Membership in IDUG,
available at
no cost, click on Member Services < http://www.idug.org/lsms >

The IDUG DB2-L Listserv is only part of your membership in IDUG.
DB2-L
list archives, the FAQ, and delivery preferences are at
www.idug.org
< http://www.idug.org/lsidug >
under the Listserv tab. While at the site,
you can also access the IDUG Online Learning Center, Tech Library
and
Code Place, see the latest IDUG conference information
< http://www.idug.org/lsconf > ,
and much more.
If you have not yet signed up for Basic Membership in IDUG,
available at
no cost, click on Member Services < http://www.idug.org/lsms >

The IDUG DB2-L Listserv is only part of your membership in IDUG.
DB2-L list archives, the FAQ, and delivery preferences are at
http://www.idug.org/lsidug under
the Listserv tab. While at the site, you can also access the IDUG
Online Learning Center, Tech Library and Code Place, see the latest
IDUG conference information, and much more. If you have not yet
signed up for Basic Membership in IDUG, available at no cost, click
on Member Services at http://www.idug.org/lsms

Dear Esteem Listers... Is there an IBM Utility which will allow us
to run SQL UPDATE statements under it?
We need to UPDATE Production data but want to guaranteed that no
user can update the same target tables during our updates (in case
we need to fallback to the UNLOADS taken just before the UPDATES).
This is the only available "window" scenario. DSNTEP2 probably
would not work because it is not itself a utility but only a
"sample program". Temporarily revoking/granting "privileges could
get clumsy and complicated. Can someone please help?
Thanks in advance - Ray Gaston
(Con Ed - DBA)
The strategy:
1) PLACE TABLESPACES IN UT R/O Mode
2) IBM UNLOADS (for fallback if needed)
3) SQL UPDATES (via the mystery IBM Utility)
4) IF needed RELOADS.
The SQL:
UPDATE TORU.TABLE1_EMPLOYEE A SET CDE_EMPLOYEE = (SELECT
CDE_EMPLOYEE_NEW FROM TORU.TABLE2_EMPL_CONVERT B WHERE
(B.CDE_EMPLOYEE_NO= A.CDE_EMPLOYEE ) ) WHERE EXISTS ( SELECT 1 FROM
TORU.TABLE2_EMPL_CONVERT B2 WHERE B2.CDE_EMPLOYEE_NO =
A.CDE_EMPLOYEE)

=========
Confidentiality Notice: This e-mail communication, and any
attachments, contains confidential and privileged information for
the exclusive use of the recipient(s) named above. If you are not
an intended recipient, or the employee or agent responsible to
deliver it to an intended recipient, you are hereby notified that
you have received this communication in error and that any review,
disclosure, dissemination, distribution or copying of it or its
contents is prohibited. If you have received this communication in
error, please notify me immediately by replying to this message and
delete this communication from your computer. Thank you.

Any opinions, expressed or implied, presented are solely those of
the author and do not necessarily represent the opinions of the
agency or the City.
=========

The IDUG DB2-L Listserv is only part of your membership in IDUG.
DB2-L list archives, the FAQ, and delivery preferences are at
http://www.idug.org/lsidug under
the Listserv tab. While at the site, you can also access the IDUG
Online Learning Center, Tech Library and Code Place, see the latest
IDUG conference information, and much more. If you have not yet
signed up for Basic Membership in IDUG, available at no cost, click
on Member Services at http://www.idug.org/lsms

For combining utilities with SQL, you can use DSNUPROC and use the
utility EXEC SQL to submit your SQL/update statements. After that/
in between you can use the other utilities like copy, runstats etc.
And it is possible to use the lock statement too, like Phil
wrote.

Dear Esteem Listers… Is there an IBM Utility which will
allow us to run SQL UPDATE statements under it?

We need to UPDATE Production data but want to guaranteed that no
user can update the same target tables during our updates (in case
we need to fallback to the UNLOADS taken just before the UPDATES).
This is the only available "window" scenario. DSNTEP2 probably
would not work because it is not itself a utility but only a
"sample program". Temporarily revoking/granting "privileges could
get clumsy and complicated. Can someone please help?

The IDUG DB2-L Listserv is only part of your membership in IDUG.
DB2-L list archives, the FAQ, and delivery preferences are at
HYPERLINK "http://www.idug.org/lsidug"www.idug.org
under the Listserv tab. While at the site, you can also access the
IDUG Online Learning Center, Tech Library and Code Place, see the
latest HYPERLINK "http://www.idug.org/lsconf"IDUG
conference information, and much more.
If you have not yet signed up for Basic Membership in IDUG,
available at no cost, click on HYPERLINK "http://www.idug.org/lsms"Member
Services

The IDUG DB2-L Listserv is only part of your membership in IDUG.
DB2-L list archives, the FAQ, and delivery preferences are at
HYPERLINK "http://www.idug.org/lsidug"www.idug.org
under the Listserv tab. While at the site, you can also access the
IDUG Online Learning Center, Tech Library and Code Place, see the
latest HYPERLINK "http://www.idug.org/lsconf"IDUG
conference information, and much more.
If you have not yet signed up for Basic Membership in IDUG,
available at no cost, click on HYPERLINK "http://www.idug.org/lsms"Member
Services
No virus found in this incoming message.
Checked by AVG Free Edition.
Version: 7.5.516 / Virus Database: 269.19.13/1246 - Release Date:
27/01/2008 18:39

The IDUG DB2-L Listserv is only part of your membership in IDUG.
DB2-L list archives, the FAQ, and delivery preferences are at
http://www.idug.org/lsidug under
the Listserv tab. While at the site, you can also access the IDUG
Online Learning Center, Tech Library and Code Place, see the latest
IDUG conference information, and much more. If you have not yet
signed up for Basic Membership in IDUG, available at no cost, click
on Member Services at http://www.idug.org/lsms

Dear Esteem Listers... Is there an IBM Utility which will allow us
to
run SQL UPDATE statements under it?

We need to UPDATE Production data but want to guaranteed that no
user
can update the same target tables during our updates (in case we
need to
fallback to the UNLOADS taken just before the UPDATES). This is
the
only available "window" scenario. DSNTEP2 probably would not
work
because it is not itself a utility but only a "sample program".
Temporarily revoking/granting "privileges could get clumsy and
complicated. Can someone please help?

The IDUG DB2-L Listserv is only part of your membership in IDUG.
DB2-L
list archives, the FAQ, and delivery preferences are at
www.idug.org
< http://www.idug.org/lsidug >
under the Listserv tab. While at the site,
you can also access the IDUG Online Learning Center, Tech Library
and
Code Place, see the latest IDUG conference information
< http://www.idug.org/lsconf > ,
and much more.
If you have not yet signed up for Basic Membership in IDUG,
available at
no cost, click on Member Services < http://www.idug.org/lsms >
The IDUG DB2-L Listserv is only part of your membership in IDUG.
DB2-L
list archives, the FAQ, and delivery preferences are at
www.idug.org
< http://www.idug.org/lsidug >
under the Listserv tab. While at the site,
you can also access the IDUG Online Learning Center, Tech Library
and
Code Place, see the latest IDUG conference information
< http://www.idug.org/lsconf > ,
and much more.
If you have not yet signed up for Basic Membership in IDUG,
available at
no cost, click on Member Services < http://www.idug.org/lsms >

The IDUG DB2-L Listserv is only part of your membership in IDUG.
DB2-L list archives, the FAQ, and delivery preferences are at
http://www.idug.org/lsidug under
the Listserv tab. While at the site, you can also access the IDUG
Online Learning Center, Tech Library and Code Place, see the latest
IDUG conference information, and much more. If you have not yet
signed up for Basic Membership in IDUG, available at no cost, click
on Member Services at http://www.idug.org/lsms

Paul Ogborne

I was thinking about the UOW here too.? If there is a large volume
of rows then the backout (in the case where your UPDATE has an
error) could take quite a while.? If you have partitioning then you
can 'stream' the process and you can LOCK TABLE at partition level
too which may make the outage even shorter.

Rgds,
Paul.

________________________________________________________________________
AOL's new homepage has launched. Take a tour at http://info.aol.co.uk/homepage/
now.

The IDUG DB2-L Listserv is only part of your membership in IDUG.
DB2-L list archives, the FAQ, and delivery preferences are at
http://www.idug.org/lsidug under
the Listserv tab. While at the site, you can also access the IDUG
Online Learning Center, Tech Library and Code Place, see the latest
IDUG conference information, and much more. If you have not yet
signed up for Basic Membership in IDUG, available at no cost, click
on Member Services at http://www.idug.org/lsms

For combining utilities with SQL, you can use DSNUPROC and use the
utility EXEC SQL to submit your SQL/update statements. After that/
in between you can use the other utilities like copy, runstats etc.
And it is possible to use the lock statement too, like Phil
wrote.

Dear Esteem Listers... Is there an IBM Utility which will allow us
to run SQL UPDATE statements under it?

We need to UPDATE Production data but want to guaranteed that no
user can update the same target tables during our updates (in case
we need to fallback to the UNLOADS taken just before the UPDATES).
This is the only available "window" scenario. DSNTEP2 probably
would not work because it is not itself a utility but only a
"sample program". Temporarily revoking/granting "privileges could
get clumsy and complicated. Can someone please help?

The IDUG DB2-L Listserv is only part of your membership in IDUG.
DB2-L list archives, the FAQ, and delivery preferences are at
www.idug.org <http://www.idug.org/lsidug>
under the Listserv tab. While at the site, you can also access the
IDUG Online Learning Center, Tech Library and Code Place, see the
latest IDUG conference information < http://www.idug.org/lsconf > ,
and much more.
If you have not yet signed up for Basic Membership in IDUG,
available at no cost, click on Member Services < http://www.idug.org/lsms >

The IDUG DB2-L Listserv is only part of your membership in IDUG.
DB2-L list archives, the FAQ, and delivery preferences are at
www.idug.org <http://www.idug.org/lsidug>
under the Listserv tab. While at the site, you can also access the
IDUG Online Learning Center, Tech Library and Code Place, see the
latest IDUG conference information < http://www.idug.org/lsconf > ,
and much more.
If you have not yet signed up for Basic Membership in IDUG,
available at no cost, click on Member Services < http://www.idug.org/lsms >
No virus found in this incoming message.
Checked by AVG Free Edition.
Version: 7.5.516 / Virus Database: 269.19.13/1246 - Release Date:
27/01/2008 18:39

The IDUG DB2-L Listserv is only part of your membership in IDUG.
DB2-L list archives, the FAQ, and delivery preferences are at
www.idug.org <http://www.idug.org/lsidug>
under the Listserv tab. While at the site, you can also access the
IDUG Online Learning Center, Tech Library and Code Place, see the
latest IDUG conference information < http://www.idug.org/lsconf > ,
and much more.
If you have not yet signed up for Basic Membership in IDUG,
available at no cost, click on Member Services < http://www.idug.org/lsms >

The IDUG DB2-L Listserv is only part of your membership in IDUG.
DB2-L list archives, the FAQ, and delivery preferences are at
http://www.idug.org/lsidug under
the Listserv tab. While at the site, you can also access the IDUG
Online Learning Center, Tech Library and Code Place, see the latest
IDUG conference information, and much more. If you have not yet
signed up for Basic Membership in IDUG, available at no cost, click
on Member Services at http://www.idug.org/lsms

For combining utilities with SQL, you can use DSNUPROC and use the
utility EXEC SQL to submit your SQL/update statements. After
that/ in between you can use the other utilities like copy,
runstats etc. And it is possible to use the lock statement too,
like
Phil wrote.

I am using the free version of SPAMfighter for private users.
It has removed 1961 spam emails to date.
Paying users do not have this message in their emails.
Try SPAMfighter < http://www.spamfighter.com/len
> for free now!

The IDUG DB2-L Listserv is only part of your membership in IDUG.
DB2-L list archives, the FAQ, and delivery preferences are at
http://www.idug.org/lsidug under
the Listserv tab. While at the site, you can also access the IDUG
Online Learning Center, Tech Library and Code Place, see the latest
IDUG conference information, and much more. If you have not yet
signed up for Basic Membership in IDUG, available at no cost, click
on Member Services at http://www.idug.org/lsms

For combining utilities with SQL, you can use DSNUPROC and use
the
utility EXEC SQL to submit your SQL/update statements. After that/
in
between you can use the other utilities like copy, runstats etc.
And it
is possible to use the lock statement too, like Phil wrote.

I am using the free version of SPAMfighter for private users.
It has removed 1961 spam emails to date.
Paying users do not have this message in their emails.
Try SPAMfighter < http://www.spamfighter.com/len
> for free now!

The IDUG DB2-L Listserv is only part of your membership in IDUG.
DB2-L
list archives, the FAQ, and delivery preferences are at
www.idug.org
< http://www.idug.org/lsidug >
under the Listserv tab. While at the site,
you can also access the IDUG Online Learning Center, Tech Library
and
Code Place, see the latest IDUG conference information
< http://www.idug.org/lsconf > ,
and much more.
If you have not yet signed up for Basic Membership in IDUG,
available at
no cost, click on Member Services < http://www.idug.org/lsms >

The IDUG DB2-L Listserv is only part of your membership in IDUG.
DB2-L list archives, the FAQ, and delivery preferences are at
http://www.idug.org/lsidug under
the Listserv tab. While at the site, you can also access the IDUG
Online Learning Center, Tech Library and Code Place, see the latest
IDUG conference information, and much more. If you have not yet
signed up for Basic Membership in IDUG, available at no cost, click
on Member Services at http://www.idug.org/lsms

Luis M Martinez Ch

* Why not using DSNTIAD?
* Problems with concurrent access/updates? .... use LOCK TABLE if
you can .. you mentioned the option Read Only.
* You can play with the Isolation level also ( UR for others and/or
RR for you)

"Grainger, Phil" <[login to unmask email]> escribió:
either v5 or v6, I forget

For combining utilities with SQL, you can use DSNUPROC and use the
utility EXEC SQL to submit your SQL/update statements. After that/
in between you can use the other utilities like copy, runstats etc.
And it is possible to use the lock statement too, like Phil
wrote.

Dear Esteem Listers… Is there an IBM Utility which will
allow us to run SQL UPDATE statements under it? We need to UPDATE
Production data but want to guaranteed that no user can update the
same target tables during our updates (in case we need to fallback
to the UNLOADS taken just before the UPDATES). This is the only
available "window" scenario. DSNTEP2 probably would not work
because it is not itself a utility but only a "sample program".
Temporarily revoking/granting "privileges could get clumsy and
complicated. Can someone please help? Thanks in advance - Ray
Gaston
(Con Ed - DBA) The strategy: 1) PLACE TABLESPACES IN UT R/O
Mode
2) IBM UNLOADS (for fallback if needed)
3) SQL UPDATES (via the mystery IBM Utility)
4) IF needed RELOADS. The SQL: UPDATE TORU.TABLE1_EMPLOYEE A
SET CDE_EMPLOYEE = (SELECT CDE_EMPLOYEE_NEW
FROM TORU.TABLE2_EMPL_CONVERT B
WHERE (B.CDE_EMPLOYEE_NO= A.CDE_EMPLOYEE ) )
WHERE EXISTS ( SELECT 1
FROM TORU.TABLE2_EMPL_CONVERT B2
WHERE B2.CDE_EMPLOYEE_NO = A.CDE_EMPLOYEE)

The IDUG DB2-L Listserv is only part of your membership in IDUG.
DB2-L list archives, the FAQ, and delivery preferences are at
www.idug.org under the Listserv tab. While at the site, you can
also access the IDUG Online Learning Center, Tech Library and Code
Place, see the latest IDUG conference information, and much
more.
If you have not yet signed up for Basic Membership in IDUG,
available at no cost, click on Member Services

The IDUG DB2-L Listserv is only part of your membership in IDUG.
DB2-L list archives, the FAQ, and delivery preferences are at
www.idug.org under the Listserv tab. While at the site, you can
also access the IDUG Online Learning Center, Tech Library and Code
Place, see the latest IDUG conference information, and much
more.
If you have not yet signed up for Basic Membership in IDUG,
available at no cost, click on Member Services
No virus found in this incoming message.
Checked by AVG Free Edition.
Version: 7.5.516 / Virus Database: 269.19.13/1246 - Release Date:
27/01/2008 18:39

The IDUG DB2-L Listserv is only part of your membership in IDUG.
DB2-L list archives, the FAQ, and delivery preferences are at
www.idug.org under the Listserv tab. While at the site, you can
also access the IDUG Online Learning Center, Tech Library and Code
Place, see the latest IDUG conference information, and much
more.
If you have not yet signed up for Basic Membership in IDUG,
available at no cost, click on Member Services

The IDUG DB2-L Listserv is only part of your membership in IDUG.
DB2-L list archives, the FAQ, and delivery preferences are at
www.idug.org under the Listserv tab. While at the site, you can
also access the IDUG Online Learning Center, Tech Library and Code
Place, see the latest IDUG conference information, and much
more.
If you have not yet signed up for Basic Membership in IDUG,
available at no cost, click on Member Services

The IDUG DB2-L Listserv is only part of your membership in IDUG.
DB2-L list archives, the FAQ, and delivery preferences are at
http://www.idug.org/lsidug under
the Listserv tab. While at the site, you can also access the IDUG
Online Learning Center, Tech Library and Code Place, see the latest
IDUG conference information, and much more. If you have not yet
signed up for Basic Membership in IDUG, available at no cost, click
on Member Services at http://www.idug.org/lsms