Oninit® Archive
Results for “IFX_EXTEND_ROLE”
Current Role
I've been asked by our security staff to produce a list of userids that set a particular role. We have applications that routinely set this role which is ok, but we also have 'smart' users that connect with a 3rd party front end and query the database. These are the connections …
Not enough room in ROOT DBspace
Reduce the size of your PHYSFILE. You probably moved it to another dbspace after setting up the first server. Start it smaller, then create the plog dbspace and move it there and resize. j. On 1/4/17 4:09 PM, STEVEN AB wrote: > Hi, > > I'm trying to setup a new server with the …
How to alter a table become a read only one?
Hi Chuan, My first recommendation - migrate to 14.10 or 15.0 . The next, to think about your user and role concept - levels, rules, HDR secondary updateable? And maybe if you need some special handling of update/insert, you can use a trigger function to implement your business/se…
Changing DBSPACETEMP run-time
Hi, IBM Informix Dynamic Server Version 11.70.FC5XE Please, is there a way to change DBSPACETEMP for a session inside 4GL? ------------------------------ Sincerely, Dennis ------------------------------…
Setting a user to Read only access
HI as said by Doug, roles is the best solution, see also Mr Lester paper :), https://advancedatatools.com/article/roles-a-new-security-feature-in-informix-online-7-10-ud1/ ------------------------------ John Smith ------------------------------…
ADO - activex data object
What do I require, to connect "ado activex data object" to Informix ? AIX 7.2 IBM Informix Dynamic Server Version 12.10.FC9W1 Regards Dirk…
prevent automatic generation of sbspace
How can I prevent automatic generation of SBSPACE and automatic registration of BTS-Modul ? IDS 12.10.FC12 My Instance has no SBSPACE and no datablade is registered in any database. If a 'normal' user with connect right runs (can be accidental) a SQL-Statement like 'SELECT xxx FR…
retiring a result-set from regex_split function
Reply sent to Krishna by email last week: You probably just need to do this replacing "test" with your database name: $ echo register ifxregex.1.00 test | blademgr informix>Register module ifxregex.1.00 into database test? [Y/n] Registering DataBlade module... (may take a while…
listener-thread@soc_be.c:3073: err = -25582:
Adding Version details Informix Version : IBM Informix Dynamic Server Version 12.10.FC6 O/S Version : Red Hat Enterprise Linux Server release 6.9 Thanks & Regards, Karthik Rajan…
Informix and speculative execution
Hi all, I have seen speculative execution patches for Firefox and SQL Server. Are there speculative execution patches for Informix in progress? There is no IBM Flash for Informix Dynamic Server and speculaative execution! Regards, David.…
Soundex function
Personally I have not used this, but there is Google... Page 423 of the "Migrating from Microsoft SQL Server to IBM Informix" says Informix does have this available. www.redbooks.ibm.com/redbooks/pdfs/sg247847.pdf It appears to be in the Datablade Basic Text Search: https://www…
Informix text indexer
I'm starting to read about excalibur datablade for indexing documents and the Lucene text type fields indexer. Someone is using or used any of these two?…
Rovoke insert permission but still can insert
I am doing it at the command line in the server directly in the directory C:\\\\Program Files\\\\IBM\\\\IBM Informix Dynamic Server\\\\11.50\\\\bin…
Trigger ignore all exceptional handling in SP
Informix version : 12.10.FC6AEE Platform : Linux Requirement: 1) Invoke of the following stored procedure happens on INSERT TRIGGER level and it need to be at trigger level. I had written a stored procedure with exceptional handling. Sample Code =========== create procedure fn_…
Re: Public execute on filetoclob and other fun....
Jesus Christ. Mac email mangles stuff nearly as badly as Notes! > On 5 Dec 2016, at 08:09, Spokey Wheeler <spokey.wheeler@gmail.com> wrote: > > If you regard FILETOCLOB as a UDR, then you can see the rules for UDR = > security here: = > http://www.ibm.com/support/knowledgecenter…
12.10.FC6 Mac port released
IBM Informix 12.10.FC6 release for Mac OS is officially available! John F. Miller III STSM, Lead Architect miller3@us.ibm.com 503-747-1366 IBM Informix Dynamic Server (IDS)…
new features about dynamic parameter added in 12.1
Attention, this is not documented. For Informix 12.10, another way you can get the list is to use the cf_flags column on syscfgtab to determine which onconfig parameters are dynamic: SELECT cf_name FROM sysmaster:syscfgtab WHERE bitand(cf_flags,'0x1') = 0 --removes Unsupported p…
Performance issue after migrate to IDS from Online
Questions: 1. After the database was recreated and loaded did you run the recommended suite of Update Statistics commands as described in the Performance Guide manual (or as implemented by my dostats utility) or are you depending on Auto Update Statistics (AUS)? 2. So, you m…
-272 when using role and synonym
IDS 11.50.FC6, HP-UX 11.31 PA-RISC We have two databases, with a table in one db and some synonyms in the other db pointing to the tables in the first db. In other words, in DB_1 we have: create table abc (...); create table xyz (...); and in DB_2 we have: create synonym abc …
RSS not working
-bash-4.2$ onstat - IBM Informix Dynamic Server Version 11.50.FC9 -- On-Line --…
Informix upgrade
Can we upgrade informix from Dynamic Server Version 11.70 to 12.1 workgroup edition directly?…
Installing web datablade in 12.10
Hello, We have just migrated from 11.50UC9 to 12.10FC2 on a Sparc Solaris machine. I am trying to install web datablade in a database. Registration goes fine and when I ask blademgr to list installed datablades it says DataBlade modules registered in database utvdb1: web.4.13.…
Running oninit as root on AIX
Administrative VPs and IO VPs (AIO, LIO, & PIO) run as root and the CPU VPs, purpose specific VPs (like the Java VP), and User VPs (for User Defined Routines not running in the CPU VPs) run as 'informix'. That changed sometime early in the 11.xx. You are correct that in 10.00 and…
when use IfxDataReader.GetIfxDateTime to NULL valu
Hello, The version of Informix products in my environment is: Database server: AIX IBM Informix Dynamic Server Version 10.00.FC5 IBM Informix CSDK Version 2.90 IBM-ESQL Version 2.90.FC4 Client: PC Windows IBM Informix-ESQL 3.70.TC5DE.…
Informix Data Blade Module
hi, I plan to try uses informix data blade module to increase performance for searching on my java application. How to install and configure informix datablade module step by step? where i can download informix datablade module? it free or required license to download this. C…
Excalibur datablade
Informix 10.00.FC11 Solaris 5.10 I have a database that states that a datablade is registered ( ETX.1.31.FC1 ) but when I try to use it it states that the access_method etx does not exist. If I look in the sysams table there is an entry. if I try to create the access method it t…
IDS 12.10 - dbimport very slow
Hi Markus, Is your import logged ? Regards, Henri MOUKOURI Le 25 juin 2013 à 10:45, "MARKUS BRINKBäUMER" <markus.brinkbaeumer@gmail.com> a écrit : > Hello, > > we have a new server (Windows 2012, 8 GB RAM, 4 x 600 GB SAS 15k HDD). On the > server we have installed an IBM Inf…
Performance Tuning Discussion
Ok it seems you have a big hardware, what´s your Informix version? What´s your box architecture? For performance tips, there is a good article in Andrew Ford´s blog, that should clarify your thoughts.... http://www.informix-dba.com/p/informix-innovator-c-tuning-basics.html This…
DB_locale or local naming convention
Hi, I already mention the informix version. IBM Informix Dynamic Server Version 11.70.TC1IE…
Why cant I create a database in a dbspace ?
Do you see datadbs I the onstat -d report or in sysmaster:sysdbspaces? How did you add the datadbs dbspace? Art On Dec 10, 2012 10:58 AM, "FRANK J. COMPUTER" <frank_in_pr@hotmail.com> wrote: > 11.70.FC6 Developer Edition on Windows 7 Pro 64-bit: > > Downloaded via IIUG link an…
Roles X remote database
On Wed, Nov 28, 2012 at 7:34 PM, Cesar Inacio Martins < cesar_inacio_martins@yahoo.com.br> wrote: > Hi , > > Ifx 11.50 FC9X6 , AIX 6.1 > > We have two databasesatour system, where we work using ROLEs to manage > the users . > Today we have a security problem , which is caused by…
Re: HDR Reconstruction (with ER :-))
Keith, this is exactly the scenario described. As long as the logs on the remaining server have wrapped (ie the newest log on the down/recovered server is still online on the surviving server, then you can make this recovered server the secondary by running the onmode -s primary…
Error -556 on @ reference
In IDS_A have a stored procedure do_some that has a insert into a local table. In IDS_B have a stored procedure do_some that does: call base@IDS_A:do_some(); Calling this sp works ok. In IDS_C i try to run: call base@IDS_B:do_some(); Fails with error -556 Cannot create, drop,…
to IBM : Informix Gateway
To marry various DB's consider using IBM's MQ messaging. We use it move data to/from AS400, Oracle, SQL-Server. There's also a datablade for it.…
Config Help
Your biggest performance problem is that you are running your server on a VM. IO performance under VMWare is VERY VERY POOR and, as I've said several times already this month, databases live and die on IO performance. Art Art S. Kagel Advanced DataTools (www.advancedatatools.co…
RE: RegExp Datablade
A fixed version of the RegExp datablade that runs under Linux is now available at http://www.oninit.com/download/index.php?page=regexp.html - this version doesn't core the VPs Cheers Paul -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Beh…
RE: Use Datablade API with spatial datablade?
Hi Mike, I noticed that you have set the length of this parameter value to 0 with: lengths[0] = 0; Although you have set the length of the mi_lvarchar value with mi_set_varlen(lvvar,lot_wkb_len); the length value of that parameter to mi_exec_prepared_statement() should also …
Use Datablade API with spatial datablade?
(I posted this to the Spatial Users forum as well, but that forum doesn't seem to be very active). I've been trying to upload geometry to an st_geometry column using the datablade api. I set my mi_lvarchar variable lvvar using geom_to_wkb (&geom, &max_alloced, &lot_wkb_len, &l…
What are best onconfig parameters for a DSS app
Frank.... first question: Is your database installation being made for a production system???? Alexandre Marini IBM Informix Certified Professional v10 / v11.50 / v11.70 IBM Information Management Informix Technical Professional IBM Infosphere DataStage Technical Professional …
RegExp Datablade
Any one got this running under 64-Linux - it cores the VP under 11.5/11.7. The same code is 100% solid under Solaris 0x08b23c84 (oninit)afstack (0x554d6e88, 0x26c6, 0x556eb793, 0x26c6, 0x0, 0x8d952d4) 0x08b252e6 (oninit)afhandler(0x2, 0x556ebacd, 0x556ebb4d, 0x538a0d70, 0x401, 0…
IDS 7.31 UD5 data(base) recovery
Informix Dynamic Server Version 7.31.UD5 I understood that IDS 7.31 entered End Of Support in September 2009 ( 2 and a half years ago) I hope this is not a business critical system…
enterprise replication time to replicate data
IBM Informix Dynamic Server Version 11.50.FC6 Question for enterpise experts Does anyone know a command that will give me time that it takes to replicate data to a node? for example i update on server a and it replicates to server b . How long did it take? cdr view profile gives …
DataBlade modules licencing
Hi all. Before i suggest the option to CTO.... anyone knows how DataBlade modules are licenced (we have several IDSs) ? And some aprox. costs of buy: Excalibur Text Search DataBlade ? Thank you.…
Over 1,000 days of 24x7 database uptime!
On 29.07.2011 20:38 Lester Knutsen wrote: > From one of our customers, their Informix server hit 1,000 days today > .... congratulations;) > > IBM Informix Dynamic Server Version 10.00.FC8 -- On-Line -- Up > 1000 days 00:31:45 -- They beat mine just bit ... IBM Informix D…
Connections to Database slow - for both shared mem
REPLY 1 - ONCONFIG FILE: cat onconfig.prod #************************************************************************** # # Licensed Material - Property Of IBM # # "Restricted Materials of IBM" # # IBM Informix Dynamic Server # (c) Copyright IBM Corporation 1996, 2006 All rights …
Setting up HDR- First Time -11.70 Innovator-C
Hi, I am setting up HDR for the first time. onstat - on primary shows IBM Informix Dynamic Server Version 11.70.UC2IE -- On-Line (Prim) -- Up 0:11:5s onstat - on secondry shows IBM Informix Dynamic Server Version 11.70.UC2IE -- Fast Recovery (Sec) -- Up 00s onstat -m on sec…
ISAM error 197: Partition recently appended to
Informix Dynamic Server Version 9.40.UC5 SUSE Linux Enterprise Server 10 (i586) I have done a level 0 backup directed to /dev/null and tried again. still it is throwing the same error.…
EXCALIBUR DATABLADE
Grettings!! I have recently installed Excalibur Text Search Datablade 1.31 on Hp-UX 11.23 with Informix 11.50.FC7 I want to do some probes, I registered my datablade on my database and when I wanted to create the ETX index on a TEXT column, I got the following: 610 Index not a…
Single sign-on
Thank you, Mark and Fernando, for your advice. I will look into using RBAC. We do have a system of securing sensitive data by granting and revoking privileges by database and user or role. This is done in both production and development environments. We are trying to fine tune th…
Re: Spatial DataBlade
On Nov 17, 2:26 pm, Tom Lehr <tomc...@gmail.com> wrote: > Hello, > > Looking on Passport Advantage, I do not see it listed specifically for > the Windows Server 2008 Platform. > There are three versions listed: > > Informix Spatial DataBlade 8.21 Multiplatform English > eAssembly…
Tool to estimate the size of an index
Sorry, I forgot to provide the version of the installation: IBM Informix Dynamic Server Version 11.50.FC4 Operative System: AIX Version 6.1…
Spatial DataBlade
Hello, Looking on Passport Advantage, I do not see it listed specifically for the Windows Server 2008 Platform. There are three versions listed: Informix Spatial DataBlade 8.21 Multiplatform English eAssembly(CR5IFNA) Informix Spatial DataBlade 8.20 Multiplatform US English eAs…
HDR and Spatial Datablade
Hello 2 things - #1) Have not read anything special yet regarding installing this nodule but is there anything special that needs to happen when installing and registering Spatial? I have already come across reading from others that the onconfig paramter of IFX_EXTEND_ROLE need…
How to set role in distributed query in IDS 11.5
Options one did not work, Tried it already. Option two cannot work since I don't have that role defined in my current database. This role is only valid for the secure database. And if I set the default role it gives the error that no role found.…
Can't access sysindexes remotely
Hi, We are using IBM Informix Dynamic Server Version 11.50.FC6 using Platform: SunOS 5.10 Generic_125100-09 sun4v sparc SUNW,Sun-Fire-T200 Thanks…
Create Another Instance On The Same Server
Here is my configuration and the error I am getting. I have not created dbs_root as of yet... is this not created when you first initialize? In the /usr/informix directory I have an executable called training, it has the following variables.Changes made DBSERVERNAME, INFORMIXSER…
Barrodale, DBXten-DB extension for data sequences
Hi Frank, Yes, both DBXten (for data series) and the Grid DataBlade (for gridded data) are available as Informix Dynamic Server DataBlades. See http://www.barrodale.com/bcs/white-papers for some recent performance results and http://www.barrodale.com/bcs/docs/DBXten_Programmer_G…
phonetic datablade
Hi all, I have been tasked with developing/locating a phonetic search tool. I am wondering if anyone has already developed a phonetic datablade? Thanks in advance.…
Random Server Slowdown "Redone"
There are some usual things you could do for now: 1) calc your database ratios, I think there are several NETTYPE, BUFFERS and even BTSCANNER options that could be optimized, you could download Mr. Art script to automatically know these important numbers!!! It´s on the download …
IDS, BTS datablade and HDR
In the BTS requirements section it states that HDR is not supported. I understand the explanation about why the BTS cannot be replicated, it writes the indexes to file, but what is not clear is if the addition of the BTS datablade will *prevent* HDR. http://publib.boulder.ibm.co…
Informix Dynamic Server Software Downloads
It appears IBM has cleverly hidden the IDS downloads again on the Passport Advantage Website, at least from my prying eyes. I can find the Solid DB and the DB2 links just fine. Does anyone out there in IIUG-land with a Passport Advantage account know where IBM has stashed the dow…
Re: Anybody using Time Series and Geospatial (Geodedic) for telemetry?
Ian Michael Gumby wrote: > Simple question... > > Anybody doing telemetry using a combination of timeseries and geospatial > datablades? > > Considering an issue of air traffic control and GPS along with a more > mundane 'UPS route' tracking issue. I think you would struggle to …
Did anyone listen in to that conferance call the other week?
I don't have the details ... but it was on Eric's InformixZone site. I had a bit of trouble getting connected since the registration emails didn't mention a password. (ibm). Silly me, I should have known that.... NOT! Ok, I was wondering if anyone listened to the presenter in h…
OPTCOMPIND and perl
Anyone know if I can change OPTCOMPIND after establishing a DB connection or does it need to be set before connecting? ta SLES10 SP1 IBM Informix Dynamic Server Version 10.00.UC5…
Buffer Turnover Rate question
How does one go about 'estimating' this? The performance documentation says to "set the value of buffers to between 20 and 25 percent of the number of megabytes in physical memory." - since I have 8Gb total physical memory, if my math is correct, that means between 819200 and 102…
Reverting from 11.X -> 10.X using onmode -b does n
The online log is telling you why it won't revert: 16:05:47 "Database ace_test: Must drop spl/udr (oapi_rp_cc_and_pin) before attempting reversion" 16:05:48 "Database ace_test: Must drop spl/udr (iol_update_rp_pin) before attempting reversion" 16:05:49 "Database ace_test: Must…
Insert into an indexed table is really SLOW!
MIKE DUNHAM-WILKIE wrote: > I am running into performance problems inserting into an indexed table, using > Informix 11.50. The following timings for loading into > compressed/uncompressed, indexed/non-indexed tables using dbload/HPL-Deluxe > more illustrate the problem. The numb…
Block access to databases via odbc
This may be silly but why don't you just grant the permissions the user are really authorized to do and revoke all the others. You also can implement roles with them, on your application you can set a role which allow them to update,insert,delete but their default role might only…
Informix Developer license?
Thanks for the link! I see they have a Developer edition for "unlimited trial". But, I see that the Informix Datablade Developer's Kit runs only on Windows. http://www-01.ibm.com/software/data/informix/blades/dbdk/ Can datablades be developed (in the proper manner) without usin…
Informix Dynamic Server Scheduler question
Hi! I'm working on a project at my faculty. It's a java desktop application with an informix database. I have a problem using informix dynamic server scheduler. I have a particular table in my database. This table contains records that are inserted by the desktop aplication I'm …
IDS 9.40 End of Support Imminent
I have seen a number of posts on CDI recently related to IDS 9.40 As per the announcement on September 7th 2007, effective on the dates listed below, IBM will withdraw support from the following product releases licensed under the IBM International Program License Agreement: 9…
RE: -25588 error after CPU & fiber channel failure
Well I found the cause of this error. The third party app, has a very specific install sequence and I was hmm ... uh... told the incorrect sequence according to the provide. It seems they rely on some of the gnu apps to install their products and the gnu apps have to be installe…
ER Error Enterprise Replication
bozon wrote: > Enterprise Replication is giving the following message when I do a > simple cdr list server > > ndl12:ndl12a common_reporting$ cdr list server > SERVER ID STATE STATUS QUEUE CONNECTION > CHANGED > --------------------------------------------…
Poor Performanc with Multiple DB's in one Instance
2009/1/30 ANEES AHMAD <aanees@i2cinc.com>: > Hello, > > Please see my comments below. > > What OS and what versoin of IDS are you using? > [Anees Ahmad] We are using SunOS CA-MCPDB2 5.10 Generic_125100-09 sun4v sparc > SUNW,Sun-Fire-T200 and the IDS version is 10.0. It's a 6 core…
-25588 error after CPU & fiber channel failure
More information on our setup. If anyone has an idea of what to look at or try let me know. Otherwise the only thing left I haven't tried is whipping the server and start fresh. kernel parameters semaem Static 16384 16384 16384 - semmni Static 16384 16384 2048 0.3% semmns Stati…
RE: Web Datablade
Hi, To complement the option that Manoj just gave, I just wanted to add something, if it's of any help: I think that, even if you have a security check/query to be performed in a dynamic tag called in this page, you could still use this dynamic tag to query the security level o…
RE: Web Datablade
Sorry, the MISQL code would be something like this: <?misql sql="select usersec_level from user_table where user_id=$uid> $(SETVAR, $usersec,$1) <?/misql> where usersec is a variable you defined earlier, probably using MIVAR. Thanks! Veronica. From: vgomesn@hotmail.com To…
RE: Web Datablade
Hi Klaus, Maybe something like this could work for you? If the users' levels are stored in a table, and you receive the user id as a variable for the web page, then maybe you could query (using MISQL tag) your users table to find out what security level the user who logged into…
Re: Web Datablade
When you say user, is the user maintained through webdatablade? If so there is a security option on the page that lets you set various security levels(basically a number) and you define a user to have a particular security level. By doing so a user can only view pages equal to an…
RE: Web Datablade
The appropriate list to post this question is the datablade list. Each web datablade page is considered a transaction. The possible solution if you want to commit the changes is redirect the error to another page. Guillermo. -----Mensaje original----- De: informix-list-bounces@…
Web Datablade
Hello I'm new to informix web datablade programming and needs a possibility to stop the generation of a page, if the user has no permission for it. Because actually it's only done by javascript, which is not really secure. My current solution is to throw an error at the "misql"-…
Question about sysindexes.clust
Any suggestions would be greatfully tested out... Since this system is very mixed and we don't have a testing tool it has been very hard to convince anyone to change anything. No the only difference with production is the names of the instance and "UNSECURE_ONSTAT" is not set. o…
Cannot issue oninit to IDS 11.5 on Windows Vista
Richard M. schrieb: > Hi, can someone explain what's happening here and how I can get around > it. > > I installed 11.5 from the IIUG site onto my Vista Business SP1 laptop. > I opted to run it under the informix account without role separation. > The installation created a new u…
Re: Informix vs Oracle vs DB2. SQL Query optimization.
> I think the reason > is that Oracle still has issues with derivative data types. (You call > them cartridges, IDS calls them datablades.) But then again,. my > client isn't your ordinary user of spatial data. To be clear here - cartridges are extensions to the Oracle server,…
use stored proc that return multiple columns in a query
forgot to include version info: IBM Informix Dynamic Server Version 10.00.UC6W5 -- On-Line -- Up 207 days 22:14:39 -- 1441100 Kbytes…
Re: dostats and Timeseries datablade
Clive: Send me the following and I'll try to figure it out: select * from sysprocedures where procname matches 'root*'; and dbschema -d tseries -f <whatever name(s) come out of the select above>. Art On Tue, Sep 23, 2008 at 9:01 AM, Clive Eisen <clive@serendipita.com> wrote…
dostats and Timeseries datablade
Have I missed something? Should I worry? This database has the TimeSeries.4.01.UC7 registered IBM Informix Dynamic Server Version 11.50.UC2 (centos 5.2) dostats: Features Version 5.10, Source Revision: 1.146 ! ./ak/utils2/dostats -d tseries -h timedb_tcp 2>&1 | tail -20 rlt…
installing informix dynamic server in linux
hi, I'm new to informix... I tried to install informix dynamic server(iif. 11.50.UC2E.Linux-RHEL4.tar) in my linux machine. I'm getting an error like this... One or more prerequisite system libraries are not installed on your computer. Install libpam.so.0, libncurses.so.5…
Informix Dynamic Server v 11.50 Developer's Edition
Does everyone know that the Informix Dynamic Server Developer's Edition v11.50 that you can download from the IIUG Web site (www.iiug.org) is NOT timebombed, is completely and fully functional (including HDR, MACH11, ER etc.). Do you know that the only limitations on this versio…
Informix Dynamic Server v 11.50 Developer's Edition
Does everyone know that the Informix Dynamic Server Developer's Edition v11.50 that you can download from the IIUG Web site (www.iiug.org) is NOT timebombed, is completely and fully functional (including HDR, MACH11, ER etc.). Do you know that the only limitations on this versio…
CONFIGURATION ONAUDIT-IBM Informix Dynamic Server
Hello, I need to configure onaudit and onshowaudit able to register for each of the consultations that are made to the database, either through dbaccess, ODBC or another application. I've been reviewing the IBM Informix Trusted Facility Guide, but I was not working. What param…
Monitor TCP/IP access to Informix instance
> Is there any way to monitor the TCP/IP access to an Informix Instance? > > I am running 9.4 on HP-UX and use TCP/IP for connecting to the > Informix instance. > The application is an Informix 4gl application and the application > code handles most of the security. > All users o…
How to use Informix Dynamic Server
I have installed trial version of "Informix IDS Dynamic Server Developer Edition 11.5 for Windows 2003, XP, Vista, 32bit Version 1150TC1DE". But i am new to informix. Can anyone explain how to use IDS in detail.…
Re: Centrify single sign on
prichard@blm.gov wrote: > Fernando, > > Thank you again for your reply. > > Your Question: Is {pam_aix} an AIX native module or is this a module > provided by Centrify? > > My Answer: /usr/lib/security/pam_aix is an AIX native module and part > of the AIX file set bos.rte.securi…
IDS v10 JDBC 'Cannot create an user thread'
Hello, I'm looking for help deciphering this error. I installed IDS v10 onto Windows XP with the IIUG installer. I have a server instance, a database and a schema. I see my tables OK with dbaccess, and also with the SQuirreL GUI via JDBC. But when I run my server, on what is pr…
Cannot Add Index (-212) & (-105)
We were running our End of Month and one of the EOM thread failed with error "Cannot Add Index (-212) & (-105). In the informix log has the following error details :- 17:13:44 Maximum server connections 7 17:13:49 Assert Failed: Page Check Error in next_scan:bad data page 17:1…
Re: Timeseries datablade
On Jan 16, 8:45 am, "Lello, Nick" <Nick.Le...@nielsen.com> wrote: > Does anyone have experience with the timeseries datablade (good or bad); > and what types of timeseries are they using with it ? > > How well do reporting queries against timeseries compare with > pre-aggregated …
What is IPA abbreviation ?
Hi all IBM INFORMIX DYNAMIC SERVER 10.00 PRODUCT RELEASE bug_number 168928 description WITH NON-DEFAULT PAGE SIZE AND ACTIVE IPA'S, TABLE LEVEL RESTORES FAIL product_code ONUTILS component_code ARCHECKR What is IPA ? Thanks…
Re: Timeseries datablade
Lello, Nick said: > > > Does anyone have experience with the timeseries datablade (good or bad); > and what types of timeseries are they using with it ? Financial instruments. > How well do reporting queries against timeseries compare with > pre-aggregated data ? It depends. …
Timeseries datablade
Does anyone have experience with the timeseries datablade (good or bad); and what types of timeseries are they using with it ? How well do reporting queries against timeseries compare with pre-aggregated data ?…
Recursive SQL?
Thanks Art, I'll go and find that datablade and give it a go. Regards, Bryce.…
Re: Strange error when initialising (long)
i guess file /informix/data/ returns a directory oninit: Cannot open chunk '/informix/data/'. errno = 21 > ROOTPATH /informix/data # Path for device containing root dbspace -----------------------------------------^^^^^^ should be a file or better a char mode raw dev …
Memory Utilisation goin to 99 % in Informix
The Attachment is not coming thru ....find the file #*********************************************************************** *** # # Licensed Material - Property Of IBM # # "Restricted Materials of IBM" # # IBM Informix Dynamic Server # (c) Copyright IBM Corporation 1996, 2005 A…
DBSECADM question with Label-Based Access Control (v11)
The Durster wrote: > IDS 11.10.FC1 on HP-UX 11.23 > >>From the SQL Reference Guide for v11 under "Granting the Database > Security Administrator Role": > "You cannot grant DBSECADM to a role or to yourself." > >>From Carlton Doe's book on IDS 11: "User informix does not have the …
RE: in search of Informix metadata
A decent starting point for you would have been http://www.ibm.com/developerworks/db2/zones/informix/library/techarticle/030 5parker/0305parker.html Sounds like you are a bit past that. the SQL Reference Manual chapter 1 goes through each of the catalogues and details the conten…
RE: Problem with IDS 11 DataBlades
Nilesh, Excellent! Thank you. Mike > -----Original Message----- > From: Nilesh Ozarkar [mailto:nilesho@us.ibm.com] > Sent: Wednesday, September 19, 2007 3:03 PM > To: Mike Badar > Cc: informix-list@iiug.org; informix-list-bounces@iiug.org; > The Durster > Subject: RE: Problem…
RE: Problem with IDS 11 DataBlades
On Sep 19, 5:03 pm, Nilesh Ozarkar <nile...@us.ibm.com> wrote: > After you set the IFX_EXTEND_ROLE configuration parameter to On, a DBSA > can use the following syntax to grant and revoke privileges to and from > specific users. > GRANT extend To username > REVOKE extend From use…
Problem with IDS 11 DataBlades
I ran into the exact same problem registering the spatial datablade today. Your answer resolved my problem; IFX_EXTEND_ROLE was set to 1. If you find anything more about DB users and the IFX_EXTEMD_ROLE, please pass it along. Thanks for your summary. Mike > -----Original Mess…
IDS 11 sds problem
Hi: I installed IDS sds in SUN OS 5.9, I initialize the primary and SDS server successful. I could execute some query from SDS server, But after I ran some applicaton in the primary server, The sds server disconnect from the primary server. In the online.log , IDS report the fol…
oninit -i failure
Found the problem I had $ONCONFIG=/opt/informix/etc/onconfig. Should have been $ONCONFIG=onconfig On Aug 8, 2:03 am, tom.pri...@gmail.com wrote: > I'm trying to startup informix for the first time on a CentOS 4.5 > server. When I run oninit -i , I get the following error: > > …
latch waits and what to do about them
System has been up and stable in OLTP from &AM to 12 Midinght and batch from midnight till 7 AM. However it seems like the latch waits are high. Latch waits go as high as 3875 System is stable but I always want more speed. (as long as it does not effect stability.) Here is onc…
IIUG TV
Great job on the video work!! I look forward to seeing more! -t- -- -- Informix Dynamic Server Database Engine -- http://www.informix.com --…
Creating users in Informix
>I need to create a new user in IBM Informix (Unix platform) and give >him access to only temp1 table but not to temp2 table. >The problem is >that there are some existing users who have access to both tables >through Public role. So security was not previously a concern but is…
VPCLASS 'cpu' not enough physical procs for affinity
Hi, I keep seeing this message "VPCLASS 'cpu' not enough physical procs for affinity" in the "online.log". We are running our application in a Sun V890 Server with 4CPU , 16GB RAM using "Informix Version 10.00.FC5" . Please advise if there any issues with configuration file. …
file I/O from stored procs
IFX 10.00.UC4 RedHat AS3 U8 Are there any datablades (or anything else) in the software repository for doing reads and writes to files from within stored procedures? [ anything new in Cheetah? :) ] Bob Roussey Unix / Informix Administration Spirit Airlines Robert.Roussey@Spirit…
Is IBM actually doing something with IDS?
art.kagel@gmail.com wrote: > Datablades - IBM is realizing the potential marketing and development > power of the existing datablades (the new free text and geographic > blades, the node blade, timeseries, etc.) and as a feature for > customers to use to improve their own proje…
Re: admin tools like PC client
Mike, What version of Informix are you using? Informix SE? Informix OnLine? Informix Dynamic Server? Most Informix versions these days come with a product call I-Connect that needs to be installed on the PC and rovides the Informix ODBC drivers.…
Error when initializing
06:36:20 IBM Informix Dynamic Server Version [b]10.00.UC6TL[\\b] I believe this is likelt ot be a new ish instance to a newish user of the software…
problems with Informix dynamic server 9.4 @ WIndows 2003
I have problems with connecting the server. I use correct user/password to connect to the server, but the server do not known the server. I'm sure the user exist and is one of the user in Informix_Admin group. I have installed Informix dynamic server 9.4 in a windows xp system in…
Re: Mapping cpuvp's to IBM virtual processors on p
On Thu, 2007-02-22 at 16:35 -0500, ART KAGEL, BLOOMBERG/ 731 LEXIN wrote: > Your assumption is partially correct. You don't NEED all 6 CPU's allocated to > CPU VPs, but it's a good thing. The IDS scheduler will allocate sessions to > CPU > VPs as needed so it's possible that one …
Mapping cpuvp's to IBM virtual processors on pSeri
We're currently running a read-only instance of IDS 10.0FC6 on AIX 5.3 TL-05. The logical partition (LPAR) hosting IDS has 2.4 physical CPU's, divided into 6 logical CPU's. Running nmon's cpu monitor shows CPU 0 at about 50% used, CPU1 used occasionally, and CPU 2-5 are idle. I'm…
oninit startup failure
Is this the first time you've tried initializing after installation or is this an existing instance which has just stopped working? How much physical memory on this machine? Disk space ok? What is the exact IDS 10 version? Are you running this directly or via Remote Desktop or s…
Time zone
Krystian wrote: > Krystian wrote: > >>Hi, >> >>how to determine in SPL/SQL time zone the client has or the server is >>into? >>It doesn't matter to me which one, as they are both the same. >>I just don't want to create another spl routine just to determine this >>/well i hope i w…
License Extension
Help.. I need a license extension for the IBM Informix Dynamic Server Version 10.00.FC3R1TL which I downloaded to do a evaluation. How can I get the license extened..my project is in the final stages .. Dhaya Commercial bank…
dbimport EXTREMELY slow
Quman said: > > I am doing dbimport with IDS 10UC5 on AIX 5.3. > > Watched, > > large number(100,000+) of dirty pages were SLOWLY written to disk. > > piece of online log, > > 20:08:47 Maximum server connections 0 > 20:08:47 On-Line Mode > 20:15:15 Fuzzy Checkpoint Completed: dur…
SQL support byte operation like 'AND' || 'OR'
Would you please tell me about 'datablade' module? This is my first time to hear about it? What time do i neet to use it? thanks a lot…
Excalibur Datablade
I have a document storage system running on one of my LIVE databases that I am experiencing a known problem with which I need to upgrade. As part of the upgrade plan I am attempting to build a test server with said database, recreate problem, upgrade and hopefully, problem will g…
Wannah have fun?
Why did'nt he just use one of the IDS text datablades (ie excalibur or topic) or external google engine? Talk about making work for your self.…
Re: Security Vulnerabilities Addressed in Informix Dynamic Server
Clive Eisen wrote: > Ian Michael Gumby wrote: > > Yes the buffer overflow issues are a pain and frankly they shouldn't occur > > if IBM did formal code reviews. Or rather they should be caught and > > corrected prior to release. > > > > "Paul Watson" <paul@oninit.com> wrote in m…
Security Vulnerabilities Addressed in Informix Dynamic Server
Not sure if this has posted here or not but .... http://www-1.ibm.com/support/docview.wss?rs=630&context=SSGU8G&dc=D600&u id=swg21242921&loc=en_US&cs=UTF-8&lang=en Cheers Paul Paul Watson Tel: +44 1414161772 Mob: +44 7818003457 Web: www.oninit.com GO FURTHER with DB2 GET THER…
Re: Security Question....
On 7/5/06, Tam OShanter <tam@oshanter.com> wrote: > Wondering on opinions regarding best practices for use of the public user in > IDS. > > Is there a compellign reason to allow the public user permissions to execute > DDL statements, or, in your opinion, should the public user b…
Web data blade installation on RHEL4
trev wrote: > Hi. We are experimenting with the Informix Web Data Blade on a Red Hat > Linux Enterprise 4. Not got to far so far. > > Running the ./install script we get an error that appears to be related to > a -d paramater in the AWk command. (line 2 of install script) > > Q…
RE: Regexp datablade problem
> -----Original Message----- > From: informix-list-bounces@iiug.org [mailto:informix-list- > bounces@iiug.org] On Behalf Of Doug Conrey > Sent: Tuesday, May 23, 2006 9:03 AM > To: Marco Greco > Cc: informix-list@iiug.org > Subject: RE: Regexp datablade problem > > > -----Original…
RE: Regexp datablade problem
> -----Original Message----- > From: Marco Greco [mailto:marco@4glworks.com] > Sent: Tuesday, May 23, 2006 8:36 AM > To: Doug Conrey > Cc: informix-list@iiug.org > Subject: Re: Regexp datablade problem > > Doug Conrey wrote: > > This looks like a very useful tool, but I can?t get…
Re: Regexp datablade problem
Doug Conrey wrote: > This looks like a very useful tool, but I can?t get the darn thing > working against IDS 10.0.FC4 on AIX 5.3. > > The first problem I had was compiling errors related to strchr ? > apparently on AIX the compiler wants to use a macro for strchr, so the > decla…
Regexp datablade problem
This looks like a very useful tool, but I can't get the darn thing working against IDS 10.0.FC4 on AIX 5.3. The first problem I had was compiling errors related to strchr - apparently on AIX the compiler wants to use a macro for strchr, so the declaration "extern char *strchr();…
RE: DataBlade Manager
You also need another SB space: SYSSBSPACENAME - This is the default SB space used by the Informix server. Add the above parameter to your onconfig file with a name for your SB space, add the space with onspaces, do a level-0 backup and register the datablade. Let us know if t…
Initialising Informix
I am trying to initialize informix on a new server and I am getting this error. The server is HP UX 11.11 and Informix IDS 7.31 What could be the problem / This action will initialize Informix Dynamic Server; any existing Informix Dynamic Server databases will NOT be accessible …
DataBlade Manager
hello all, how does one "install" Blade Manager? HP-UX 11i IDS v10 we have a developer who wants to use the datablade API to generate auditing events from transactions..........Thanks Tom…
Informix spatial data blade
I saw the latest version of Spatial datablade doc is dated back to Aug 2002. Do we have newer version? Thanks, Frank -- Yunyao "Frank" Qu Computer Sciences Corporation(CSC) NOAA/CLASS, (301)817-4696…
Informix Connection From WIN CE.NET Emulator?
How do I connect to informix dynamic server from WIN CE.NET Emulator? Is there a WIN CE informix driver?…
Re: Event-driven fine-grained auditing
Hi Tom, The trigger introspection datablade API has been in IDS for the past couple of years in 9.x and therefore in 10.x as well. I know of atleast one ISV using it in their product. cheers, Keshav.…
How do it get writes form the lrus in V10
Thanks to everyone for our response. I now understand that having all chuck writes is ok. Nilesh Ozarkar wrote: >> I think I should be getting LRU writes. >> > > Why ? does checkpoint takes too long to complete ? or checkpoint duration > is affecting transaction response time ? …
Re: New Features IDS 10
>From the IDS info centre I find the following when I search under "new features" IBM Informix Dynamic Server, Version 10.00.xC1 contains new features in the following areas: Security enhancements Server usability enhancements Performance enhancements SQL enhancements Enterpri…
Tuning Recommendations for Informix V10
Greetings .. I am evaulating Informix IBM Informix Dynamic Server Version 10.00.FC3R1TL on a SunOS Solaris 9 Sun-Fire-V240 machine with 2 processors. RAM is 2 GB. We are planning to move our application running currently in Informix 9.3 TC1 version on Windows 2000 Server to a…
Re: Table Editor for Multiplatforms
Enhancements in Version 4.3 ..... also supports the Informix Dynamic Server 9.x. http://www.ibm.com/software/data/db2imstools/db2tools/db2te/…
Roles
ED KOSTENBAUDER said: > > Hi, > > I'm new to Informix. We are using IDS 10.0. In Microsoft SQL Server we use > an > "application role" to lock down the permissions on the connection for the > particular role. In Informix, is there a way to lock down the permissions > on > the con…
Informix Auditing
Onaudit is a HOG. You can expect a 40% - 60% performance decrease. Even if you only turn it on and don't have any masks. You do not need role separation if you trust your DBA. Overall there should be a separate security person to manage the auditing. The "Fine Grained Auditing…
Fragmentation Elimination Problem
I am on version IBM Informix Dynamic Server Version 10.00.FC4.…
Re: Informix Dynamic Server 9.30 - Shared Memory
Ronald Schwingel wrote: > Can someone please tell me how much Shared Memory (gigabytes?) > Informix Dynamic Server 9.30 (32-bit version) for AIX 5L can use > before asserting with a Shared Memory access error? Can you provide > documentation that I can pass on also? It looked to…
RE: Informix Dynamic Server 9.30 - Shared Memory
First off you shouldn't be getting shared memory access errors. That sounds more like a bug that technical support should address. I wouldn't be surprised if your getting can't allocate additional shared memory segment messages. Informix 32-bit on AIX is a bitch. The problem …
Informix Dynamic Server 9.30 - Shared Memory
Can someone please tell me how much Shared Memory (gigabytes?) Informix Dynamic Server 9.30 (32-bit version) for AIX 5L can use before asserting with a Shared Memory access error? Can you provide documentation that I can pass on also? We are looking at providing one of cust…
create a DB on Linux
Hi! I have installed Informix dynamic server on Linux. Now I want to create a data base. What should I do? Thanks…
Re: flagship sunk
Funny I have been able to download IDS 10 for Solaris, Windows and Linux am I just smarter than everyone else? www.informix.com Support and downloads In the middle trials and betas Oh look Informix Dynamic Server (IDS) V10.0 easy!…
Re: flagship sunk
elanleblanc@yahoo.com wrote: > in their respective sweet spots. For IDS, this means OLTP, RFID, > Spatialtemporal capabilities, and embeddability. Don't forget the excellent extensibility offered by the VTI and the VII (Datablades.) AFAIK no other RDBMS has anything nearly as …
Re: Datablade not shown in BladeMgr
Check for IDS 10 bugs? Download the IDS 10.00.UC3 release notes from IBM? Either way raise a support call with IBM. Don't play around get them to dial in and fix it!…
Re: IDS 10 - documentation questions
Oops! I mean IBM Informix Dynamic Server Version 10.00.TC3ET Althought the release notes (idse_win_release_notes_10.0.html) start with:- "Release Notes for IBM Informix Dynamic Server Express Edition for Windows Platforms 10.00.TC3E, 1 July 2005 " so it is TC3E or TCE3T? and …
Datablade not shown in BladeMgr
Hi, We are using the IDS10 UC1, installed on a Linux Machine (CentOS 4.2) If we use the blademgr command to register one of the Informix Datablades, not all the modules are shown in the list. Example: [informix@envisat-int] 2% blademgr InformixPROVA>list foo There are no module…
Re: Sql to concatenate multiple rows to a single row / column
Thank you SaltTan - it works beautifully. BTW, we have IBM Informix Dynamic Server Version 9.40.FC6.…
Re: Roles
Hi, Thanks for you advices. SZ ----- Original Message ----- From: Nita Dembla To: sergios.zag.... Cc: forum.subscriber@iiug.org ; ids@iiug.org Sent: Wednesday, October 26, 2005 5:21 PM Subject: Re: Roles [5917] Hi, "As I know there are the following default roles: 1) connect…
Re: Roles
Hi, "As I know there are the following default roles: 1) connect (Every one connected on a database automatically is assigned on that role) 2) resource (Have full access on database objects) 3) dba (Have full access on every database and on Informix engine)" The above are not d…
Re: XML datablade
Neil Truby wrote: > Does anyone know where I can get a copy of the XML datablade for Informix in > a hurry? > > I went here: > http://www-128.ibm.com/developerworks/db2/zones/informix/library/techarticle/0303cline/0303cline.html > > but the 64-bit version for HP-UX is incomplete,…
XML datablade
Does anyone know where I can get a copy of the XML datablade for Informix in a hurry? I went here: http://www-128.ibm.com/developerworks/db2/zones/informix/library/techarticle/0303cline/0303cline.html but the 64-bit version for HP-UX is incomplete, and the 32-bit just gives a "…
Re: Config for OLTP system
Neil Truby wrote: > IDS 10.0 v3 on Solaris 9. > > I'd be grateful for any comments on this OLTP system onconfig about to go > live on a SunFire v480 with 2 processors and 8GBytes of RAM. I have only 6 > extrenal disks fo the 60GByte database server. I've striped the database > …
RE: Config for OLTP system
Neil, You are using /usr/informix and /opt/informix PA_PAGES and RA_THRESHOLD are blank Is 1Mb logs big enough, I use 100Mb and we can fill a log in <15 mins when busy, you won't need 819 of them if you make them bigger LTAPEBLK = 32 are you sure? seems a tad small to me SHM…
RE: Config for OLTP system
> -----Original Message----- > From: Bill Dare > Sent: Thursday, August 11, 2005 8:44 AM > To: 'Neil Truby'; informix-list@iiug.org > Subject: RE: Config for OLTP system > > BUFFERPOOL > size=2K,buffers=1024000,lrus=33,lru_min_dirty=2.000000,lru_max_dirty=1 > 0.000000 > Maybe spe…
RE: Config for OLTP system
BUFFERPOOL size=2K,buffers=1024000,lrus=33,lru_min_dirty=2.000000,lru_max_dirty=10. 000000 Maybe spending too much time flushing 8% of the LRUs when LRU writes kick in? Might try lowering lru_max_dirty. Shorter checkpoints and your LRU writes should be spread more evenly over t…
Config for OLTP system
IDS 10.0 v3 on Solaris 9. I'd be grateful for any comments on this OLTP system onconfig about to go live on a SunFire v480 with 2 processors and 8GBytes of RAM. I have only 6 extrenal disks fo the 60GByte database server. I've striped the database across 3 of them with a 32k i…
New IDS Forum on IBM Developerworks website
This forum provides a place for Informix Dynamic Server developers and users to share their questions, thoughts, and ideas with others. http://www-128.ibm.com/developerworks/forums/dw_forum.jsp?forum=548&cat=19…
Re: IDS 10 Express Edition
Note 10.00.xC3 = Enterprise Version 10.00.xC3E = Express Edition http://publib.boulder.ibm.com/infocenter/ids9help/index.jsp?topic=/com.ibm.relnotes.doc/uc3E/idse_win_release_notes_10.0.html Then click on "IBM Informix Dynamic Server Express Edition" in the right pane:…
setup Informix Dynamic Server Version 9.40.UC1E1 to linux error
I setup Informix Dynamic Server Version 9.40.UC1E1 to linux execcute oninit -ivy is failed the online.log is write /// 16:31:32 Dynamically allocated new virtual shared memory segment (size 8192KB) 16:31:32 Informix Dynamic Server Version 9.40.UC1E1 Software Serial Number AA…
Informix Dynamic Server information Centre
Great new utility just posted under IDS 10 on the docs site has uses for other products and versions than just IDS 10 so take a look even if you are not using 10 yet!! http://publib.boulder.ibm.com/infocenter/ids9help/index.jsp…
Cannot find message file. Check INFORMIXDIR and DBLANG.
im trying to run the oninit -i in the command prompt when the message appear... we installed... IBM Informix Dynamic Server 9.40 IBM INFORMIX-4GL Rapid Development System Version 7.32.UC2 IBM INFORMIX-4GL Version 7.32.UC2 set up sqlhosts, services, onconfig, path... but when tr…
Re: Semistructured data in Informix
Jean Sagi wrote: > What is Semistructured data? > > If you want some XML with informix try the XML datablade. > Interesting. Where can I find more info about 'the XML datablade'? I know the WEB datablade, which can generate XML (http://www.ibm.com/informix/blades/web). I know t…
Spatial Datablade - Import Problem
Hi, after importing a database that uses the spatial datablade, I'm having problems with the table that contains the spatial column. It seems that the LO Handle is corrupted (no query works with the table). I'm using the 9.40 Linux platform, and the $INFORMIXDIR/extend/spatial.8…
Doubt using Excalibur Datablade
Hi, I'd like use several StopWordlists on the same column. Using ETX I can make different indexs with different Stopworlists. EXECUTE PROCEDURE etx_CreateStopWlst('ES_LIST','/palabrastabu_ES.txt','etxspace') ; EXECUTE PROCEDURE etx_CreateStopWlst('FR_LIST','/palabrastabu_FR.tx…
datablade registration in ANSI database
Hi, everybody, Is there any documented way to register the datablade module in ANSI database? Both Windows-based 'BladeManager' and command-line 'blademgr' do not support ANSI databases.... Any workaround? -Alexey…
datablade registration in ANSI database
Hi, everybody, Is there any documented way to register the datablade module in ANSI database? Both Windows-based 'BladeManager' and command-line 'blademgr' do not support ANSI databases.... Any workaround? -Alexey sending to informix-list…
Insider #53: June profiled, new services, specials to enjoy before
IIUG Insider (Issue #53) November 2004 Just a few hours left - Don't forget to vote for the next IIUG Board of Directors: http://www.iiug.org/iiug/election/2005ballot.html Highlights: June profiled, new services, specials to enjoy before Christmas, 4GL is now more rational & M…
Insider #53: June profiled, new services, specials to enjoy before Christmas, 4GL is now more rational & More...
IIUG Insider (Issue #53) November 2004 Just a few hours left - Don't forget to vote for the next IIUG Board of Directors: http://www.iiug.org/iiug/election/2005ballot.html Highlights: June profiled, new services, specials to enjoy before Christmas, 4GL is now more rational & M…
chunk capacity
we are using BM Informix Dynamic Server Version 9.40.UC2X3 on Linux Kernel 2.4.21 the command 'onstat -d' shows ... Expanded chunk capacity mode: disabled how can I change this mode to 'enabled'?…
IDS V7.30 and Windows 2000
Can Informix Dynamic Server Version 7.30.TC6 be run on a Windows 2000 host system? TIA Erwin…
Security issue
Hi, We are using ids9.4. We are having security issue, where we have some users accessing databases thru odbc. The role function can't handle this part of users. How can we apply some kind of security mechanism on group basis to eliminate the exposure of our database to these us…
RE: Excalibur Datablade
The same problem, as Neil Truby has with Web datablade, which is also supposed to be packaged with IIF ------------------------------------------ Alexey Sonkin > -----Original Message----- > From: malc_p@btinternet.com [mailto:malc_p@btinternet.com] > > AFAICR, this used to be …
Re: Excalibur Datablade
Malc P said: > AFAICR, this used to be a bundled part of the IIF suite. We have > identified the requirement to check if Excalibur may be useful to us, > but it's not in our release software pack (IDS9.30HC5 on HP-UX11i) and > we can't find it for download on the ibm informix pag…
Excalibur Datablade
AFAICR, this used to be a bundled part of the IIF suite. We have identified the requirement to check if Excalibur may be useful to us, but it's not in our release software pack (IDS9.30HC5 on HP-UX11i) and we can't find it for download on the ibm informix pages - all there is is …
Re: Error Initialize Informix Dynamic Server
Art S. Kagel wrote: > On Wed, 04 Aug 2004 05:05:41 -0400, madiego wrote: >>I install Informix Dynamic Server and when I initialize 'oninit -iv' : >> >>This action will initialize Informix Dynamic Server; any existing Informix >>Dynamic Server databases will NOT be accessible - Do…
Error Initialize Informix Dynamic Server
Hello, I install Informix Dynamic Server and when I initialize 'oninit -iv' : This action will initialize Informix Dynamic Server; any existing Informix Dynamic Server databases will NOT be accessible - Do you wish to continue (y/n)? y Checking group membership to determine ser…
RE: Web datablade
Neil, v. 9.21+ is shipped in two different packages (at different prices): 1. IDS 2. IIF (IDS + Java-in-server + Web datablade??? + Exculibur(ETX)???) For some reason, I don't see Web datablade in the IIF package I've downlaoded from PA site. We should definitely verify with I…
Web datablade
One of our customers, with licences to use v9.40 and a current support contract, wishes to try out the web datablade. However, it's not available for download on their (or any of our other customers') PA download site. It *is* available via the main IBM website but only upon pay…
Re: Informix Dynamic Server and DB Tuning
I am experiencing similar problems with users migrating from Standard Engine to IDS 9.30. It appears that some applications are more susceptible than others. What application(s) are you running? We also have experience of adding more BUFFERS, LOCKS, etc and not improving the sit…
RE: Informix Dynamic Server and DB Tuning
Muthana Increase BUFFERS in onconfig file. UPDATE STATISTICS for each table (as a minimum) rerun the query and see what improvements you get. If you still have problems post the results of:- onstat -p onstat -m onstat -R and sqexplain.out of any particularly slow query or updat…
Informix Dynamic Server and DB Tuning
Dear Sir, The question how can make DB Tuning for Informix Dynamic Server version 9:30 to get the query faster. I used IDS 9:30 and it's not quick enough like our old Standard Engine. which Parameter can i change to make that or what shall i do? Regards Muthana AL-Temimi…
Can IDS accessing Informix SE Tables.
Hello, Now we are using Informix SE. We are planning to go Infomix Dynamic Server 9.x. Before migrating our current applications to IDS 9.x., first we have to develop a new application in IDS 9.x, in that we need to use some of the tables from informx SE. Could you please answer…
Re: C-ISAM DATABLADE on RH AS 3.0
Hi Federico, C-ISAM DATABLADE 1.1 is not yet certified on Linux RedHat Advanced Server 3.0. owner-informix-list@iiug.org wrote on 06/16/2004 03:45:39 PM: > Hi, > is the C-ISAM DATABLADE 1.1 supported on Linux RedHat Advanced Server 3.0 ? > Or is there the "usual" issue (errno)…
Re: Soundex
On Mon, 03 May 2004 05:58:16 -0400, Gokusan wrote: > Hello, > Working with Informix SE 7.25. > > Has this Informix engine some functionality like SOUNDEX in oracle? Or there > is any stored procedure that can implement that algorithm or the better > metaphone? Look on the IIUG …
Dose anybody have the dbtop script in the Troubleshooting informix course?
Dears, I study the Troubleshooting ibm informix dynamic server course. At the module 4 exercise need the dbtop script. Dose anybody has this dbtop script and post for me? Thanks. Philip Yeh.…
Permissions per user
If your application is role-aware, you could reduce it from over 5 million statements to fewer than 2000 by creating a role, doing role privilege grants to each table, and granting the role to each user. >>> "PHILLIP SHELTON" <lshelton@aholdusa.com> 4/27/2004 7:46:53 AM >>> Whil…
Work group edition - Unlimited edition??
Taken from IBM web site:- =========================================================================== The following Informix Dynamic Server Workgroup Unlimited editions have been added to the IBM Data Management Gold Transaction Processing Bundle for SMB Unlimited: IBM Informix…
Node Datablade
Is there a maximum depth to a node, I'm hitting a 9635 when I try to return a 16 deep node Test Code create function eric() returning node define l_node node; define l_vchar lvarchar; LET l_node = newlevel("1.1.1.1.1.2.1.1.2.1.4.1.1.3.1"); --LET l_vchar = newlevel("1…
Re: [Informix Dynamic Server (IDS):] Digest 2671
For a course in the US, check out: http://www-306.ibm.com/services/learning/ites.wss?pageType=course_description&co urseCode=L1760&country=us&language=en (IBM course L1760). There is probably a similar course offered in Europe somewhere. Hope this helps. Kevin Doiron Toronto,…
LVARCHAR to CLOB Cast
The web datablade has a cast from LVARCHAR to CLOB and vice versa. Other than installing the web datablade or attempting to build the cast from scratch, is there any way to get the cast for 9.4? My OS's are AIX, SOL, and Win. I tried searching through the bladelets, but IBM's …
Re: Transaction support in informix dynamic server(IDS)
chaithra wrote: > i wanted to know, if in IDS we can get to know the status of a > transaction at any given time. or once any transaction commits or > rollsback we should be able to know the status. > is it possible through c++ interface provided by the IDS. I'm not quite s…
Transaction support in informix dynamic server(IDS)
hi all, i wanted to know, if in IDS we can get to know the status of a transaction at any given time. or once any transaction commits or rollsback we should be able to know the status. is it possible through c++ interface provided by the IDS. thanx in advace chaithra…
configure computer for using informix
what shell I do to make my computer work with informix. I have installed winXP on my computer, informix 4 i informix dynamic server? THANKS…
Where can I get the client API?
Hi, does anyone knows where to get the client API for Informix Dynamic Server 7.x? Perhaps we want to access the server via api directly. Kind regards, Joachim Engel.…
Informix optimizer
Hi, Does anyone know if the Informix Dynamic Server (7.31 or 9.4) database optimizer uses star schema optimizer techniques? Thank you, Tony…
TRUNCATE TABLE command in 9.3?
I am aware that Informix Dynamic Server previously has not included the TRUNCATE TABLE command. Does anyone know if 9.3 or 9.4 include this command?…
Linux fgl_getenv
Glen Johnson wrote: > Informix Dynamic Server Version 9.30.UC3 on Linux. Do I have to do > something before I can use the fgl_getenv call in a stored procedure? When > I try I get 674: Routine (fgl_getenv) can not be resolved. As John Carlson said, fgl_getenv() is an I4GL f…
[Q] spatial datablade
Hi, I'm using Informix 9.2 with spatial blade (8.11.UC1). It seems that the spatial funcfion, e.g., distance, does not consider the 3rd element. The following is the script that I ran and the result of the query. ------------< script for Informix spatial datablade >------------…
fenced stored process process
DB2 has a concept of fenced and non fenced process for Stored procedures. Doesn't informix also has the same concept. we use datablades (in 'C') and run the stored procedures as a seperate VP.…
IDS 9.x workgroup server
I am checking WGS for bundling with our product for small clients. I checked from IBM site and it sure looks like it is still being sold. Surprise surprise!! It also looks like that datablades can be used with WGS. Datablades is our requirement. Other restrictions like lack of fr…
Is there a shapefile to informix geodetic datablade loader?
I know of the loadshp utility to load the ESRI shapefile format into Informix Spatial, but I want to work with Informix Geodetic. Does anyone know of a loader (or sample java code) to load a shapefile into the geodetic datablade product? I'm new to the Informix system, and it lo…
Informix Web Datablade for Linux
Hi!, Somebody know where I can get an evaluation version of web datablade for linux? Thanks in advance.…
Using Web Datablades --Urgent
Hi All Can i seek some info about using web datablade tags in the exisitng application. We Have application wriiten using JSP,Java , Java Script ,our web server is Tomcat. My question first of all can we use WEB datablades with tomcat as it works with JDBC, and configure JDBC …
SIG health check - IDS@iiug.org
Dear SIG subscriber, Let me introduce myself. My name is Jean Georges Perrin, I am a member of the Board of Directors of the IIUG. Recently, the board appointed me to become the "SIG master", thus this is now one additional activity for me. Now that we know each other, let's co…
SIG health check - informix-list@iiug.org
Dear SIG subscriber, Let me introduce myself. My name is Jean Georges Perrin, I am a member of the Board of Directors of the IIUG. Recently, the board appointed me to become the "SIG master", thus this is now one additional activity for me. Now that we know each other, let's co…
RE: Dynamic Server versus Universal Server ??
Originally, Version 7.x was called 'Informix Dynamic Server', Version 9.0x was called 'Universal server' Starting with 9.1, Universal server became 'Dynamic server with Universal data option'. With 9.2, new names 'Internet Foundation 2000 ' and 'Dynamic server 2000' ware given…
Informix Dynamic Server 2000 startup problem
Hi, While starting up informix in multi user mode , we wait for the database to come up by checking the onstat - o/p . But if the system is loaded, even after onstat shows status as online , the connection is rejected by the database . The wait loop that we do is as follow…
why I can't see the output of "onstat -g wts"
test:/informix>onstat -g wst Informix Dynamic Server 2000 Version 9.21.FC7 -- On-Line -- Up 5 days 13:23:03 -- 11132960 Kbytes Wait statistics not enabled How to enable the wait statistics???…
informix SDK 2.81 ifxoledbc OLEDB and ADO
When Updating or deleting a non existing row in a table, the informix oledb provider produces an "UnSpecified error". Environment: Informix Dynamic Server 7.31 Informix SDK 2.81 ADO 2.6 Any help will be appreciated. Thanks in advance…
unloading datablade rows
Until now each night we are doing a complete unload of all tables o a database. Over the years this ws the best solution for us to get a complete and portable backup. We often use such a complete backup to load it into a newly generated database for some tests. even if the comple…
DBDK Visual C++ Add-In
Hi, Where can a get to download a DataBlade Developers Kit (DBDK Visual C++ Add-In). Thanks, Roger…
RE: Tools for Informix security administrator
Check with Lester Knutsen of Advanced Data Tools. He did up a lovely little package for this. cheers j. > -----Original Message----- > From: Marat S. Salimov [mailto:maratkotik@mail.ru] > Sent: Wednesday, February 07, 2001 5:55 AM > To: informix-list@iiug.org > Subject: Tools …
Tools for Informix security administrator
Hi there, I need some tool for Informix security administrator which is able to do the next: 1. Managing users privileges at the rows and columns level 2. !!!Comfortable administrator interface!!! for adding, copying, changing, deleting privileges for users and roles (i.e. grou…
WebDatablade can communicate to Oracle?
Is anyone know application written by web-datablade can connect to Oracle database? Is web-database can communicate through ODBC? or just through datablade in informix db? or can it be communicate through enterprise gateway? Thanks for your input Kevin Kim…
Javascript in Datablades
Hi, I am busy creating a website which is being run through an Informix database and Data Director for Web, what I need to find out is if I am pulling my images out of a database is there anyway of using these images in conjunction with javascript? ie. My menu buttons on my pag…
security subsystem
I installed Informix Dynamic Server 7.3 on NT. The databseserver is running, but sometimes i got problems with locked tabeles. Apparently the locks are not removed if an application connected to the server crashed before a commit. I tried to start oncheck but i Became the error m…
Datablades
I am trying to install / register an Informix datablade. I have attempted to register the datablade and it hangs. I am running IDS 2000/IF 2000 on Windows NT. I am using the BladeManager GUI but when I initially bring it up no datablades are listed. I only see my database. I …
FRAGMENT privileges - no SELECT?
IDS 2000, 9.21.UC2, Linux. One of the (several) objectives of FRAGMENT(ing) a table BY EXPRESSION can be to enhance the granularity of security permissions over table data, providing row-group-level security. CREATE TABLE employee ( employee_id INTEGER NOT NULL PRIMARY KEY,…
Web Datablade reference, anybody?
Hi Is anyone know of any site that has good resources/references about the administration of Web Datablade ver 3.x with NSAPI, other than the downloadable manual from www.informix.com?…
What requires an IDS Linux?
Hello What requires an Informix Dynamic Server Linux a desktop and/or a network version of Linux? Thanks in advance Jacqueline Romero Miranda…
Informix v Oracle
Hi Is there a function in Informix Dynamic Server 2000 that is like Oracles CREATE SEQUENCE that uses NEXTVAL/CURVAL and %ROWCOUNT, ect? Thanks for all contributions Jordan jbruce@asaglobalserv.com…
DataBlade...
Could anyone tell me if the IDS2000 "backward" compatible with the Informix Spatial DataBlade for the older versions of the Universal Server (say, 9.12 or 9.2)??? Respectfully, Goce. -----…
ODBC and Datablades
Hello- I have just recently started with Informix. I need to write C++ client code on Solaris to write data to an Informix Database with the Geodetic Datablade installed. I've looked at their Object C++ library (barf - horrible performance), ESQL(barf) and I looked at their ODBC…
Retrieving product name
Hi all, Is their a system table somewhere on an informix server that stores the product name. For example 'Select owner from systables where tabname = � VERSION� will return the version of the server. I would like to be able to tell if a server is a Universal server or a Dynamic …
IDS 7.3x on Win2000?
Does Informix Online Dynamic Server 7.3x runs on Windows 2000 (Professional)? Thanks for your help. Guy Dillen…
c-isam datablade:sites to visit
We are looking for sites, using c-isam datablade, we could visit (if possible >= 60 oltp users) Bernard Dhooghe Sent via Deja.com http://www.deja.com/ Before you buy.…
Re: How to search for a string in a TEXT field
Hi, :-( SELECT name, REPLACE(text,"ZNOTREADY","found") AS your_output FROM tablewithtextfield; Blobs are not allowed in this expression. I use Informix Dynamic Server Version 7.31.UC2A…
Web server variable & Web 4.00.UC1
Hi all, I'm trying to use Informix Web DataBlade module 4.00.UC1 with Apache SSL server. May I access web server variable, like SSL_CIPHER, SSL_PROTOCOL etc, from AppPage. --- Serg…
Re: Informix security
Hi, The articule on "Roles - A new Security Feature in Informix 7.1" is available on my web site at: http://www.advancedatatools.com/articles.htm or at the Washington Area Informix User Groups web site at: http://www.iiug.org/~waiug/iugnew54.htm Regards - Lester C…
Create user in Informix Dynamic Server
Hello all I`m new in INS. Could you help me? I have Database server with one user Informix. How to create another user to Database?…
Security Strategy
"Harry Sheng" <harry@ss8networks.com> writes: > Where can I find information on security strategy of Foundation.2000 ? > Thanks. Informix Guide to SQL Syntax: "GRANT" Informix Guide to Database Design and Implementation: "Granting and Limiting Access to Your Da…
serve.pl and web datablade
Hi, Has anyone had/know of any problems getting the web-datablade and serve.pl working ? TIA -- Richard…
Informix ODS on Win 2000?
Does Informix Dynamic Server V7.31.TC5 for Intel Pentium Windows NT 4 also run on Windows 2000? Thanks for any help. Guy Dillen ITP…
Tracing and datablades
I am a datablade developer trying to get tracing to work for debugging. I am running IDS 2000 on NT and Linux. My datablade uses the tracing code generated by the latest version of the DBDK. I have updated the systraceclasses table and created an spl routine to reference the t…
Informix cost???
Someone can said how much does Informix cost? I need to know: -Informix costs -cost for client Thanks very much. I need the last version of dynamic server for Unix. Ciao, Berna…
Excalibur datablade crashes Informix Server
Hi, have anyone use Excalibur Datablade to text searches? I am getting frequent crashes from searches performed on nearly 200 records. Any solution to this? Dominic…
Web Datablade with Apache 1.3.9 is possible?
Hi masters. Does somebody know if It is possible start the web datablade 4.00 UC1 with Apache 1.3.9 I have Linux .2.2.14-15mdk distribuited in Mandrake 7.0, IDS 9.20 UC1 and WEB 4.00 UC1.…
Replication
Hello everybody. I would like to know if it is possible to replicate an Informix database between a UNIX-based 7.32UC2 Informix Dynamic Server and an linux-based IDS2000 without problems. Thanks in advance. jhernandez@geuropa.com…
Re: ODBC Read-Only Database Privilege
If this is practical, Art's suggestion is probably the most secure. This may not be practical if, for instance, you have a an existing application that you cannot change which needs R/W access to many objects in the database. If you open up your database for network access (whic…
Web Datablade on Linux
Hi... Does ANYONE have a good set of docs which explain the proper method for installing the Web Datablade on Linux? Thanks in advance, Joe…
dynamic server with Informix distant database
We have this problem : - write of a html page (this pages will contain many many fields). - Receiving of the page data on a http server based on a M1 machine. - Using of 4gl/informix programs based on the M2 machine with the pages data - 4GL programs will set up a � result � tabl…
HELP! Informix Dynamic Server 7.3
I'm trying to install a new IDS on Linux (RedHat 6.1) on a cooked file. Everything looks right, but upon oninit, I receive the following: oninit: Cannot open chunk '/u1/naf_chunk'. errno = 2 oninit: Fatal error in shared memory initialization Log reflects: 09:11:07 Informi…
UDR Support in Informix Dynamic Server.
Can someone tell me what exact version of Informix Dynamic Server that first supported C User Defined Routines. I've tried searching for this on their website with no joy. (their advanced search doesnt work at all !) Rgds, Peter. Sent via Deja.com http://www.deja.com/ Before y…
OFFICE Connect V.1
Informix Office Connect, Version 1.0, is compatible with the following Informix servers: Informix Dynamic Server, Version 7.3 or later Informix Dynamic Server with Universal Data Option, Version 9.14 Informix Dynamic Server 2000, Version 9.2 or later e Informix-SE 7.23 n�o func…
dbexport of iReach 9.14 to new 2000 server 9.2
Hi Do any of you know when iReach will be available with the new 2000 server (9.2) on the SUN Solaris 2.6 platform ? I have tryed to dbexport an intranet site from iReach with the 9.14 server with web datablade 3.3. This export I tryed to import to a 2000 server (9.2) with web …
Excalibur Datablade
Hi does anybody have some experience with the Excalibur Text-Datablade? We have a lot of problems with damaged Excalibur indexes (usually -937 errors, followed by a total crash of the Informix-Server (9.14UC7 on Solaris 2.6). Excalibur is version 1.30UC3. We appreciate any help…
Visualisation of spatial data
Hello, does anybody has experiences in visualisation of spatial objets of the spatial datablade or the geodetic datablade? Please let me know. I'm looking for a tool that creates an image of the spatial objects (for example a polygon or a line) and enables me to gives some of t…
System catalogue
Hello! Can anybody explain me how I can create trigger on "informix".systables? (The server I deal with is Informix Online Dynamic Server 7.3.) Max…
mi_decimal_to_string
I'm using the DataBlade API mi_decimal_to_string function. The function returns a DataBlade char * that the DataBlade API allocated. It doesn't seem to say anywhere how and when this memory is released or if the program has to release the memory. If anyone knows how to handle thi…
Web Datablade module?
Nathan Lee <n1905457@sparrow.qut.edu.au> wrote: > Hi guys, > Just wondering is there any newsgroups that deal with Informix Web > Datablade? Newsgroups, no but there is a majordomo list for datablades on the IIUG server. I'm not sure how much traffic there is on the list howev…
Compatability between Informix products
Hi, I need some version compatability information for the following products. Hardware Platform: Hewlett Packard OS Platform: HP-UX version 10.20 Informix s/w: Informix Universal Server 9.20 Informix Dynamic Server 7.31 Informix Gateway to DRDA vers…
Fast Text LIKE indexed searches -- but how?
Hi, We're porting from Illustra but we've noticed that LIKE searches on VARCHAR(100) fields isn't very fast. This is after standard indexing. Are there any options that can be set upon creation of the index or perhaps a datablade which can do this? It'd be nice if the databla…
informix dynamic server on linux help
Hi all, I am an informix newbie, and i have problems running it on redhat linux 6.0. The installation went just fine, but now when i start dbaccess and try to create a new database i get this error message: 25584: Network driver can not access server program /opt/informix/lib/sq…
Informix Dynamic Server on IBM SSA
Can any one share their experiences, recommendations, pit-falls, comments about creating an IDS db engineOLTP environment on an IBM SSA Raid system? We have 2 SSA adapters and have 4 loops with 4 drives each. The IBM techs for the Smoothstart services will be coming next Tuesday…
Please help me!
Hello! 1, Can somebody give me information, what is the new features for Version 7.24 of Informix Dynamic Server according to Version 7.20 of Informix Dynamic Server? 2, Are Version 7.20 of Informix Dynamic Server and 7.20 INFORMIX-ESQL/C 2000 Year Compatible? 3, W…
CAD Datablades
Hi, I'd like to know if exists a datablade that can manage DXF files (I mean indexing and so on). I'm looking for a datablade that make me able to search by own nature of this kind of files: searching a "form" in the technical draw descripted by the DXF file. Thank you!…
Re: installing Informix dynamic server
From: "Joerg_Mauz@abs.org" <Joerg_Mauz@abs.org> > Is there something wrong the the gateway, Hotmail or are there just loads of idiots posting today. (Apart from me, that is! :-) ______________________________________________________ Get Your Private, Free Email at http://www.hot…
installing Informix dynamic server
hi all, can anybody give me an URL where to find a good description of how to setup and install an Informix Dynamic Server with using RedHat Linux ??? I've searched a whole day but founf nothing useful.. :( thx ind advance joerg…
Help! Cant start database service
Hello All I had my informix dynamic server (7.3) running fine till a few days back. Now the dynamic server service and the informix messenger service won't start automatically and if I try to start the server, it does start but I'm unable to connect to it. If I try to start the…
Informix Online Dynamic Server DBA Book
Hello Could anyone recommend a good Informix Online Dynamic Server book. I did a search in Amazon.com but I could not decide on which one to choose. Thanks in advance. Ajay…
Creating BLOB's in C (IUS 9.14)
Hi, Has anybody an example code in C (datablade), that dumps a structure into a newly created BLOB ? Other code concerning creating BLOB's is welcome. Greetings, Stefan…
pricing for informix info?
Hello, Was wondering what other people out there paid for informix dynamic server 7.3... Basically, i wanted to know if they had a web server licensing schem like microsoft. or ibm's db2 (per cpu license). and would the licenses be transferable if I decided to move from le…
web datablade
Hello !! I'm triying to recover an image from my database through the web datablade module but I can't. I insert the image (with the web datablade) as blob without problems. When I try to retrive the image I get the next message: Exception from Informix: XIX000:-999:Not implem…
Re: Determining version dynamically
Hi, If you have Informix Dynamic Server then use the following sql-statement ' select DBINFO('version', 'full') from systables where tabid = 1' result from the sql is : Informix Dynamic Server Version 7.30.UC5 Take a look in Informix Guide to SQL: Syntax for more about DBINFO…
Re: IDS.2000
> I just had a peek at 'www.informix.com'. Anybody know what IDS.2000 is ?? > Marketing on rampage, 7.4, or something entirely different... Both really and neither. IDS.2000, and it's cousin Foundation.2000, are the long awaited merger of IDS 7.31 and IDS/UDO 9.14 into a single…
KAIO: out of OS resources error
Hi~ My informix dynamic server write "KAIO: out of OS resources error .." in online.log. This error log is written during ontape task. How can I solve this problem? platfom : SunOs 5.5.1 Informix Dynamic Server 7.24 uc6 Thanks.…
64bit IDS for Solaris 7/SPARC ?
Is there a 64bit Informix Dynamic Server 7.3x for Solaris 7/SPARC available? tia, joerg…
Posting from the Informix-list
what is the last version of Informix Dynamic Server for HP-UX 10.20, where can i find more Information about this.…
Latest versions for various Informix products ???
Which are the latest versions for Informix Dynamic Server Informix Dynamic Server, Workgroup Edition Informix 4GL Informix SQL on Solaris 7/SPARC ? Where can I find such informations on Informix's website ? tia, joerg…
cdr command line utility in informix 7.24
Hi, Is there a cdr command line utility in informix dynamic server 7.24? I tried to locate it, but the executable is nowhere to find. Thanks, Lu…
Problem Installing Informix Dynamic Server
I downloaded a Try&Buy version of Informix Dynamic Server V7.30 for NT. I installed it on an NT Server. The install seemed to go ok, but after a short time of investigating IECC, I got a blue screen. After this when I started the Command Center, a task seemed to start, but it w…
Informix Web Datablade Module
Hi All, Where can I get free web datablade for informix universal server ? Thanks ! -Wugang…
Problems starting IDS 7.30.TC7 on Windows NT SP4.
When i try to start informix dynamic Server, the following message appears "Only informix user can start informix dynamic server" this message appears when i logged on with the informix's user. When i try to start the service on the control panel , error 2140 appears.…
'Language': Reserved Word?
1. Is 'Language' a reserved word in SPL (when using DataBlades)? It seems that upon registration of datablades, this word causes problems. (Server crashes).…
Out of buffer?
Hi, I got the following error message from an Informix IDS 7.30: <<Informix Dynamic Server>>> WARNING! Buffer pool size may cause Dynamic Server to get into a locked state. Recommended minimum buffer pool size is 4 times maximum concurrent user thre…
Linux VS NT4.0
Hi, Is it true that Informix Dynamic Server workgroup edition 7.30 is ported for Linux, and if it is so does anyone can tell me what to chose between Linux and NT4.0 for running Informix Dynamic Server workgroup edition 7.30. Also I'd like to know for which version of Linux, Inf…
Re: FREE! Certifications offered online to Informix Database
Neil, This is a general view. The DBA in most companies maintains the database, but also must have knowledge of relational design. I spent many years as a consultant in various companies, and this has always been the case in all but the largest shops. YMMV, but even then it h…
Re: FREE! Certifications offered online to Informix Database
I have take the exam yesterday (to probe myself and curiosity). It has 2 parts: 1st. with 24 questions about RDBMS. The other with 40 questions about engine parameters, actual cases analysis (i.e: onstat output pictures), performance management, etc. You have 120 seconds to answe…
FREE! Certifications offered online to Informix Database Administrators
This is a kind offer. Did many others visit this site when they were asking for feedback? I did. I and a couple of other people commented upon how different the role of a Database Administrator as viewed by Tekmetrics differs from our own. In general the questions appeared to …
Intersting...
Informix's new i.sell is using IDS and Java not a web datablade and the Illustra engine. I would think because IDS still offers better OLTP throughput. Any thoughts on this? -Mikey…
Several web sites
We need to manage 2 different web sites in a unique web server. We are developing these sites over Informix with web datablade. How have we to configure the web datablade to have the 2 sites in 2 different databases?.…
[Help]web data blade problem...
Can I send 'javascript's value' to web datablade's value...? Now Error occured.. $ASS = document.form1.ddw.value <$misql sql="select edu_name from edu_name where DDW = '$ASS';">$1<?/misql>…
Starting Informix Dynamic Server !
Hi Gurus, Just wondering is there any difference in starting the informix engine as root user versus as Informix user. ? The reason why I ask this question is , the IDS 7.23 UC6 on HP-UX 10.2 crashes due to a bug (declared as bug by Informix Technical support)when we start in…
Informix Dynamic Server Archive/Restore
Hello All: We have a large scale Informix DB resident on an HP 9000, K460, with AutoRaid Disk Subsystem (218gb). And we are running IDS 7.30. Currently, we are using the Informix ontape archive/restore utility to archive the DB and to perform continuous logical logging. We u…
Any one know this?
Hi folks: Is there a script that can check informix on-line dynamic server is up and running or not? If not it will e-mail a note to D.B.A. groups Thanks in advance Garry…
Roles and Priviliges Question
I am looking for a way to tighten security on our databases by defining roles so that users from a certain group can only access particular tables with pre-defined read and update priviliges. Usage of the informix roles utility appeared to be the answer, allowing associating of…
Re: informix spatial datablade Module
Jessie Chen wrote: > > Is anybody familiar with informix spatial datablade? Kind of. It does not seem to be supported by Informix anymore. We have had problems with inconsistent spatial join results and strange load/unload behaviour on our system (universal server 9.12UC2, sol…
converting Informix Online 5.1 esql/c to Dynamic Server esql/c?
Hi converting Informix Online 5.1 esql/c to Dynamic Server esql/c? What is the easiest way to do this? Is there a parser that could do this? edward…
Informix Security
Does anyone know where I can find some info, about security of informix database. Besides privilages and roles. I mean things like secure connections to the database. Thank you david.tamburin@protegrity.com…
RAID Technolgy
We are using Informix Online Dynamic Server 7.2. We are going in for a new DEC UNIX Server with RAID Technolgy. It incorporates mirroring at the hardware level. So is it not necessary to do mirroring using Informix?. Can anybody give suggestions regarding mirroring and other feat…
Chinese DataBlade for IDS/UDO
News brought to you by SunTEK: SunTEK's Chinese Text Search DataBlade Module for Informix Dynamic Server (IDS/UDO) has been formally certified by Informix's DataBlade Certification Program. It is one of the first datablades certified in Asia and the first in Asia outside Japan a…
Informix on Linux
Does anybody know how much a copy of Informix Dynamic Server would run me for use on Linux?? Thanks in advance -steve…
Upgrade Dynamic Server 7.13 - 7.24
I need to upgrade Informix Dynamic Server version 7.13 to version 7.24. Can anyone advise of any problems they may have had whilst doing this?…
Informix Dynamic Server 7.31?
Is any information available regarding the release of IDS 7.31 for Unix? We have Sun E3000 and E4000 machines and are experiencing problems with both 7.30.UC3 and 7.30.UC5 and are curious about 7.31. Thanks. Carleen Avant Naval Safety Center Internet < cavant@safecen.navy.mil …
STRING FUNCTIONS
Are there functions for manipulating varchar type, like upper() or lower() in Informix Online Dynamic Server 7.2? Thanks in advance.…
Netscape Enterprise Connection for Informix Dynamic Server
Hi: Does anyone know the procedure for setting up a Netscape Enterprise Server to connect to an Informix Dynamic server on a remote machine? Michael…
oninit: shared library problem
I'm having problems when initialising the DB using oninit. Config: INFORMIX Dynamic Server Ver 7.23, on a UNISYS-UNIX SVR4. When Initializing, I get the error ...dynamic linker: oninit: symbol not found: gettimeofday The LD_LIBRARY_PATH is set to $INFORMIXDIR/bin and �INFORMIXDIR…
Initi DB
I'm having problems when initialising the DB. Config: INFORMIX Dynamic Server Ver 7.23, on a UNISYS-UNIX SVR4. When Initializing, I get the error ...dynamic linker: oninit: symbol not found: gettimeofday The LD_LIBRARY_PATH is set to $INFORMIXDIR/bin and �INFORMIXDIR/esql help wo…
Index on Informix Online 7.22 ?
I have installed a new Informix Online Dynamic Server 7.22UC3 on our server (HP-UX 10.20). I find it is much much slower than the Informix 7.12 Online DS server if I do not create index for a same program. Why and what is the difference between the two version of Dynamic serv…
Re: esqlvers statement.....results are different on 2 DB servers ???
Tim Jones wrote: > > I've installed Informix 7.30UC3 with the ClientSDK 2.01 software on 2 > servers. Let's call them Server A and B. > > Both A and B had a prior ESQL/C versions. > > After the install, logged in as informix userid on A and ran "esqlvers" > and got this : > I…
esqlvers statement.....results are different on 2 DB servers ???
I've installed Informix 7.30UC3 with the ClientSDK 2.01 software on 2 servers. Let's call them Server A and B. Both A and B had a prior ESQL/C versions. After the install, logged in as informix userid on A and ran "esqlvers" and got this : INFORMIX-ESQL Version 7.22.UC1 …
Informix Dynamic Server Personal Edition
What development apps are known to work with IDS-PE for 95? Infrmx wants to sell me licenses for Dynamic 4gl, esql-c, ddvb for 150usd. Do these work and are there others? 150 sounds ok but the catch is is that the Open-Line Support is outrageous for this (3K usd for unlim. suppor…
Will informix 7.24.uc5 compatiable with solaris 7?
Hi there, I was wondering if Informix Dynamic Server 7.24.uc.5 will be compatiable with solaris 7 when it comes out? Thanks advance, Pat Militzer pmilitzer@ultracom.com…
Informix Online Dynamic Server 7.2.2
When I try to iniailize the shared memory I get an error "oninit: Critical error initializing shared memory" I checked the log and it says the base memory address is 0x80080000 and should be 0x80400000 when I change it it reverses. this is on a SCO open server 5. nay ideas.…
Informix Dynamic Server on Linux NOW!
Check out the Informix WEB Site. There is an announcement that IDS 7.3 is shipping on Linux TODAY! http://www.informix.com/ Art S. Kagel…
Problem installing to NT4.0 server
I'm trying to install Informix dynamic server workgroup edition to Primary domain Nt 4.0 Server. I have created Informix-Admin group and Informix account and grant it all Administrators rights and also Domain administrator rights. The server setup runs ok, but when setup is tryi…
Unicenter/Informix
Anyone, If CA Unicenter (not sure the version) is used as the primary access control tool for an Informix database residing on a HP Unix server? What key settings in terms of security policies in Unicenter need to be effected (e.g., log file parameters, user roles or condit…
Deployment Licenses of Informix Dynamic Server
I need a free Deployment Licenses of Informix Dynamic Server!…
Re: Informix Dynamic Server blocks
In article <3609EB18.2AB1B1CD@bull.net>, Helmut Leininger <Helmut.Leininger@bull.net> writes >Hi, > >Sporadically, the Informix server seems to block (every try to connect >or onstat times out and no reaction on onmode -ky). In the MSGPATH I >find the following message: > >09:03:…
Informix Dynamic Server blocks
Hi, Sporadically, the Informix server seems to block (every try to connect or onstat times out and no reaction on onmode -ky). In the MSGPATH I find the following message: 09:03:42 mt.c, line 8362, thread 2139, proc id 17096, mt_notifyvp timed out. Informix server is 7.22.UC2…
Re: obtaining session id
Nicole, If you are using Informix version 7.3 then you can use the dbinfo function, as in: dbinfo('sessionid') Otherwise, if the client is running on the server machine, e.g. a typical Informix-4gl application, then you can use: select sid from sysmaster:syssessions where…
Informix Dynamic Server blocks
Hi, Sporadically, the Informix server seems to block (every try to connect or onstat times out and no reaction on onmode -ky). In the MSGPATH I find the following message: 09:03:42 mt.c, line 8362, thread 2139, proc id 17096, mt_notifyvp timed out. Informix server is 7.22.UC2…
TimeSeries-datablade
Can anyone tell me how the Informix TimeSeries datablade works for real. I have read the Informix User's guide but that kind of information is not really what I wanted. I need an in-depth logical model which explains how Informix has implemented the timeseries. I'm not interested…
Re: OnLine Dynamic Server 7.2 Vs INFORMIX Dynamic Server 7.3
On Tue, 28 Jul 1998 14:40:44 -0500, Ben Jazi <bjazi@fallschurch.esys.com> wrote: >What are the major differences between INFORMIX-OnLine Dynamic Server >7.2 and INFORMIX Dynamic Server 7.3? Is it ORDBMS vs RDMBS? No, IDS 9.x is the ORDBMS. This autumn the 7.3 and 9.x code lin…
Re: OnLine Dynamic Server 7.2 Vs INFORMIX Dynamic Server 7.3
Ben Jazi wrote: > > What are the major differences between INFORMIX-OnLine Dynamic Server > 7.2 and INFORMIX Dynamic Server 7.3? Is it ORDBMS vs RDMBS? > > Thanks, > Ben I don't know the differences in detail but you could check the following pages, where IDS 7.3 is described …
OnLine Dynamic Server 7.2 Vs INFORMIX Dynamic Server 7.3
What are the major differences between INFORMIX-OnLine Dynamic Server 7.2 and INFORMIX Dynamic Server 7.3? Is it ORDBMS vs RDMBS? Thanks, Ben…
Informix computer Base classes
Has any body used the Informix computer base training classes. I am wondering if any of the computer based training classes: "Informix Dynamic Server System Administration" or the "Managing and Optimizing Informix Dynamic Server Databases" is good. Thank You…
Re: Unformix TimeSeries Datablade
UIA User (nibblus@hotmail.com) wrote: : Can anyone give me a realistic logical model of how timeseries are : implement by Informix? I'm not interested in the explenation given in : the user's manual. No, I'm looking for the REAL model used by Informix. The explanation in the …
Re: Informix Online Dynamic Server 7 on Linux
Piet le Roux wrote: > > If anyone has succeeded to run Informix ODS 7 (SCO) on Linux help would > be appreciated. > I have installed iBCS and the shared libraries and the binaries work, > except that the engine cannot initialize shared memory: Error message > semctl: errno 22…
Informix Online Dynamic Server 7 on Linux
If anyone has succeeded to run Informix ODS 7 (SCO) on Linux help would be appreciated. I have installed iBCS and the shared libraries and the binaries work, except that the engine cannot initialize shared memory: Error message semctl: errno 22 create_vp: cannot allocat m…
Problems with Informix Dynamic Server for NT
Hi Has anyone tried downloading and running the dynamic server product for NT? I have it installed, but get the following error when I boot the system: AdmAgent.exe - Applicatioin error The instruction at "0x10087c69 referenced memory at "0x00000000". The memory could not be r…
Re: Images in IUS
You should look into the Web DataBlade, it will let you upload and and download(view) images with a web browser.…
IUS & webdriver: how to display text column ?
Having IUS 9.13 UC1 with web datablade 3.30 UC5 under Solaris 2.6 it seems to be unpossible to select a text column: >>> Exception from Informix: XIX000:-9634:No cast from text to lvarchar. Is there a newer web datablade version which does this or any workaround ? Because a ta…
Posting from the Informix-list
As far as the Web DataBlade Module is concerned, what are the implications of having the web server on a different machine than the informix engine? On which machine should we install the Web DataBlade Module? How will remote directories be referenced? (rsh, etc.) Thanks again…
RE: What are the differences between Informix Dynamic Server
It is confusing! =20 Here's what I know: Prior to renaming: 7.2x =3D ODS 8.0 =3D XPS 9.1 =3D IUS After renaming: 7.2x =3D IDS 8.0 =3D IDS/AD/XP 9.1 =3D IDS/UDO=20 After the 7.3 release: 7.3 =3D IDS 9.1 =3D IDS/UDO After the 8.2 release: 8.0 =3D…
RE: What are the differences between Informix Dynamic Server and
This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. ------ =_NextPart_001_01BDA3AF.9242A58C Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Good quest…
Re: IIUG - New engine survey, your input needed
Klaus Weitzer wrote: > > After filling out your form i wonder if only those 'new' features are being > discussed. > > My additional wishes are: > Conversion functions in insert statements. > eg. todate ( as oracle ) > > Definition of 'atomic' transactions > cause …
Re: IIUG - New engine survey, your input needed
After filling out your form i wonder if only those 'new' features are being discussed. My additional wishes are: Conversion functions in insert statements. eg. todate ( as oracle ) Definition of 'atomic' transactions cause of problems in a multithreaded environm…
Re: Index for Informix Dynamic Server
William Lai wrote: > > Hello, > > We alreay upgrade our database server from SE5.X to IDS 7.3. After we > convert all the old data to the new server, we have some problems on the > index search. For example, a table: > > table : ith ( ithitno, ithname ), total 1,500,000 records…
Re: Index for Informix Dynamic Server
William Lai <rwie@netvigator.com> offerred: +We alreay upgrade our database server from SE5.X to IDS 7.3. After we +convert all the old data to the new server, we have some problems on the +index search. For example, a table: + +table : ith ( ithitno, ithname ), total 1,500,000…
Index for Informix Dynamic Server
Hello, We alreay upgrade our database server from SE5.X to IDS 7.3. After we convert all the old data to the new server, we have some problems on the index search. For example, a table: table : ith ( ithitno, ithname ), total 1,500,000 records index : ith_1 on ithitno, ithn…
IUs - transaction + multiuser
Hi ! Is it possible to control transaction from WWW page using Universal Server and WEB datablade ? Is it possible to configure WEB datablade that multiple and different users are connecting to database ? It seems that user setup in web.cnf file is the only one. Thanks in advan…
Re: video datablade module registration
In article <356DE4B8.6F5F@usc.edu>, LIAN DUAN <lduan@usc.edu> wrote: >I am using informix video datablade module . Anybody know which module >should I register in a database . Maybe there are some prerequired >module registration ? >Thank you for your answer . >Jerry Duan You n…
Re: Roles and Security
Herb Blacker wrote: > > Here's an interesting problem...we're developing a large OLTP appl. with > a nationwide usage of roughly 4,000 users. We certainly don't want to > 'grant select to public' on this database, so we've developed about 40 > roles with specific permissions. Thi…
Roles and Security
Here's an interesting problem...we're developing a large OLTP appl. with a nationwide usage of roughly 4,000 users. We certainly don't want to 'grant select to public' on this database, so we've developed about 40 roles with specific permissions. This will handle normal procesing…
video datablade module registration
I am using informix video datablade module . Anybody know which module should I register in a database . Maybe there are some prerequired module registration ? Thank you for your answer . Jerry Duan…
In addition, How to upgrade Web DataBlade Source from Illustra to IUS?
Do you know how to upgrade Web DataBlade Source from Illustra to IUS. There are some kind of differences between them. If you know any informations about this. Please let my know. Thanks.…
Informix Dynamic Server 7.3
Hello, Since I'm planning a Data Warehouse, I would to do it with the new version of Dynamic Server. Impressions, stability and on which platform? Regards. Fernando _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ Fernando Collalti Phone: +…
Re: Error 32504 - solved :(
In <6jg4g5$qp7$1@godzilla.zeta.org.au> batonnet@zeta.org.au (Bryan Tonnet) writes: In case anyone's interested; >As there are several hundred users total at these sites, and each site's local >administrator has autonomy to add and delete users as required, it has become >a comp…
Informix Dynamic Server & Text columns
Hi everybody, Can you help me ? I've created a table with the following structure : column type -------- ---- code smallint obs text How can I insert into this table with Java program ? I'm using Informix Java AP…
Use of Informix "roles" ... was Re: Database Security
Using "low-level function based" roles is a great idea, especially if you have a application / functional grouping of people above that so you can assign groups to roles (logically) instead of people. However, roles in Informix have serious limitations: - Each connection must u…
Database Security
Hello, everyone, I've been given the task of developing a security plan to control database access. I'm considering creating a set of roles for each database, based on the business needs for each one (i.e. a read-only role, a read-and-insert role, etc.) My question is, have an…
IUS : locking with datablade Web.
Hello users of IUS and datablade Web, We are working with IUS 9.12 (UC2) and Web datablade 3.30. We have a database on which we do only reading request (only select) and many locks are fixed (we look it with onstat -k). Of course, it's a web application and sometimes request are …
Intermittent Problem - error 529 Cannot attach to transaction
We have a HP-UX box (Ver 10.20) running Informix Online Dynamic Server Ver 7.13 and a NT Server (NT4.0) running Informix Online Dynamic Server Ver 7.23. We are trying to access some of the database tables resided in the HP-UX box from the NT Server via synonyms. But we faced inte…
Image and Web Datablade
Hi, anybody know how to extract graphics from image datablade and and show it in HTML using Web Datablade? Dominic…
Re: How to web enable Informix database
Try Using PHP, http://php.apache.org, I think it works with Informix, it is very nice. It runs as an apache module or cgi. Much Better than the DataBlade. (IMHO). --Zach Kessin…
Virage Media Management System/Virage DataBlade
Is anyone using either the Virage Media Management System (VMMS) or the Virage DataBlade version 2.0.UC1 with Informix Universal Server 9.1.3? We are having some problems installing VMMS. We are also having problems using the VIR Datablade VIR 2.0.UC1 under Universal server. Can …
Re: ODBC with informix
Glyn, This problem has been addressed often before with no really elegant solution. The essence of the problem is that security mechanisms are programmed into the application(s) while ODBC enables users to bypass this security and access the database directly. Perhaps the only p…
Migration WEB datablade 2.2 to WEB datablade 3.3 (IUS). HELP.
HI, I am working in the migration of the old illustra database with web datablade 2.2 to the new informix universal server with datablade 3.3: Does anyboby knows the correct sentence to do this with the new datablade?: return current_time; Thanks in advance, -…
Re: Using Datablades
>Hi, > >Is anyone out there building datablades? How easy are these things to >generate? Is there some type of toolkit for generating them? > > Yes to both questions. Madison Pruet…
Using Datablades
Hi, Is anyone out there building datablades? How easy are these things to generate? Is there some type of toolkit for generating them? TIA…
How can I read the header tape of the archive created by ontape?
I have Informix Dynamic Server 7.23.UC1. I would like know the tape header structure created by ontape.…
Re: Informix left standing
The Datablades offered by third party and Informix are a type of app are they not?…
Re: Informix security
John, We are currently using database roles in both production and development environements. All access to the roles (ie. granting, revoking, setting) is done through dba stored procedures to limit access. These stored procedures can be executed from dbaccess as well as clien…
Re: Informix security
Michael Segel wrote: > > John Carlson wrote: > [SNIP] > > Read it. While it woould work under normal circumstances . . . > > > > We have a test system and a production system. 4GL developers have > > command-line access to both systems, although rarely on the production > > sys…
Re: Stored Procedures AC?
Tobias Svennebring wrote: > > Hi > > I wonder if there is a way to control who has access to my Stored Procedures? > > Sincerely Tobias Svennebring I'm assuming that you mean execute access as opposed to creation etc. You can set at a database level on a per user basis you can ex…
Re: Informix security
Hi, The articule on "Roles - A new Security Feature in Informix 7.1" is available on my web site at: http://www.advancedatatools.com/articles.htm or at the Washington Area Informix User Groups web site at: http://www.iiug.org/~waiug/iugnew54.htm Regards - Lester Craig.Lan…
Re: Informix security
John Carlson wrote: [SNIP] > Read it. While it woould work under normal circumstances . . . > > We have a test system and a production system. 4GL developers have > command-line access to both systems, although rarely on the production > system. My understanding of roles is th…
Re: Informix security
Clem Akins wrote: > > John asks: > >Anyone out there setting permissions at the user level? I'd like to > >implement basic security on our system at the table level. DB > >Privileges would be an option, but HP is not on the port list for 4gl, > >only RDS (which we don't use). …
Re[2]: Informix security
I would be interested in getting the paper. Also are you guys explicitly putting the set role in your code? That seems like the only setback in using roles. Thanks, Craig Lanford Mailto:craig.lanford@alltel.com On Fri, 13 Feb 1998, John Carlson wrote: >> Anyone out there set…
Re: Informix security
On Fri, 13 Feb 1998, John Carlson wrote: > Anyone out there setting permissions at the user level? I'd like to > implement basic security on our system at the table level. DB > Privileges would be an option, but HP is not on the port list for 4gl, > only RDS (which we don't us…
Re: Restricting ODBC access
>> [ DBA's nightmare with ODBC access ] >> Can anyone come up with a way to prevent database access via ODBC? I >> can't simply deny ODBC drivers to all PC users - there are other >> databases to be accessed. Uh, I'm not sure what the problem is, but the ODBC driver that I use a…
Re: Restricting ODBC access
Someone once mentioned making the role name a secret, i.e. the name of the role itself becomes a sort of password which would be built into the applications. Does this not work? Michael Segel wrote: > > Dave Otto wrote: > > > Easy if you are running 7.1+. Use ROLES. If there i…
Re: Restricting ODBC access
Dave Otto wrote: > Easy if you are running 7.1+. Use ROLES. If there is no default role > defined, then the first the application must do is execute the > "set role..." statement. Unless the user has access to a SQL > command AND knows the appropriate role to set, s/he will b…
Re: ACE and SET ROLE
In article <34E07EA6.1E89@uk.ibmmail.com>, Peter Ede <peter_ede@uk.ibmmail.com> writes >Hi. > >We have a 7.22uc1 Online DSA database and we have a need for high levels >of security. Extensive use of Stored Procedures have been deployed to >cater for data access/changes within the…
Re: ACE and SET ROLE
ACE and ISQL will use whatever the default role is for the user. In our application, we only care about changes to the data so we create a default role with primarily read access and grant that role to "public" -d Peter Ede wrote in message <34E07EA6.1E89@uk.ibmmail.com>... >Hi…
ACE and SET ROLE
Hi. We have a 7.22uc1 Online DSA database and we have a need for high levels of security. Extensive use of Stored Procedures have been deployed to cater for data access/changes within the application. Table privileges are allocated to ROLES, the application using SET ROLE where …
Re: Upgrading Informix from Online engine to Dynamic Server
Seth Grimes wrote: > > Jane Vohden wrote: > > > > I have been talking with Informix about upgrading our site from the > > 5.xx Online engine to 7.2x Dynamic Server. They said there was no cost > > I don't think that anyone has pointed out the mistaken terminology > h…
PRESS:INFORMIX OBJECT-RELATIONAL DATABASE LEADS THE INDUSTRY
INFORMIX OBJECT-RELATIONAL DATABASE LEADS THE INDUSTRY WITH 1,000 CUSTOMERS Informix Experiences Increased Demand for Extensible Object-Relational Database MENLO PARK, Calif. (January 20, 1998) Informix Corporation (NASDAQ: IFMX), the leading provider of innovative enterprise …
What's the difference between ODS 7.22 and 7.23?
What's the difference between Informix Online Dynamic Server version 7.22 and version 7.23? Thanks in advance. Bill Westphal Rodney District Council mis@rodney.govt.nz…
ODBC unix and dynamic SQL
Hi, Can someone give me some help on using informix odbc drivers (unix) with dynamic SQL on Informix-online dynamic server (7.22 unix) when I use "SQLprepare" I receive the message "too many or too few host variables given" but I think all is Ok R. Gueye…
Informix & Audio/Video Datablades
Hi, Has anyone had any success using Datablades to stream audio/video content? Regards -Lawrence…
Re: Create Roles
Harold, > Does anybody know the syntax for the create role statement? I have looked > through all of our informix books and I can't find any references to the > exact syntax to use. > > Also any comments on using roles to limit access to the databse would be > appreciated. Cur…
Re: Create Roles
On Fri, 24 Oct 1997, Harold Luse wrote: > Does anybody know the syntax for the create role statement? I have looked > through all of our informix books and I can't find any references to the > exact syntax to use. CREATE ROLE rolename; In I4GL, you'll have to prepare it. Yo…
Create Roles
Does anybody know the syntax for the create role statement? I have looked through all of our informix books and I can't find any references to the exact syntax to use. Also any comments on using roles to limit access to the databse would be appreciated. Currently all of our se…
Re: User Access, security setting
Syed wrote: > > Hi everybody, > > My team(Dev. Team) and me are new to Informix and Relational Database > system. Traditionally we use to store the User details and password as > well as access level in a data file(table) and in each module we, check > whether a user have access …
RE: Security and the ODBC
set role appl; select count(*) from wippage@hospital4:t600_wip_page; Doesn't work. I'm connected to database mris_prd and this database has a role called appl. The wippage@hospital4 has no rights to public and only understands the appl user and appl role. You cannot select da…
Next Extent Calc.
Hi, I have INFORMIX-OnLine Dynamic Server Version 7.14.UD2. Does anyone know of a script or program to calculate the next extent size ? Thanks in advance Manuel…
IUS: Datablades & portability
Hi. I have a few conceptual questions about datablades that I hope some one could help answer. From what I have gathered so far, datablades can roughly be interpreted as a form of data type. (Complex, non-standard ). Eg:- a complex equation, multimedia combinations, datasheets,…
Re: database export ??
Cristian Perez Bravo wrote: > > Hello : > > I got a question . > > Anybody knows to come down a database to plain text. ?? > > Something like the command dbexport for Informix ?? > > The answer can send it to cperez@…
compiling w/ datablade api
Has anyone tried compiling code that uses the datablade API under IUS? Where are the libraries located? I tried compiling the simple "connect1.c" in the Datablade API Programmer's Manual, but was not successful. I need to include libraries that define necessary functions like m…
Java and Informix Dynamic Server 7.x
Hi friends! I am trying to do server-side java cgi programming to connect to I-ODS 7.x. Do you know how I can do that? I heard it is possible to use the jdbc-odbc bridge( intersolve or openlink's), but the performance is too slow, because of jdbc to odbc and odbc to jdbc convert…
Illustra's Datablade and Universal Server
Hi, Does any one have any experience to share on Datablade and Informix's Universal server? Technical features - differentiating features vs. competition Performance Cost Ease of use Learning curve etc. Thanks in advance Ashi e-mail: ashi.shah@ctg.com or ashah@gw.ctg.com…
Web AND Image datablades
Hi, We are designing a Web server with illustra, and we would like to use the Image Datablade in conjuction with the Web Datablade to treat photographs. But although Jpeg is by far the best image format for photography, the Image Datablade does not recognizes it, so we cannot ma…
Re: What DB to use for lots of IMAGE files?
In article <5lja9a$g5u$1@news2.xs4all.nl>, Kees Pijnenburg <kpijnenb@xs4all.nl> writes > >As an example assume a table containing usernames and picture >names to indicate whether or not a user has access (I know, a >lousy setup for maintenance). Now it would be nice if each user …
Literature on Informix
Does anybody know about recommandable literature on Informix or Illustra Servers? I am especially interested in The Universal Server and Datablades!…
easiest web access of informix
i've tried the web datablade and hated it. is there something else out there for accessing informix without having to write C or C++. What about a perl library? thanks, frank --…
Re: Info. on Informix Universal Server
A friend pointed out that I was not clear in the previous message. I was speaking about vendor created DataBlades that need to interface directly with the data, not user-created DataBlades or many of the more straight-forward third party DataBlades (not that they are any less us…
Illustra performance with Web DataBlade
I am experiencing major performance problems with multiple simultaneous users on Illustra Web DataBlade. We tend to get very long delays and deadlock errors. I'm not the tech guy, but is there anything I can pass along that might help him resolve this? Thanks. Peter Meyerhoff…
roles and stored procedures -Reply
Andrew: Yes. We assign users to different roles for different applications. When the user first executes an app, the security module takes the USER, and Application name to determine from our security table the user's role. This value is then used to execute the 'set role…
ILLUTRA/IUS and WEB DATABLADE
hi there does anyone know whether, when using the web datablade and html forms, does the database automatically treat any incoming data posted from the forms as a transaction. Its just that I am designing a DB and web front end and Im not sure whether the DB would lock all the re…
Re: Image datablade to Web?
<HTML><BODY> Markus Grønneberg Wold wrote: <BLOCKQUOTE TYPE=CITE>Has anyone managed to make pictures stored as "image" accessible on <BR>the web? I want to use the functions available in the Image Datablade <BR>on the images, so using LargeObjects doesn't …
Image datablade to Web?
Has anyone managed to make pictures stored as "image" accessible on the web? I want to use the functions available in the Image Datablade on the images, so using LargeObjects doesn't do the trick. We use Illustra Release 3.2.1 on Windows NT 3.51, Web datablade release 2.1 and Im…
PRESS: Informix in the News
List of Informix related articles. Format: PUBLICATION "Article Name" Summary of Article [Date, Location in Publication, Author] Informix in the News --------------------------------- (03/17/97) PC WEEK ONLINE "Informix modifies suit against Oracle" Informix is refining its la…
Web DataBlade /Server Security
Hello, I am using Web DataBlade with NSAPI and Netscape Enterprise Server. Once a user has 'signed on' , is there any way to force the sign-on 'pop-up-window' again. The only way I have been able to do this is to shut down and restart the browser on the client side. Thanks, Mike…
#B6.6.101-115 US-DC/VA/MD Region Big Six Firm Database, System Architects, Distributed Systems, UNIX/NET Admin, Baan, SAP, PeopleSoft, Oracle, Sybase, Informix, Basis, ABAP, Process Change
Position IDs with each paragraph: Locations: Out of DC/VA/MD Region 15 different Positions/Roles separated by industry. Systems Integration #B6.6.101 Position Titles: System Architects Previous system architecture experience for enterprise client/server solutions with demonstr…
Re: Agghhh!!!Where's the embedded SQL???
This is one of the uses of the web datablade with IUS Madison Pruet…
#B6.6.101-115 US-DC/VA/MD Region Big Six Firm Database, System Architects, Distributed Systems, UNIX/NET Admin, Baan, SAP, PeopleSoft, Oracle, Sybase, Informix, Basis, ABAP, Process Change
Position IDs with each paragraph: Locations: Out of DC/VA/MD Region 15 different Positions/Roles separated by industry. Systems Integration #B6.6.101 Position Titles: System Architects Previous system architecture experience for enterprise client/server solutions with demonstr…
ILLUSTRA Web datablade and NSAPI
hi. I'm wrestiling to put NSAPI Webdriver at work. I use Netscape Enterprise 2.0 Web server, ILLUSTRA 2.2 Web datablade and ILLUSTRA 3.2 ORDBMS. I followed the Web datablade user's manual instructions, but the system doesn't start. With some correcting actions, I'm now able …
#B6.6.101-115 US-DC/VA/MD Region Big Six Firm Database, System Architects, Distributed Systems, UNIX/NET Admin, Baan, SAP, PeopleSoft, Oracle, Sybase, Informix, Basis, ABAP, Process Change
Position IDs with each paragraph: Locations: Out of DC/VA/MD Region 15 different Positions/Roles separated by industry. Systems Integration #B6.6.101 Position Titles: System Architects Previous system architecture experience for enterprise client/server solutions with demonstr…
Macromedia DataBlade information??
Hello. Anyone out there know anything about the Macromedia DataBlade for Informix Universal Server? It was announced along with 20+ other new blades, but I can't find out anything about it from the Informix or Macromedia Web sites, and the Informix staff I've spoken to don't kn…
#B6.6.101-115 US-DC/VA/MD Region Big Six Firm Database, System Architects, Distributed Systems, UNIX/NET Admin, Baan, SAP, PeopleSoft, Oracle, Sybase, Informix, Basis, ABAP, Process Change
Position IDs with each paragraph: Locations: Out of DC/VA/MD Region 15 different Positions/Roles separated by industry. Systems Integration #B6.6.101 Position Titles: System Architects Previous system architecture experience for enterprise client/server solutions with demonstr…
Universal server with verity datablade
Has any used Informix Universal server with Verity datablade. I am extremely interested in performance and integration issues. Please send me mail at gjuneja@gte.com. Thanks…
Java and Informix-Universal Server
I'm evaluating Informix-Universal Server as a server platform for developing a mid-size corporate application in Java. Have you had experience using java with Informix servers and the Web Datablade? I'm specifically interested in how java applets perform with Datablades. If you'…
ADVICE? PostScript DataBlade...
We're considering making a DataBlade of our conversion tool. I'd appreciate any advice on it. The DataBlade would: - give database developers 11 output formats as long as they make their application print to PostScript. The formats are MIF, WMF, CGM,…
Re: Need to create a highly secured database
In article <5bdd2c$rds@gcsin3.geccs.gecm.com>, Bruce Horrocks <Bruce.Hor rocks@gecm.no_junkmail_please.com> writes >jmj22026@glaxowellcome.com wrote: >>There is no need to buy anything extra to do this >>job. You can use roles to do everything needed. > >Rubbish. Roles won't giv…
Web datablade bbs
I'm looking for a canned solution for an Intranet bulletin board application (AIX Server, Netscape clients, static, one-way publishing; no discussion group or threads in this one..) using the Web datablade. Any help is appreciated. John Beatty Sprint john.beatty.corpis42@igate.…
Re: Informix evaluation
In article <32B9D4FD.375E@alliedsignal.com>, Naushi Hussain <hussain@alliedsignal.com> writes >We are doing an eval. of some high end DBMSs for a MPPS applications. If someone >could help me define these terms ( a line each) and why would they be necessary >to consider in evaluat…
Intl. Journal of Digital Libraries Vol. 1 Num. 1
International Journal of Digital Libraries (JODL) Springer Verlag Editors-in-Chief Nabil R. Adam Yelena Yesha Rutgers University, CIMIC UMBC/NAS…
Re: Informix 7.12: Stored Procs vs Roles
mmcnul@wall.ny.jpmorgan.com (Mark McNulty) wrote: :In article <57f7o5$sk3@nntp.idgonline.no>, :Nils Myklebust <Nils.Myklebust@idg.no> wrote: :>There is one significant problem with set role. :>If someone know the role name they can set it themselves (via an ODBC :>connection per…
Re: Australia please: Student Survey; Relational Database Management Systems (RDBMS)
Sean Chivers <navare@world.net> wrote: >Hello, >Thanks for your bandwidth, I am a student at Gilles Plains College of >TAFE South Australia, currently about to complete my Associate Diploma >of Business Administration. >If you wish to -check the truthful/validate the nature- o…
Re: Client/server security
David Williams <djw@smooth1.demon.co.uk> wrote: :In article <54bdp8$m8g@nntp.idgonline.no>, Nils Myklebust :<Nils.Myklebust@idg.no> writes :>I think, I think (I hope :-)... :> :>If Informix had implemented password checking on the set role statment :>we could possibly have solve…
Re: Client/server security
In article <54bdp8$m8g@nntp.idgonline.no>, Nils Myklebust <Nils.Myklebust@idg.no> writes >I think, I think (I hope :-)... > >If Informix had implemented password checking on the set role statment >we could possibly have solved the security issues that have reasantly >been discuss…
Client/server security
I think, I think (I hope :-)... If Informix had implemented password checking on the set role statment we could possibly have solved the security issues that have reasantly been discussed in a very easy and elegant way. The statement would be: set role rolename identified by p…
Re: Database Security
settler@hobbes.dbintellect.com (Jeff Craig) wrote: :This is certainly true if you grant update privileges specifically :to that user. However, using version 7.1 feature enhancements, you :can prevent this. First, revoke the update privileges from the user :and grant him or her o…
RE:Database Security
From: Nils.Myklebust@idg.no (Nils Myklebust) Message-Id: <542uit$g64@nntp.idgonline.no> Subject: Re: Security options at different SQL-Databases with ODBC - who is best ? Date: Wed, 16 Oct 1996 14:27:35 GMT Reply-To: Nils.Myklebust@idg.no (Nils Myklebust) Organization: NM Data AS…
Re: Info required on Datablades
In article <4vccpb$5o0@cssun.mathcs.emory.edu>, "\\"juliej\\"" <juliej@inf.com> writes > Hello, > > > Does anyone have documentation on datablades? Can someone > answer the questions below? > > 1. What do you need to use datablades with your Informi…
Re: Info required on Datablades
On Tue, 20 Aug 1996, juliej wrote: >>> stuff deleted > > Does anyone have documentation on datablades? Can someone > answer the questions below? > > 1. What do you need to use datablades with your Informix engine? > 2. Can it be used with…
Info required on Datablades
Hello, Does anyone have documentation on datablades? Can someone answer the questions below? 1. What do you need to use datablades with your Informix engine? 2. Can it be used with Informix OnLine ver 5.0 ? 3. If yes what ar…
Looking for feedback on Illustra, Datablades
Hello, We are currently working on a feature article covering the Illustra database system and the Datablade technology. The article focuses mainly on how Web developers are using Illustra to solve site development and management problems. I would appreciate hearing from anyone…
Re: ODBC & Client Access
Ray Riley wrote: > > I've read on this Newsgroup somebody mentioning a product/technique called > "Roles," but I haven't been able to find any reference to it elsewhere, but it is > supposed to help manage grants etc. Has anyone heard of, or have any info on this? You still nee…
Re: Restricting ISQL access to Administrators only
Do not LOCK ISQL, lock down privilages on the tables. USE roles in application code for TABLE update. If someone is SMART enough to issuse the set role command to update the tables in ISQL they will be smart enough to just run "DBACCESS". My security measure is "Do NOT START" loc…
Informix Certified Professional Program Update
Informix offers two certification paths. Each path requires the successful completion of two exams. Each exam is US $250 and is between 60-90 minutes long. * Database Specialist for INFORMIX-OnLine Dynamic Server 7.x 111 - Database Fundamentals Exam 112 - Managin…
Re: Maintaing Informix 7 Roles
Cheryl, > In: > Article: 25232 of comp.databases.informix > From: lester@access.digex.net (Lester Knutsen) > Newsgroups: comp.databases.informix > Subject: Re: Increase Security ( A review of ROLES ) > Date: 24 Oct 1995 22:38:04 -0400 > It was stated that "The next v…
Maintaing Informix 7 Roles
In: Article: 25232 of comp.databases.informix From: lester@access.digex.net (Lester Knutsen) Newsgroups: comp.databases.informix Subject: Re: Increase Security ( A review of ROLES ) Date: 24 Oct 1995 22:38:04 -0400 It was stated that "The next version will include su…
Re: ODBC and Security
> Harald.Ums@t-online.de (Harald Ums) writes: > > I think the whole thread moves in the wrong direction. > ODBC is no more a security hole than INET alone. > ODBC only makes the underlying problem more visible. > > Someone could just as well write a dbaccess-like utility fo…
Re: ODBC and Security
Nils, I agree with almost everything you mentioned in your post. Nils.Myklebust@ccmail.telemax.no wrote: > ... > A third problem, related to the suggestions that server based applications should > switch to one common "user" whoever loged in, is that we want to know exactly who…
Re: ODBC and Security
At 09:50 AM 3/4/96 -0600, Alex Fiore wrote: >Billy Wheeler wrote: >If your database is designed with no security precautions (everyone >logs in with the same user ID, all permissions are available to >public, etc.) than that is what you get. Anyone accessing the >database using a…
Re: ODBC and Security
Hi, > Ray Kaminski said: > Some suggestions have been made as to granting and revoking access to > tables and columns. How do you deal with the situation where the 3rd party > application provides security at the value level? That is to say that a > particular user can only se…
Re: Roles
I have some explanation about roles here from an article from Mr. Lester Knutsen. I haven't used it yet. But Hope this helps. ____________ Sanjay Kumar Email: skumar@raileurope.com Rail Europe Inc. 226 Westchester Ave | Office : (914) 681 3296 White Plains, NY 10604 …
Re: Increase Security
>Date: Tue, 14 Nov 1995 13:56:41 -0800 >From: dasidwel@us.oracle.com (David Sidwell) > >(A copy of this message has also been posted to the following newsgroups: >comp.databases.informix) > >In article <46k6fg$571@cssun.mathcs.emory.edu>, johnl@informix.com >(Jonathan Leffler) wr…
Re: Increase Security
In article <46k6fg$571@cssun.mathcs.emory.edu>, johnl@informix.com (Jonathan Leffler) wrote: > Cheryl, > > >From: cherylk@spamis.jcdc.doleta.gov > >Date: Tue, 24 Oct 1995 20:00:31 -0500 (CDT) > > >On Tue, 24 Oct 1995, Jonathan Leffler wrote: > >> [...] > >> The fundamental probl…
Re: Increase Security ( A review of ROLES )
Someone mentioned ROLES. I just wrote an articule on ROLES for our User Group Newsletter. The following is the articule. I hope this is helpful. Regards - Lester ----------------------------------------------------------------- From the Washington (DC) Area Informix Users Group …
Re: Increase Security
Cheryl, >From: cherylk@spamis.jcdc.doleta.gov >Date: Tue, 24 Oct 1995 20:00:31 -0500 (CDT) >On Tue, 24 Oct 1995, Jonathan Leffler wrote: >> [...] >> The fundamental problem with any security system in SQL-based systems is >> that if UserA needs UPDATE privilege on TableB when u…
Re: Post 4.1 Questions
Stan, > Stan Wolfe asked: > 1) Is this syntax valid: > GRANT priv (column1), priv (column2) ON owner.table TO user; > for example: > GRANT UPDATE (customer_name), INSERT (customer_address) ON customers TO stan; > This is valid in Oracle but I don't think it's valid ANSI…
Re: 7.1 UC1 versus 7.1 UD1
> fnunes@individual.puug.pt (Fernando Nunes) wrote: > > Could someone explain here the differences (in specifications and > >practical) between Informix 7.1 UC1 and Informix 7.1UD1? > The Guide to 7.1 Feature Enhancements is about 200 pages.(Part No. 000-7748 if you want to ord…
Re: INFORMIX-Online Dynamic Server intallation
copy the standard onconfig file and make as few changes as possible to the different parameters. after you are sure you can bring informix online, should you begin to make changes to the onconfig parameters. Use ONMONITOR to make the changes. It will protect you from many mista…
INFORMIX-Online Dynamic Server intallation
I'm about to install INFORMIX-Online Dynamic Server V.7.1 on a SPARC 1000. Has anyone installed this database on a sparc before? If yes...do you have any suggestions or could you give me any advice on certain aspects of the installation you felt might be important to take notice?…
Global Data Dictionaries
Salutations! I'm currently doing some research on Global Data Dictionaries, and was wondering if anyone out there in net.land would be able to add to what I've been able to find (my bibliography is included below, in case that is of interest). My (perhaps incorrect) definition …