Unable to initialize DBI, err = 2

[Henry Bauer]

We are running the command,

lncount=`hcidbdump -r -f ADT_IN3 | wc -l`

and sporadically we are recieving the response,

Unable to initialize DBI, err = 2.

1. Why is this happening

2. Can it be resolved.

Thanks for any help.

Topic

[Ed Mastascusa]

Hi Henry,

One way (not sure it it is the only way or not) to make this happen is for 2 processes to both be using the same user ID to access the database at the same time. The second process trying to use hcidbdump on the user ID will get locked out with that as the error message.

If you call hcidbdump but don’t specify a user ID with the -U option then the user ID TEST is used as the default.

In AIX (We’re using 5.3 on AIX 5.2) we resolve it by calling with $$ (process pid) for the user ID like this:  

hcidbdump -U $$ etc etc

I’m not sure if $$ works in Windows, but I’m sure you you can use almost any arbitrary string with a reasonably small length

hope this helps

[Author]

Replies