Forums | Admin

Discussion Forums: open-discussion

Start New Thread Start New Thread
Message: 62649
BY: Francesco Pellegrini (kranz)
DATE: 2008-12-01 08:19
SUBJECT: RE: Problems with connection to iseries DB

 

Hi Preveen,

thanks to your explanation I now have "fixed" the problem (aka "the user can work") by commenting out the two entries in database.yml for HOST and PORT, so db connection and authentication takes place in the "else" branch.

This does not helps me explain what happened and why the other way it does not work (and it has been working until last week).

Here you find the output of the command launched from the rails server where db2 connect is installed:

root@srvwebapp:~# db2 get cli cfg

Section: tstcli1x
-------------------------------------------------
uid=userid
pwd=*****
autocommit=0
TableType='TABLE','VIEW','SYSTEM TABLE'

Section: tstcli2x
-------------------------------------------------
SchemaList='OWNER1','OWNER2',CURRENT SQLID

Section: MyVeryLongDBALIASName
-------------------------------------------------
dbalias=dbalias3
SysSchema=MYSCHEMA


I do not have access to the iSeries where the db2 server is running and have to ask to someone to do that for me.

Do you know if the command

db2 get dbm cfg

can be issued from command line in a iSeries "green terminal" session?


Thread View

Thread Author Date
Problems with connection to iseries DBFrancesco Pellegrini2008-11-28 10:39
      RE: Problems with connection to iseries DBPraveen Devarao2008-11-28 12:35
            RE: Problems with connection to iseries DBFrancesco Pellegrini2008-11-28 22:36
            RE: Problems with connection to iseries DBFrancesco Pellegrini2008-11-28 22:42
                  RE: Problems with connection to iseries DBPraveen Devarao2008-11-30 16:01
                        RE: Problems with connection to iseries DBFrancesco Pellegrini2008-12-01 08:19
                              RE: Problems with connection to iseries DBPraveen Devarao2008-12-01 13:19
                                    RE: Problems with connection to iseries DBFrancesco Pellegrini2008-12-01 15:38
                                          RE: Problems with connection to iseries DBPraveen Devarao2008-12-02 06:34
                                                RE: Problems with connection to iseries DBPraveen Devarao2008-12-02 07:05
                                                      RE: Problems with connection to iseries DBFrancesco Pellegrini2008-12-02 09:12
                                                            RE: Problems with connection to iseries DBFrancesco Pellegrini2008-12-02 09:26
                                                            RE: Problems with connection to iseries DBPraveen Devarao2008-12-02 10:07
                                                                  RE: Problems with connection to iseries DBFrancesco Pellegrini2008-12-02 10:23
                                                                  RE: Problems with connection to iseries DBPraveen Devarao2008-12-02 10:40
                                                                        RE: Problems with connection to iseries DBFrancesco Pellegrini2008-12-02 12:21
                                                                              RE: Problems with connection to iseries DBPraveen Devarao2008-12-02 12:36

Post a followup to this message