its not that bad, they provide you with samples to change and run.
"Ron DiNardo "
<db2udbdba-ezmlms
hield-x17312647.x To
[Email Address Removed] "LazyDBA Discussion"
a.com> <[Email address protected]
cc
11/22/2006 09:00
AM Subject
RE: More on replication
Do you have to go through a lengthy install and configuration of Websphere
MQ to use Q Replication?
Glossing through what documentation I can find, it looks like a good pain
in the neck!!
-----Original Message-----
From: DANIEL CALLAHAN [mailto:db2udbdba-ezmlmshield-x24016960.[Email
address protected]
Sent: 22 November 2006 13:26
To: LazyDBA Discussion
Subject: RE: More on replication
with q -replication in uni-directional mode, you can alter the source and
then send a "signal" to the replication that you added a column and it
will take effect.
"Ron DiNardo "
<db2udbdba-ezmlms
hield-x48446149.x To
[Email Address Removed] "LazyDBA Discussion"
a.com> <[Email address protected]
cc
11/22/2006 08:14
AM Subject
RE: More on replication
But the question really is whether I can go to my source, execute a
create/alter table statement then go to my target a few seconds later and
see the result of the create/alter table statement.
With SQL Replication I'm thinking the answer is no. What about with Q
replication? I've tested this out with the Oracle equivalent of Q
replication and it does that.
-----Original Message-----
From: DANIEL CALLAHAN [mailto:db2udbdba-ezmlmshield-x10830300.[Email
address protected]
Sent: 22 November 2006 12:46
To: LazyDBA Discussion
Subject: Re: More on replication
you can replicate tables, parts of tables, views and use stored procedures
as targets in q-replication unidirectional.
"Ron DiNardo "
<db2udbdba-ezmlms
hield-x87691904.x To
[Email Address Removed] "LazyDBA Discussion"
a.com> <[Email address protected]
cc
11/22/2006 04:43
AM Subject
More on replication
Quoting from below: "I prefer HADR, personally. Much easier to administer
(e.g. adding a new column is replicated automatically in HADR - with SQL
replication it's quite tricky) and less overhead."
This is an interesting thing with DB2's SQL replication or trigger-based
replication from other vendors. You can no longer go out and execute
simple DDL anymore.
I've done these things on another RDBMS using their similar queue-based
replication:
1. Set up queue-style replication
2. Say "replicate entire schema" or "replicate entire database"
3. Issue "create table ... " on source
4. Immediately see the table on target
Does Q Replication accept DDL and then replicate it in this fashion?
-----Original Message-----
From: hsteiner [mailto:db2udbdba-ezmlmshield-x42740719.[Email address
protected]
Sent: 21 November 2006 18:43
To: LazyDBA Discussion
Subject: Re: SQL Replication Apply process "Presumed Down"
1) This happens when certain files ending in .IPC are accidentally removed
(perhaps because they were written to temp directories). Our experience
is that this is not really a problem, however, SQL replication is
functioning. If you wish to restart apply, you can do a psef asnapply (or
asncap, etc.) and do a kill -9 on the "zombie" processes assumed down, and
then re-start APPLY.
2) Yes, we use it on a dozen databases or more. While it isn't as "robust"
as I would like, it does work if you understand its mechanisms and you
tweak the right parameters.
3) I prefer HADR, personally. Much easier to administer (e.g. adding a new
column is replicated automatically in HADR - with SQL replication it's
quite tricky) and less overhead.
Best, Hal Steiner
IBM Certified Advanced Database Administrator for DB2 UDB
-----Original Message-----
From: db2udbdba-ezmlmshield-x75447272.[Email address protected]
To: [Email address protected]
Sent: Tue, 21 Nov 2006 11:35 AM
Subject: SQL Replication Apply process "Presumed Down"
1. Does anyone have any tips (or can point me to any documentation
whatsoever) to trouble shoot a "Presumed Down" status for the apply
process?
2. Does anyone out there even use SQL Replication?
3. Does anyone out there even have any thoughts about replication?
It seems whenever Replication is mentioned everything goes quiet ... no
matter what forum I put it in.
-----Original Message-----
From: Padhi Sankar [mailto:db2udbdba-ezmlmshield-x5990128.[Email address
protected]
Sent: 21 November 2006 15:56
To: LazyDBA Discussion
Subject: RE: please, example TUNCATE TABLE for DB2...
-- Truncate table in DB2
db2 "import from /dev/null of del replace into SCHEMA.TABLENAME"
OR
-- If you do not specify nonrecoverable then you must backup the
db/tblspace
db2 "load from /dev/null of IXF replace into SCHEMA.TABLENAME
nonrecoverable"
db2 "SET INTEGRITY FOR SCHEMA.TABLENAME IMMEDIATE CHECKED"
-----Original Message-----
From: Edwards Ed
[mailto:db2udbdba-ezmlmshield-x66297704.[Email address protected]
Sent: Tuesday, November 21, 2006 10:02 AM
To: LazyDBA Discussion
Subject: RE: please, example TUNCATE TABLE for DB2...
ALTER TABLE EDWARDE.CL_SCHED ACTIVATE NOT LOGGED INITIALLY EMPTY TABLE;
COMMIT;
You must run the "COMMIT" immediately after the first statement.
Please take a few minutes to provide feedback on the quality of service you
received. The Department of Education values your feedback as a customer.
Commissioner John L. Winn is committed to continuously assessing and
improving the level and quality of services provided to you by Department
staff. Simply use the link below. Thank you in advance for completing the
survey.
http://data.fldoe.org/cs/default.cfm?staff=Ed.[Email address protected]
-----Original Message-----
From: Daniel Andres Manque Paineo
[mailto:db2udbdba-ezmlmshield-x52642068.[Email address protected]
Sent: Tuesday, November 21, 2006 10:09 AM
To: LazyDBA Discussion
Subject: please, example TUNCATE TABLE for DB2...
Hi gurús...
In oracle:
${ORACLE_HOME}/bin/sqlplus -s << EOF 2>&1 > ${ORACLOG} $USUARIO set
serveroutput on; truncate table tablename; commit; exit EOF
need example of Truncate table for DB2, please.
Thank's.
-----Mensaje original-----
De: Ron DiNardo [mailto:db2udbdba-ezmlmshield-x91235034.[Email
address protected]
Enviado el: Lun 20-11-2006 0:37
Para: LazyDBA Discussion
CC:
Asunto: DB2 V9 SQL replication
I've set up SQL replication using the V9 Replication Center using 2
linux boxes. Box 1 is capturing 1 table and I'd like to replicate it
to
Box 2. I can't get any data to replicate however. I can't find any
real
troubleshooting information in searching the IBM site or the web at
large. Maybe there's something I'm missing??
I'm getting "presumed down" for the Apply process. How does one even
troubleshoot such a thing? I have no idea what actions to take to
figure
out (1) IF it's really down (as it's only "presumed down" according to
the err message) and (2) what to do to get it up and running if it
really is actually down.
Can anyone help??
______________________________________________________________________
This email has been scanned by the MessageLabs Email Security System.
---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY To post a dba
job:
http://jobs.lazydba.com To Subscribe : http://www.LazyDBA.com To
unsubscribe:
http://www.lazydba.com/unsubscribe.html
---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY To post a dba
job:
http://jobs.lazydba.com To Subscribe : http://www.LazyDBA.com To
unsubscribe:
http://www.lazydba.com/unsubscribe.html
---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY To post a dba
job:
http://jobs.lazydba.com To Subscribe : http://www.LazyDBA.com To
unsubscribe:
http://www.lazydba.com/unsubscribe.html
______________________________________________________________________
This email has been scanned by the MessageLabs Email Security System.
______________________________________________________________________
This email has been scanned by the MessageLabs Email Security System.
---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY To post a dba
job: http://jobs.lazydba.com To Subscribe : http://www.LazyDBA.com To
unsubscribe: http://www.lazydba.com/unsubscribe.html
________________________________________________________________________
Check out the new AOL. Most comprehensive set of free safety and security
tools, free access to millions of high-quality videos from across the web,
free AOL Mail and more.
---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY To post a dba
job: http://jobs.lazydba.com To Subscribe : http://www.LazyDBA.com To
unsubscribe: http://www.lazydba.com/unsubscribe.html
______________________________________________________________________
This email has been scanned by the MessageLabs Email Security System.
______________________________________________________________________
This email has been scanned by the MessageLabs Email Security System.
---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY To post a dba
job: http://jobs.lazydba.com To Subscribe : http://www.LazyDBA.com To
unsubscribe: http://www.lazydba.com/unsubscribe.html
---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY To post a dba
job: http://jobs.lazydba.com To Subscribe : http://www.LazyDBA.com To
unsubscribe: http://www.lazydba.com/unsubscribe.html
______________________________________________________________________
This email has been scanned by the MessageLabs Email Security System.
______________________________________________________________________
This email has been scanned by the MessageLabs Email Security System.
---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY To post a dba
job: http://jobs.lazydba.com To Subscribe : http://www.LazyDBA.com To
unsubscribe: http://www.lazydba.com/unsubscribe.html
---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY To post a dba
job: http://jobs.lazydba.com To Subscribe : http://www.LazyDBA.com To
unsubscribe: http://www.lazydba.com/unsubscribe.html
______________________________________________________________________
This email has been scanned by the MessageLabs Email Security System.
______________________________________________________________________
This email has been scanned by the MessageLabs Email Security System.
---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
DB2 & UDB email list listserv db2-l LazyDBA home page