title: Informix error in Perl: ISAM: 107: ISAM error: record is locked. at test_db_connectivity.pl line 14
body: <p>I'm trying to connect to our database in our production environment.  I am getting the <strong>107 ISAM error:  record is locked</strong> .  I have checked various articles on what it could be, but no luck.  I double checked the database details with our DBA and the information is correct.</p>
  
  <p>FYI - Also the first error previous to the "record is locked" error I received was <strong>SQL: -931: Cannot locate web1_tcp service/tcp service in /etc/services. at test_db_connectivity.pl line 13.</strong> .  I worked with our SA to get that entered and that is no longer appearing.  Can anyone offer any guidance on the ISAM 107 error?  Is my connection string wrong?  There shouldn't be a lock because I am not even opening a connection to the database.</p>
  
  <p><strong>test_db_connectivity.pl:</strong></p>
  
  <pre><code>#/usr/bin/perl -w
  
  use DBI;
  use strict;
  use DBI qw(:sql_types);
  use DBD::Informix qw(:ix_types);
  
      my $driver = "Informix";
      my $database = "web1";
      my $dsn = "DBI:$driver:dbname=$database";
      my $userid = "user";
      my $password = "password";
      print "I got this far!\n";
      my $dbh = DBI-&gt;connect($dsn, $userid, $password, {RaiseError =&gt; 1}) or      die $DBI::errstr;
      print "Opened db successfully\n";
      $dbh-&gt;disconnect();
  </code></pre>
  
  <p><strong>Some of the variables set:</strong></p>
  
  <pre><code>export INFORMIXDIR=/opt/informix
  
  export   LD_LIBRARY_PATH=$LD_LIBRARY_PATH:$INFORMIXDIR/lib:$INFORMIXDIR/lib/cli:$INFORMIXDIR/lib/esql:$INFORMIXDIR/lib/tools
  
  export INFORMIXSERVER=web1
  </code></pre>
  
  <p><strong>INFORMIX SQLHOSTS FILE:</strong></p>
  
  <p>#dbservername   nettype         hostname        servicename    options</p>
  
  <p>web1           onsoctcp        10.199.***.*    web1dev1_tcp</p>
  
  <p><strong>etc/services FILE:</strong></p>
  
  <p>web1dev1_tcp  1533/tcp                # Port assigned to database</p>
  
  <h1>virtual-places  1533/tcp                # Virtual Places Software</h1>
  
  <p>web1dev1_tcp  1533/udp                # Port assigned to database</p>