DB2 / ODBC file availability

9885 pts.
Tags:
AS/400 High Availability
DB2
iSeries
ODBC
We have a new web app that we want to be able to run 24/7.

My question from our web staff is  "when the data is available? ".

There are 2 situations I can think of that will pose an issue.

1. when we are running file back ups, it most likely will not be available due to object locks. We could do a save while active, but we are not comfortable with that option.

2. After an IPL of the i-series how soon after are the data bases available?

What subsystems need to be up to allow the communication connection?

We are trying to narrow down the window when we cannot provide the connection to the data.



Software/Hardware used:
i-series, as/400, V5R4M5

Answer Wiki

Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Discuss This Question: 4  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • TomLiotta
    Start with what should be the easy area -- the IPLs. Why be especially concerned about them? In particular, they should be infrequent enough to be scheduled well in advance. But perhaps you have some constraints that make them more necessary. So, what model system? What processor feature? How much memory? DASD? DASD utilization? Tom
    125,585 pointsBadges:
    report
  • ToddN2000
    Here is some of the info you asked about Tom Model 520 , proc feature 7734, memory 7704.76g and storage 668.8g at around 76% utilization. We IPL weekly do to the fact we are running a live and test environment for 2 locations on this machine and currenty have a 3rd test environment for a software package upgrade to be rolled out in the next month. Our web people just want to know when they can write to a file on the i-series and have the trigger program run and process their request. During back-ups we know is out of the question. Their question is after the IPL, which happens mostly on a Friday night but some times Saturday morning, when can they write to the file to cause the trigger program to launch.
    9,885 pointsBadges:
    report
  • TomLiotta
    memory 7704.76g I assume that's a typo -- "g" s/b "M"? (If not,... WOW!) :-) Is that figure from WRKSHRPOOL? After an IPL of the i-series how soon after are the data bases available? Technically, you're the only one who can answer that. You know how your startup program is coded, and we don't. Your tables should be available a few seconds after you start your *DATABASE server. Run this command and post back with the PWRDWN time at the start of the dumped space along with the final time at the end of the space:
    CALL PGM(QWCCRTEC)
    The specs you provided plus the time span from the IPL timing dump should fill in most gaps. I'm not clear why the IPLs are done, but your procedures are what they are. And if save-while-active isn't acceptable, then we can still work out timings. BTW, you might review your Management Central (MgtC -- job QYPSJSVR) joblogs. You should find one or more SQL7908 messages. Those result from MgtC establishing SQL CLI connections to the *DATABASE server. The first successful connection by MgtC will probably be pretty close to the earliest possible connection time. It may help establish first-approximation boundaries. Tom
    125,585 pointsBadges:
    report
  • ToddN2000
    yep, it was a typo...Thanks for the feedback. I'll have to try a few of these as long as our security does not restrict me from the commands or programs. We will be doing an IPL tonight so i'll log in remotelt and try the QWCCRTEC command and see if that help me get further. Thanks again
    9,885 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following