Oninit cdi / Archive
Talk to an expert →

Re: Re: Re: Re: 908: Attempt to connect to databas

Posted in 2014

Topics: Server Administration, Networking & sqlhosts Configuration, Licensing & Editions

Esteban — — source: IIUG Forums & Mailing Lists

okay Giles change your sqlhosts *on the server* instead of the service name just specify the port number 15038 (as I have specified below). Then stop the db server and start it up again. Then try to connect. hdbafdba_tcp onsoctcp hmba04 15038 On 17/12/14 11:27, GILLES TCHAPPI wrote: > Hi Esteban : > > Yes, that is server host sqlhosts. > > The client sqlhosts is : > > #************************************************************************** > # > # Licensed Material - Property Of IBM > # > # "Restricted Materials of IBM" > # > # IBM Informix Dynamic Server > # (c) Copyright IBM Corporation 1996, 2004 All rights reserved. > # > # Title: sqlhosts.demo > # Description: > # Default sqlhosts file for running demos. > # > #************************************************************************** > hdbafdba onipcshm hmba04 hdbafdba_net1 > #hdbafdba_tcp onsoctcp hmba04 hdbafdba_net1 > hdbafdba_tcp onsoctcp hmba04 15038 > hdbafdbasrv_tcp onsoctcp hmba04 hdbaisrv_net1> > I used this port number 15038 in client sqlhosts as this is the port bind to > hdbafdba_net1 in server host /etc/services (see below) : > > informix@hmba04:hdbafdba_tcp:/bases/informix/hdbafdba/arch/logical> cat > /etc/services | grep hdbafdba_net1 > hdbafdba_net1 15038/tcp > > Regards > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > >

↪ replying to Esteban
GILLES — — source: IIUG Forums & Mailing Lists

Hi Esteban, I changed server sqlhosts : informix@hmba04:hdbafdba_tcp:/produits/informix/115FC9/etc> echo $INFORMIXSQLHOSTS /produits/informix/115FC9/etc/sqlhosts.hdbafdba informix@hmba04:hdbafdba_tcp:/produits/informix/115FC9/etc> cat $INFORMIXSQLHOSTS | grep hdbafdba_tcp #hdbafdba_tcp onsoctcp hmba04 hdbafdba_net1 hdbafdba_tcp onsoctcp hmba04 15038 Stopped/Restarted the dataserver : informix@hmba04:hdbafdba_tcp:/produits/informix/115FC9/etc> onstat - IBM Informix Dynamic Server Version 11.50.FC9 -- On-Line -- Up 00:06:40 --1040368 Kbytes But still have the same error on client side : informix@PBDDLX03: # time dbaccess sysmaster << EOF^Jselect count(*) from sysdatabases;^JEOF 908: Attempt to connect to database server (hdbafdba_tcp) failed. ISAM error: record is locked. real 1m0.05s user 0m0.01s sys 0m0.01s informix@PBDDLX03: # Regards

↪ replying to GILLES
Stefan Sammut — — source: IIUG Forums & Mailing Lists

Onstat - l check whether there is logical log available ? Output of Onstat - m And onstat - x Sent from my iPhone > On 17 Dec 2014, at 15:26, GILLES TCHAPPI <giltfr@yahoo.fr> wrote: > > Hi Esteban, > > I changed server sqlhosts : > > informix@hmba04:hdbafdba_tcp:/produits/informix/115FC9/etc> echo > $INFORMIXSQLHOSTS > /produits/informix/115FC9/etc/sqlhosts.hdbafdba > > informix@hmba04:hdbafdba_tcp:/produits/informix/115FC9/etc> cat > $INFORMIXSQLHOSTS | grep hdbafdba_tcp > #hdbafdba_tcp onsoctcp hmba04 hdbafdba_net1 > hdbafdba_tcp onsoctcp hmba04 15038> > Stopped/Restarted the dataserver : > > informix@hmba04:hdbafdba_tcp:/produits/informix/115FC9/etc> onstat - > > IBM Informix Dynamic Server Version 11.50.FC9 -- On-Line -- Up 00:06:40 --> 1040368 Kbytes > > But still have the same error on client side : > > informix@PBDDLX03: # time dbaccess sysmaster << EOF^Jselect count(*) from > sysdatabases;^JEOF > > 908: Attempt to connect to database server (hdbafdba_tcp) failed.> > ISAM error: record is locked.> > real 1m0.05s > user 0m0.01s > sys 0m0.01s > informix@PBDDLX03: # > > Regards > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > Stefan Sammut Manager - Solutions & Innovation [PTL Ltd] Nineteen Twenty Three, Valletta Road Marsa, MRS 3000, MT T +35621445566 +356 99405444 stefan.sammut@ptl.com.mt | www.ptl.com.mt<http://www.ptl.com.mt>; [Facebook]<https://www.facebook.com/PTLMalta/app_349313058487732>; [LinkedIn] <https://www.linkedin.com/company/ptl-ltd?trk=tyah&trkInfo=tarId%3A1401716999276 %2Ctas%3APTL%2Cidx%3A2-3-8> [Twitter] <https://twitter.com/PTL_Malta>; [Youtube] <https://www.youtube.com/channel/UCuXrJBO_54kd9HttG8S89iQ/feed?view_as =public> [Google Plus] <https://plus.google.com/+PTLMalta>;

