Re: Which informix client to use

I want to run select sql queries like viewing tablespaces and their size etc etc... Will I be able to do that with dbaccess. I more query I am trying to install informix connect on my solaris OS ...Is this informix connect same as Informix dynamic server.Installation of informix connect is giving some brand error ...log file says: (Dec 19, 2007 9:50:26 PM), Install, BrandFiles, err, CUSTOM_BEAN_ERROR_BEGIN /opt/IBM/informix/etc/install: etc/brand: cannot execute CUSTOM_BEAN_ERROR_END Can anyone help me on this.my ultimate aim is to install IDS on Solaris system() sun OS 5.10 generic 120012 -14 i86 pc i386 i86 pc(64 bit). scottishpoet wrote: >> Yes these are .sql files and i also need to run some independent informix >> commands. >> can u please give me the link for download. > >dbaccess should have been installed when you installed IDS > >I think you said you are running on Windows. In that case > >Start -> All Programs -> Informix Dynamic Server -> (the name of the >instaance you are running > >This will opena command prompt with the Informix environemnt set > >cd into the directory that yoru .sql file resides > >You then have 2 choices > >1/ dbaccess <dbname> <script name. > >or 2/ type "dbaccess" to open the menu interface > >then its "query language", select the database and "choose" you will >then be given a list of the .sql scripts >alternatively "new" to run "ad hoc" sql commands > >alternatively -- Message posted via http://www.dbmonster.com

ssameer via DBMonster.com wrote: > I want to run select sql queries like viewing tablespaces and their size etc > etc... > Will I be able to do that with dbaccess. > YES! Dbaccess it the query tool that's delivered as part of Informix Dynamic Server. As for 'tablespaces', assuming you are using the term in the Oracle sense the Informix equivalent is dbspaces, you can use the server status tool, onstat, to view dbspaces and the disk chunks that make them up as well as just about everything else about the operation of the server itself. > I more query > I am trying to install informix connect on my solaris OS ...Is this informix > connect same as Informix dynamic server.Installation of informix connect is > NO! Informix Connect is the runtime library installation that needs to be on client boxes that have no server installed. The server is the IDS package. > giving some brand error ...log file says: > (Dec 19, 2007 9:50:26 PM), Install, BrandFiles, err, CUSTOM_BEAN_ERROR_BEGIN > /opt/IBM/informix/etc/install: etc/brand: cannot execute > CUSTOM_BEAN_ERROR_END > > Can anyone help me on this.my ultimate aim is to install IDS on Solaris > system() > sun OS 5.10 generic 120012 -14 i86 pc i386 i86 pc(64 bit). > You've now posted this question about 10 times in different forums. The answer is the same: If you are getting a branding error then you are most likely trying to install the WRONG version of the Informix product. Probably you have a version for Solaris on Sparc processors NOT the version for i86. Jonathan and I BOTH posted instructions for testing that theory to your other posting yesterday. Art S. Kagel Oninit > > scottishpoet wrote: > >>> Yes these are .sql files and i also need to run some independent informix >>> commands. >>> can u please give me the link for download. >>> >> dbaccess should have been installed when you installed IDS >> >> I think you said you are running on Windows. In that case >> >> Start -> All Programs -> Informix Dynamic Server -> (the name of the >> instaance you are running >> >> This will opena command prompt with the Informix environemnt set >> >> cd into the directory that yoru .sql file resides >> >> You then have 2 choices >> >> 1/ dbaccess <dbname> <script name. >> >> or 2/ type "dbaccess" to open the menu interface >> >> then its "query language", select the database and "choose" you will >> then be given a list of the .sql scripts >> alternatively "new" to run "ad hoc" sql commands >> >> alternatively >> > >

> You've now posted this question about 10 times in different forums. The > answer is the same: If you are getting a branding error then you are most > likely trying to install the WRONG version of the Informix product. > Probably you have a version for Solaris on Sparc processors NOT the > version for i86. Jonathan and I BOTH posted instructions for testing that > theory to your other posting yesterday. I also asked you over a week ago to tell us the name of the download/install file you have and offered to check with OS this is for.