Check the record counts of a physical file from single system which exists on 2 systems.

305 pts.
Tags:
AS/400
MIMIX
Physical File
Hi. I have a PF which exists on 2 different systems. The systems are in replication using MIMIX. During DR drill (system role swap) we are comparing the record counts of some PFs. For comparison we are using "SQL Interactive Sessions". Is there a way to get the record counts of these PFs which are on 2 different systems from single system. It is like running commands on single system & get the counts of files from both the system. -Ketan

Software/Hardware used:
AS400/OS400

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: 2  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
    You can run SELECT COUNT(*) from the file on the local system and record the count. Then CONNECT TO the remote database and run the same SELECT COUNT(*) statement again. Record the second count and compare the two values. . Is there a problem? Does an error occur? . Tom
    125,585 pointsBadges:
    report
  • Ketan19
    Hi, CONNECT TO worked & I am able to retrieve the record count PF from remote system. Thanks for the help. . -Ketan
    305 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