1 2 Previous Next 21 Replies Latest reply: Sep 3, 2012 8:29 AM by user12204065 Go to original post RSS
      • 15. Re: TimesTen 7.0.5 CS connection question
        581561
        2064496: 6287587: execve("/usr/bin/tr", 0x20011AC8, 0x20011B58) argc: 3
        2064496: 6287587: argv: tr ABCDEFGHIJKLMNOPQRSTUVWXYZ abcdefghijklmnopqrstuvwxyz
        2064496: 6287587: envp: _=/usr/bin/tr DB_CRYPT=/usr/lib/lines/dbfile.txt LANG=en_US
        2064496: 6287587: LOGIN=hxy ENCINA_BINDING_FILE=/var/cics_servers/server_bindings
        2064496: 6287587: RPC_SUPPORTED_PROTSEQS=ncadg_ip_udp
        2064496: 6287587: PATH=/opt/IBM/informix//bin:/opt/oracle/oracle10g/bin:/usr/java14/bin:/usr/mqm/bin:/usr/vac/bin:/usr/vacpp
        /bin:/usr/local/bin:/opt/freeware/bin:/usr/bin:/etc:/usr/sbin:/usr/ucb:/home/hxy/bin:/usr/bin/X11:/sbin:/home/timesten/TimesTen/tt75
        /bin
        2064496: 6287587: NLS_LANG=American_America.ZHS16GBK XERCES_HOME=/home/hxy/xercesc
        2064496: 6287587: ORACLE_BASE=/opt/oracle XERCESCROOT=/home/hxy/xercesc
        2064496: 6287587: LC__FASTMSG=true
        2064496: 6287587: CLASSPATH=/opt/oracle/oracle10g/jlib:/usr/java14/lib/tools.jar:/usr/java14/lib/dt.jar
        2064496: 6287587: LOGNAME=hxy MAIL=/usr/spool/mail/hxy ORACLE_SID=***15xd
        2064496: 6287587: LOCPATH=/usr/lib/nls/loc USER=hxy AUTHSTATE=compat SHLVL=1
        2064496: 6287587: DCE_USE_WCHAR_NAMES=1 ABM_CPP_HOME=/home/hxy/svn/ABM_C++
        2064496: 6287587: AXIS2_HOME=/usr/local/axis2-1.1 SHELL=/usr/bin/bash
        2064496: 6287587: OCS_HOME=/home/hxy/svn/ ORACLE_TERM=vt100 ODMDIR=/etc/objrepos
        2064496: 6287587: SMS_HOME=/home/hxy/svn/c++ CICS_HOSTS=***
        2064496: 6287587: ACE_HOME=/home/yuxb/ACE_wrappers HOME=/home/hxy
        2064496: 6287587: BOSS_CPP_HOME=/home/hxy/svn/c++ INFORMIXDIR=/opt/IBM/informix/
        2064496: 6287587: TERM=vt100 MAILMSG=[YOU HAVE NEW MAIL]
        2064496: 6287587: ORACLE_HOME=/opt/oracle/oracle10g ONCONFIG=onconfig.test15
        2064496: 6287587: PWD=/home/hxy TZ=BEIST-8 TT_HOME=/home/timesten/TimesTen/tt75
        2064496: 6287587: INFORMIXSERVER=test15
        2064496: 6287587: LIBPATH=/home/timesten/TimesTen/tt75/lib:/lib:/opt/oracle/oracle10g/jdk/jre/bin:/opt/oracle/oracle10g/jdk/
        jre/bin/classic:/opt/oracle/oracle10g/lib:/opt/IBM/informix//lib:/opt/IBM/informix//lib/esql:/opt/IBM/informix//lib/esql:/home/times
        ten/TimesTen/tt75/lib:/home/hxy/svn/lib
        2064496: 6287587: LD_LIBRARY_PATH=/opt/oracle/oracle10g/lib:/opt/oracle/oracle10g/network/lib
        2064496: 6287587: NLSPATH=/usr/lib/nls/msg/%L/%N:/usr/lib/nls/msg/%L/%N.cat
        2064496: 6287587: sbrk(0x00000000) = 0x200011E4
        2064496: 6287587: vmgetinfo(0x2FF219A0, 7, 16) = 0
        2064496: 6287587: sbrk(0x00000000) = 0x200011E4
        2064496: 6287587: sbrk(0x0000000C) = 0x200011E4
        2064496: 6287587: __libc_sbrk(0x00000000) = 0x200011F0
        2064496: 6287587: getuidx(4) = 259
        2064496: 6287587: getuidx(2) = 259
        2064496: 6287587: getuidx(1) = 259
        2064496: 6287587: getgidx(4) = 201
        2064496: 6287587: getgidx(2) = 201
        2064496: 6287587: getgidx(1) = 201
        2064496: 6287587: __loadx(0x01000080, 0x2FF1DF40, 0x00003E80, 0x2FF21EE0, 0x2FF22DD1) = 0xD0146130
        2064496: 6287587: __loadx(0x01000180, 0x2FF1DF40, 0x00003E80, 0xF03B8774, 0xF03B86A4) = 0xF0459C60
        2064496: 6287587: __loadx(0x07080000, 0xF03B8744, 0xFFFFFFFF, 0xF0459C60, 0x00000000) = 0xF045AB90
        2064496: 6287587: __loadx(0x07080000, 0xF03B8684, 0xFFFFFFFF, 0xF0459C60, 0x00000000) = 0xF045AB9C
        2064496: 6287587: __loadx(0x07080000, 0xF03B8754, 0xFFFFFFFF, 0xF0459C60, 0x00000000) = 0xF045ABCC
        2064496: 6287587: __loadx(0x07080000, 0xF03B8694, 0xFFFFFFFF, 0xF0459C60, 0x00000000) = 0xF045ABD8
        2064496: 6287587: __loadx(0x07080000, 0xF03B8714, 0xFFFFFFFF, 0xF0459C60, 0x00000000) = 0xF045ABA8
        2064496: 6287587: __loadx(0x07080000, 0xF03B86B4, 0xFFFFFFFF, 0xF0459C60, 0x00000000) = 0xF045ABC0
        2064496: 6287587: __loadx(0x07080000, 0xF03B8724, 0xFFFFFFFF, 0xF0459C60, 0x00000000) = 0xF045ABE4
        2064496: 6287587: __loadx(0x07080000, 0xF03B8734, 0xFFFFFFFF, 0xF0459C60, 0x00000000) = 0xF045AC14
        2064496: 6287587: __loadx(0x07080000, 0xF03B86C4, 0xFFFFFFFF, 0xF0459C60, 0x00000000) = 0xF045ABFC
        2064496: 6287587: __loadx(0x07080000, 0xF03B86D4, 0xFFFFFFFF, 0xF0459C60, 0x00000000) = 0xF045AC98
        2064496: 6287587: getuidx(4) = 259
        2064496: 6287587: getuidx(2) = 259
        2064496: 6287587: getuidx(1) = 259
        2064496: 6287587: getgidx(4) = 201
        2064496: 6287587: getgidx(2) = 201
        2064496: 6287587: getgidx(1) = 201
        2064496: 6287587: __loadx(0x01000080, 0x2FF1DF40, 0x00003E80, 0x2FF21EE0, 0x2FF22DD1) = 0xD0146130
        2064496: 6287587: getuidx(4) = 259
        2064496: 6287587: getuidx(2) = 259
        2064496: 6287587: getuidx(1) = 259
        2064496: 6287587: getgidx(4) = 201
        2064496: 6287587: getgidx(2) = 201
        2064496: 6287587: getgidx(1) = 201
        2064496: 6287587: __loadx(0x01000080, 0x2FF1DF40, 0x00003E80, 0x2FF21EE0, 0x2FF22DD1) = 0xD0146130
        2064496: 6287587: getuidx(4) = 259
        2064496: 6287587: getuidx(2) = 259
        2064496: 6287587: getuidx(1) = 259
        2064496: 6287587: getgidx(4) = 201
        2064496: 6287587: getgidx(2) = 201
        2064496: 6287587: getgidx(1) = 201
        2064496: 6287587: __loadx(0x01000080, 0x2FF1DF40, 0x00003E80, 0x2FF21EE0, 0x2FF22DD1) = 0xD0146130
        2064496: 6287587: getuidx(4) = 259
        2064496: 6287587: getuidx(2) = 259
        2064496: 6287587: getuidx(1) = 259
        2064496: 6287587: getgidx(4) = 201
        2064496: 6287587: getgidx(2) = 201
        2064496: 6287587: getgidx(1) = 201
        2064496: 6287587: __loadx(0x01000080, 0x2FF1DF40, 0x00003E80, 0x2FF21EE0, 0x2FF22DD1) = 0xD0146130
        2064496: 6287587: getuidx(4) = 259
        2064496: 6287587: getuidx(2) = 259
        2064496: 6287587: getuidx(1) = 259
        2064496: 6287587: getgidx(4) = 201
        2064496: 6287587: getgidx(2) = 201
        2064496: 6287587: getgidx(1) = 201
        2064496: 6287587: __loadx(0x01000080, 0x2FF1DF40, 0x00003E80, 0x2FF21EE0, 0x2FF22DD1) = 0xD0146130
        2064496: 6287587: access("/usr/lib/nls/msg/en_US/tr.cat", 0) = 0
        2064496: 6287587: _getpid()                              = 2064496
        2064496: 6287587: kioctl(0, 22528, 0x00000000, 0x00000000) Err#25 ENOTTY
        2064496: 6287587: kread(0, " / h o m e / t i m e s t".., 4096) = 42
        2064496: 6287587: kioctl(1, 22528, 0x00000000, 0x00000000) Err#25 ENOTTY
        2064496: 6287587: kread(0, " / h o m e / t i m e s t".., 4096) = 0
        5951600: 17518639: kread(3, " / h o m e / t i m e s t".., 4096)2064496: 6287587: kwrite(1, " / h o m e / t i m e s t".., 42) = 42 =
        42

        2064496: 6287587: kfcntl(2, F_GETFL, 0xF041C190) = 25951600: 17518639: _sigaction(20, 0x00000000, 0x2FF1ED80) = 0
        2064496: 6287587: _exit(0)                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   
        • 16. Re: TimesTen 7.0.5 CS connection question
          581561
          5951600: 17518639: _sigaction(20, 0x2FF1ED80, 0x2FF1ED90) = 0
          5951600: 17518639: kwaitpid(0x2FF1EDF0, -1, 7, 0x00000000, 0x00000000) = 0
          5951600: 17518639: _sigaction(20, 0x00000000, 0x2FF1ED80) = 0
          5951600: 17518639: _sigaction(20, 0x2FF1ED80, 0x2FF1ED90) = 0
          5951600: 17518639: kread(3, " / h o m e / t i m e s t".., 4096) = 0
          5951600: 17518639: _sigaction(20, 0x00000000, 0x2FF1FEF0) = 0
          5951600: 17518639: _sigaction(20, 0x2FF1FEF0, 0x2FF1FF00) = 0
          5951600: 17518639: kwaitpid(0x2FF1FF60, -1, 6, 0x00000000, 0x00000000) = 2064496
          5951600: 17518639: _sigaction(20, 0x00000000, 0x2FF1FEF0) = 0
          5951600: 17518639: _sigaction(20, 0x2FF1FEF0, 0x2FF1FF00) = 0
          5951600: 17518639: close(3) = 0
          5951600: 17518639: _sigaction(25, 0x00000000, 0x2FF22050) = 0
          5951600: 17518639: _sigaction(25, 0x2FF22050, 0x2FF22060) = 0
          5951600: 17518639: _sigaction(3, 0x00000000, 0x2FF22050)        = 0
          5951600: 17518639: _sigaction(3, 0x2FF22050, 0x2FF22060)        = 0
          5951600: 17518639: execve("/home/timesten/TimesTen/tt75/bin/ttIsqlCSCmd", 0x20095418, 0x20099A88) argc: 2
          5951600: 17518639: argv: /home/timesten/TimesTen/tt75/bin/ttIsqlCSCmd cs75
          5951600: 17518639: envp: _=/home/timesten/TimesTen/tt75/bin/ttIsqlCSCmd
          5951600: 17518639: DB_CRYPT=/usr/lib/lines/dbfile.txt LANG=en_US LOGIN=hxy
          5951600: 17518639: ENCINA_BINDING_FILE=/var/cics_servers/server_bindings
          5951600: 17518639: RPC_SUPPORTED_PROTSEQS=ncadg_ip_udp
          5951600: 17518639: PATH=/opt/IBM/informix//bin:/opt/oracle/oracle10g/bin:/usr/java14/bin:/usr/mqm/bin:/usr/vac/bin:/usr/vacpp/bin:/
          usr/local/bin:/opt/freeware/bin:/usr/bin:/etc:/usr/sbin:/usr/ucb:/home/hxy/bin:/usr/bin/X11:/sbin:/home/timesten/TimesTen/tt75/bin
          5951600: 17518639: NLS_LANG=American_America.ZHS16GBK XERCES_HOME=/home/hxy/xercesc
          5951600: 17518639: ORACLE_BASE=/opt/oracle XERCESCROOT=/home/hxy/xercesc
          5951600: 17518639: LC__FASTMSG=true
          5951600: 17518639: CLASSPATH=/opt/oracle/oracle10g/jlib:/usr/java14/lib/tools.jar:/usr/java14/lib/dt.jar
          5951600: 17518639: LOGNAME=hxy MAIL=/usr/spool/mail/hxy ORACLE_SID=test15xd
          5951600: 17518639: LOCPATH=/usr/lib/nls/loc USER=hxy AUTHSTATE=compat SHLVL=1
          5951600: 17518639: DCE_USE_WCHAR_NAMES=1 ABM_CPP_HOME=/home/hxy/svn/
          5951600: 17518639: AXIS2_HOME=/usr/local/axis2-1.1 SHELL=/usr/bin/bash
          5951600: 17518639: OCS_HOME=/home/hxy/svn/ ORACLE_TERM=vt100 ODMDIR=/etc/objrepos
          5951600: 17518639: SMS_HOME=/home/hxy/svn/c++ CICS_HOSTS=***
          5951600: 17518639: ACE_HOME=/home/yuxb/ACE_wrappers HOME=/home/hxy
          5951600: 17518639: BOSS_CPP_HOME=/home/hxy/svn/c++ INFORMIXDIR=/opt/IBM/informix/
          5951600: 17518639: TERM=vt100 MAILMSG=[YOU HAVE NEW MAIL]
          5951600: 17518639: ORACLE_HOME=/opt/oracle/oracle10g ONCONFIG=onconfig.test15
          5951600: 17518639: PWD=/home/hxy TZ=BEIST-8 TT_HOME=/home/timesten/TimesTen/tt75
          5951600: 17518639: INFORMIXSERVER=test15
          5951600: 17518639: LIBPATH=/home/timesten/TimesTen/tt75/lib:/lib:/opt/oracle/oracle10g/jdk/jre/bin:/opt/oracle/oracle10g/jdk/jre/bi
          n/classic:/opt/oracle/oracle10g/lib:/opt/IBM/informix//lib:/opt/IBM/informix//lib/esql:/opt/IBM/informix//lib/esql:/home/timesten/Ti
          mesTen/tt75/lib:/home/hxy/svn/ABM_C++/lib
          5951600: 17518639: LD_LIBRARY_PATH=/opt/oracle/oracle10g/lib:/opt/oracle/oracle10g/network/lib
          5951600: 17518639: NLSPATH=/usr/lib/nls/msg/%L/%N:/usr/lib/nls/msg/%L/%N.cat
          5951600: 17518639: thread_setstate_fast(648518346363757824, 648535941213032208) = 1
          5951600: 17518639: knlist(0x0000000000000000, 0, 10) = 268496784
          5951600: 17518639: msem_remove(0x0FFFFFFFFFFFF498) = 0
          5951600: 17518639: knlist(0x0000000000000000, 648535941213054232, 0) = 268496784
          5951600: 17518639: msem_remove(0x0FFFFFFFFFFFEE60) = 0
          5951600: 17518639: knlist(0x0000000000000000, 1152921504606846613, 648535941211762724) = 268496784
          5951600: 17518639: knlist(0x0000000000000010, 142608253, 1152921504606846952) = 268496784
          5951600: 17518639: loadquery(65568, 0x0FFFFFFFFFFFF228, 0x00000020) = 268496800
          5951600: 17518639: setrlimit64(-1, 0xFFFFFFFFFFFFFFFF) = 5951600
          5951600: 17518639: klseek(5951600, 0, 1152921504606846952, 0x800000000000D0B2) = 5951600
          5951600: 17518639: gencore(0x00000001100116B0, 0x0000000000001330, 0x0000000000000000, 0x0000000000000000, 0x09001000A01333C4, 0x000
          0000000000001, 0x0000000000000000, 0x0000000000000000) = 0x0000000000000001
          5951600: 17518639: drregister(0x00000000000003ED, 0x0000000000000000, 0x0000000110011BA8, 0x0000000000000000, 0x0000000000000000,
          0x0000000000000000, 0x0000000000000000, 0x0000000110011BA8) = 0x0000000000000000
          5951600: 17518639: kread(648535941212117968, "\0\0\0\0\0\0\0\0", 8) = 17518639
          5951600: 17518639: thread_terminate_ack(0) = 0
          5951600: 17518639: thread_terminate_ack(1152921504606841936) = 0
          5951600: 17518639: schedgetparam(3, 0x0FFFFFFFFFFFF390) = 0
          5951600: 17518639: schedgetparam(4, 0x0FFFFFFFFFFFF390) = 0
          5951600: 17518639: schedgetparam(5, 0x0FFFFFFFFFFFF390) = 0
          5951600: 17518639: schedgetparam(6, 0x0FFFFFFFFFFFF390) = 0
          5951600: 17518639: schedgetparam(7, 0x0FFFFFFFFFFFF390) = 0
          5951600: 17518639: schedgetparam(8, 0x0FFFFFFFFFFFF390) = 0
          5951600: 17518639: schedgetparam(10, 0x0FFFFFFFFFFFF390) = 0
          5951600: 17518639: schedgetparam(11, 0x0FFFFFFFFFFFF390) = 0
          5951600: 17518639: schedgetparam(12, 0x0FFFFFFFFFFFF390) = 0
          5951600: 17518639: schedgetparam(36, 0x0FFFFFFFFFFFF390) = 0
          5951600: 17518639: schedgetparam(39, 0x0FFFFFFFFFFFF390) = 0
          5951600: 17518639: kioctl(648535941213023872, 67108864, 0x00000000000001B6, 0x0000000000000072) = 3
          5951600: 17518639: ffinfo(3, 22528, 0x0000000000000000, 0) Err#25 ENOTTY
          5951600: 17518639: ffinfo(3, 22528, 0x0000000000000000, 0) Err#25 ENOTTY
          5951600: 17518639: __kdb_format_print_init(0x0000000000000003, 0x0000000110018498, 0x0000000000001000, 0x800000000000D0B2, 0x0000000
          000000000, 0x00000000000000F9, 0x0000000000000000, 0x0000000000000000) = 0x0000000000001000
          • 17. Re: TimesTen 7.0.5 CS connection question
            Chrisjenkins-Oracle
            The truss command you are using looks correct but there seems to be a lot of data missing from the trace. The important stuff happens in the ttIsqlCmd binary that is exec'd in this line:

            5951600: 17518639: execve("/home/timesten/TimesTen/tt75/bin/ttIsqlCSCmd", 0x20095418, 0x20099A88) argc: 2

            near the end of the trace but the trace ends shortly afterwards before tht process has done much of anything... We are looking to see what this process is doing and to compare that to what it does when it works.

            Chris
            • 18. Re: TimesTen 7.0.5 CS connection question
              581561
              the last I paste just ignore the last message because they the same like before, but the first line of truss command is exec command, I cannot get more message before exec ttisqlcs. this question is really quirkiness.
              • 19. Re: TimesTen 7.0.5 CS connection question
                Chrisjenkins-Oracle
                I think maybe you did not read my last post in detail...

                I am not asking for a trace from before you execute ttIsqlCS (since that would be a silly question to ask). if you look carefully at the trace you pasted in for me you will see that about 3/4 of the way through that trace there is a line as follows:

                5951600: 17518639: execve("/home/timesten/TimesTen/tt75/bin/ttIsqlCSCmd", 0x20095418, 0x20099A88) argc: 2

                This is where things actually start to happen; the trace before this point is just the execution of the ttIsqlCS shell script and is not very interesting. At this point the shell script is launching the actual binary that implements the ttIsql command (ttIsqlCSCmd in this case) and it ithe execution of this binary that is of interest in the trace but many, many messages are missing.

                If you can provide an e-mail address I will contact you offline so that you can e-mail me the complete trace.

                Chris
                • 20. Re: TimesTen 7.0.5 CS connection question
                  581561
                  soryy for the mistake, my mail is: yuyuanlan@revenco.com, very pleasure to communicate with you.
                  • 21. Re: TimesTen 7.0.5 CS connection question
                    user12204065
                    You can try setting below parameter in sys.odbc.ini for target DSN on server side.

                    Authenticate=0


                    Regards,
                    Rajesh Bodhe
                    1 2 Previous Next