If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Database Server Software > DB2 > Getting "DBI1309E System error" when db2set command is executed

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 10-24-08, 02:56
grofaty grofaty is offline
Registered User
 
Join Date: Jan 2003
Posts: 1,570
Getting "DBI1309E System error" when db2set command is executed

Hi,
on DB2 v9.5 for Linux. DB2 was working well as locally as remotely. But something has changed and db2set command does not display DB2COMM parameter that is required to access db2 remotely. Locally DB2 works fine without any error.

So I tried to execute command:
Code:
db2set DB2COMM=TCPIP
and got error:
=========
DBI1309E System error.

Explanation:

The tool encountered an operating system error.

User response:

A system error was encountered during registry access. Ensure that there
is enough space on the file system where the registry is located, and
that there is a valid LAN connection if the registry is remote.
=========

I have checked disk is not full and computer can be accessed by ping command locally and remotely.

Any idea what is wrong?
Thanks,
Grofaty
Reply With Quote
  #2 (permalink)  
Old 10-24-08, 09:21
n_i n_i is offline
:-)
 
Join Date: Jun 2003
Location: Toronto, Canada
Posts: 4,449
See if ~/sqllib/profile.env is accessible to the instance owner and not corrupted (it should be a regular ascii text file).
Reply With Quote
  #3 (permalink)  
Old 03-06-10, 19:53
tylutki tylutki is offline
Registered User
 
Join Date: Mar 2010
Posts: 1
Needed to be root

I tried this command from the db2inst1 user, but it only seemed to work for me when I was root. (The profile.env file was fine.)
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On