↪ replying to Stefan Sammut
GILLES TCHAPPI — — source: IIUG Forums & Mailing Lists

Hi, Here are : 1-) an excerpt of onstat -l output : 70000004219eb20 97 U-B---- 40309 3:491573 5120 15 0.29 70000004219eb88 98 U-B---- 40310 3:496693 5120 602 11.76 70000004219ebf0 99 U-B---- 40311 3:501813 5120 27 0.53 70000004219ec58 100 U-B---- 40312 3:506933 5120 5 0.10 70000004219ecc0 101 U-B---- 40313 3:512053 5120 5 0.10 70000004219ed28 102 U-B---- 40314 3:517173 5120 3019 58.96 70000004219ed90 103 U-B---- 40315 3:522293 5120 27 0.53 70000004219edf8 104 U-B---- 40316 3:527413 5120 12 0.23 70000004219ee60 105 U---C-L 40317 3:532533 5120 2445 47.75 70000004219edf8 104 U-B---- 40316 3:527413 5120 12 0.23 70000004219ee60 105 U---C-L 40317 3:532533 5120 2445 47.75 70000004219eec8 106 U-B---- 40168 3:537653 5120 5120 100.00 70000004219ef30 107 U-B---- 40169 3:542773 5120 5120 100.00 70000004219ef98 108 U-B---- 40170 3:547893 5120 5120 100.00 All other log file have 'U-B----' flag 2-) onstat -m : informix@hmba04:hdbafdba_tcp:/bases/informix/hdbafdba/admin/create> onstat -m IBM Informix Dynamic Server Version 11.50.FC9 -- On-Line -- Up 02:31:11 --1040368 Kbytes Message Log File: /bases/informix/hdbafdba/var/bdump/online.log 15:12:42 Logical Recovery Started. 15:12:42 10 recovery worker threads will be started. 15:12:43 Logical Recovery has reached the transaction cleanup phase. 15:12:43 Logical Recovery Complete. 0 Committed, 0 Rolled Back, 0 Open, 0 Bad Locks 15:12:44 Dataskip is now OFF for all dbspaces 15:12:44 SCHAPI: Started dbScheduler thread. 15:12:44 Checkpoint Completed: duration was 0 seconds. 15:12:44 Wed Dec 17 - loguniq 40317, logpos 0x949018, timestamp: 0xea75e0bb Interval: 677 15:12:44 Maximum server connections 0 15:12:44 Checkpoint Statistics - Avg. Txn Block Time 0.000, # Txns blocked 0, Plog used 2, Llog used 1 15:12:44 Increasing # of AIO VPs to 2 15:12:44 Booting Language <spl> from module <> 15:12:44 Loading Module <SPLNULL> 15:12:44 SCHAPI: Started 2 dbWorker threads. 15:12:45 On-Line Mode 3 - the tail of onstat -x output : 700000042150970 A---- 70000004210d9b0 0 - - NOTRANS - 0 700000042150c88 A---- 70000004210c940 0 - - COMMIT - 0 700000042150fa0 A---- 70000004210c108 0 - - COMMIT - 0 7000000421512b8 A---- 70000004210e1e8 0 - - NOTRANS - 0 7000000421515d0 A---- 70000004210e1e8 0 - - COMMIT - 0 7000000421518e8 A---- 70000004210e1e8 1 - - DIRTY - 0 700000042151c00 A---- 70000004210d9b0 1 - - DIRTY - 0 700000042151f18 A---- 70000004210d178 1 - - DIRTY - 0 700000042152548 A---- 70000004210d178 0 - - NOTRANS - 0 140 active, 256 total, 141 maximum concurrent all other transaction been as in the following status : 7000000404b5cb0 A---- 70000004049b310 0 - - COMMIT - 0 Best regards, Gilles

Related threads

Glossary