?
Solved

How do I bring capture program of Db2 SQL replication up automatically

Posted on 2010-01-11
9
Medium Priority
?
323 Views
Last Modified: 2013-11-17
Hi Experts,

I have setup SQL replication on AIX servers. The capture program often terminated with no DB connection error.

I require a script that often checks if capture program is up and start them if it is down.
If the capture is intentionally down then it should not be started.
 i have script files that will start the capture in warm mode.

But have to make them automatic. Please help me on this

0
Comment
Question by:jsaravana
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 5
  • 4
9 Comments
 
LVL 37

Expert Comment

by:momi_sabag
ID: 26281591
i think the better approach would be to fix the no DB connection error
why does this error happens?
0
 

Author Comment

by:jsaravana
ID: 26281794
There are some scripts which issue force commands. Hence the db connection is lost.

Are you suggesting to stop the capture and start them after these force commands?

0
 
LVL 37

Accepted Solution

by:
momi_sabag earned 2000 total points
ID: 26281800
that could work
it is always recommended to stop the capture in warm mode and not to force it's connection
0
Prepare for your VMware VCP6-DCV exam.

Josh Coen and Jason Langer have prepared the latest edition of VCP study guide. Both authors have been working in the IT field for more than a decade, and both hold VMware certifications. This 163-page guide covers all 10 of the exam blueprint sections.

 

Author Comment

by:jsaravana
ID: 26281875
Can we stop the capture also in warm mode?

asnccmd capture_server=db capture_schema=ASN stop

this is the command to stop capture rite. Please correct me if I am wrong.

I agree with you view of avoiding DB connection errors. But by writing a script we can always be sure that capture program is running rite. Please provide you views and suggestions on this.
0
 
LVL 37

Expert Comment

by:momi_sabag
ID: 26281963
this looks like the write command to stop the capture
stop it like this, and after you do your force commands, start them again
0
 

Author Comment

by:jsaravana
ID: 26281988
ok Thanks..

Can all users execute the  start and stop capture commands?

if not what is the privilege required to start and stop a capture program.
0
 

Author Comment

by:jsaravana
ID: 26281998
I have placed these commands in a script file. They are given 744 file permissions.
0
 
LVL 37

Assisted Solution

by:momi_sabag
momi_sabag earned 2000 total points
ID: 26282090
i think that it is enought to have permissions to run this file
0
 

Author Closing Comment

by:jsaravana
ID: 31675390
Thanks for you help
0

Featured Post

Application Discovery Service in AWS

In the era of the cloud, customers migrating away from their existing on-premise infrastructure. This requires lots of planning, strategies, and effort to identify their existing resources and determine how best to migrate.  Datacenter migrations happen in four phases -

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Installing FreeBSD… FreeBSD is a darling of an operating system. The stability and usability make it a clear choice for servers and desktops (for the cunning). Savvy?  The Ports collection makes available every popular FOSS application and packag…
Java performance on Solaris - Managing CPUs There are various resource controls in operating system which directly/indirectly influence the performance of application. one of the most important resource controls is "CPU".   In a multithreaded…
Learn several ways to interact with files and get file information from the bash shell. ls lists the contents of a directory: Using the -a flag displays hidden files: Using the -l flag formats the output in a long list: The file command gives us mor…
Learn how to get help with Linux/Unix bash shell commands. Use help to read help documents for built in bash shell commands.: Use man to interface with the online reference manuals for shell commands.: Use man to search man pages for unknown command…
Suggested Courses
Course of the Month13 days, 4 hours left to enroll

777 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question