mahesh_babu76 said:
Thanks. I'll try this. Meanwhile, can you pls let me know the way to find out the host name / service name / port no in any server for a given database?
You should open a db log file to determine this values. For example, here's log file fragment:
Code:
12:39:55 BROKER 0: Multi-user session begin. (333)
12:39:55 BROKER 0: Begin Physical Redo Phase at 0 . (5326)
12:39:55 BROKER 0: Physical Redo Phase Completed at blk 0 off 6145 upd 3. (7161)
12:39:55 BROKER 0: This server is licensed for local logins only. (4393)
12:39:56 BROKER 0: Started for bq41d using TCP, pid 2792. (5644)
12:39:56 BROKER 0: PROGRESS Version 10.0A build 1412 SP01 on WINNT . (4234)
12:39:56 BROKER 0: Server started by ksv on CON:. (4281)
12:39:56 BROKER 0: Started using pid: 2792. (6574)
12:39:56 BROKER 0: Physical Database Name (-db): sports. (4235)
12:39:56 BROKER 0: Database Type (-dt): PROGRESS. (4236)
12:39:56 BROKER 0: Force Access (-F): Not Enabled. (4237)
12:39:56 BROKER 0: Direct I/O (-directio): Not Enabled. (4238)
12:39:56 BROKER 0: Number of Database Buffers (-B): 48. (4239)
12:39:56 BROKER 0: Maximum private buffers per user (-Bpmax): 12. (9422)
12:39:56 BROKER 0: Excess Shared Memory Size (-Mxs): 16385. (4240)
12:39:56 BROKER 0: The shared memory segment is not locked in memory. (10014)
12:39:56 BROKER 0: Current Size of Lock Table (-L): 8192. (4241)
12:39:56 BROKER 0: Hash Table Entries (-hash): 13. (4242)
12:39:56 BROKER 0: Current Spin Lock Tries (-spin): 6000. (4243)
12:39:56 BROKER 0: Number of Semaphore Sets (-semsets): 1. (6526)
12:39:56 BROKER 0: Crash Recovery (-i): Enabled. (4244)
12:39:56 BROKER 0: Database Blocksize (-blocksize): 4096. (6573)
12:39:56 BROKER 0: Delay of Before-Image Flush (-Mf): 3. (4245)
12:39:56 BROKER 0: Before-Image File I/O (-r -R): Reliable. (4247)
12:39:56 BROKER 0: Before-Image Truncate Interval (-G): 60. (4249)
12:39:56 BROKER 0: Before-Image Cluster Size: 524288. (4250)
12:39:56 BROKER 0: Before-Image Block Size: 8192. (4251)
12:39:56 BROKER 0: Number of Before-Image Buffers (-bibufs): 5. (4252)
12:39:56 BROKER 0: BI File Threshold size (-bithold): 0.0 Bytes. (9238)
12:39:56 BROKER 0: BI File Threshold Stall (-bistall): Disabled. (6552)
12:39:56 BROKER 0: After-Image Stall (-aistall): Not Enabled. (4254)
12:39:56 BROKER 0: Number of After-Image Buffers (-aibufs): 5. (4256)
12:39:56 BROKER 0: Storage object cache size (-omsize): 1024 (8527)
12:39:56 BROKER 0: Maximum Number of Clients Per Server (-Ma): 1. (4257)
12:39:56 BROKER 0: Maximum Number of Servers (-Mn): 5. (4258)
12:39:56 BROKER 0: Minimum Clients Per Server (-Mi): 1. (4259)
12:39:56 BROKER 0: Maximum Number of Users (-n): 6. (4260)
12:39:56 BROKER 0: Host Name (-H): ksv. (4261)
12:39:56 BROKER 0: Service Name (-S): bq41d. (4262)
12:39:56 BROKER 0: Network Type (-N): TCP. (4263)
12:39:56 BROKER 0: Character Set (-cpinternal): iso8859-1. (4264)
12:39:56 BROKER 0: Parameter File: Not Enabled. (4282)
12:39:56 BROKER 0: Minimum Port for Auto Servers (-minport): 3000. (5648)
12:39:56 BROKER 0: Maximum Port for Auto Servers (-maxport): 5000. (5649)
12:39:56 BROKER 0: This broker supports both 4GL and SQL server groups. (8865)
12:39:56 BROKER 0: Created shared memory with segment_id: 10878976 (9336)
If you'd like to connect to this db your CONNECT statement should look in such way:
CONNECT VALUE("-db sports -H ksv -S bq41d ").
Pay attention to -S parameter 'bq41ds' is a port name on 'ksv' server but not on yours. To resolve this name you should use 'services' file on 'ksv' server to detect port number and use it instead of 'bq41d'. For example in ksv's 'services' there's a line:
bq41d 2206/tcp
In this case you should change CONNECT statement
CONNECT VALUE("-db sports -H ksv -S 2206 ").