Free Project Management Software

Drive Your Project to Succes With http://www.project-drive.net Get it now!!!! For free account go to http://freetrial.project-drive.net/account_pd.jsp

ISM corruption

How does one go about and fix the ISM if it gets corrupted after a server crash? I've read my predecessor's notes and he's only written the easy way. He said it's not exactly the correct way. The steps involve renaming the index and mm folders and restarting ISM. Then he goes on to create the backup devices and runs a backup. On his notes, he said the previous backups become unusable but he also said that there are steps to make them usable. Sadly, he didn't write them down.

KAIO

we are on AIX 5.3 (at some future point going to 6.1 i think) with informix version 10.fc9 (soon to go to version 11 FC6) and are using AIO. has anyone run into any issues turning on and using KAIO with either informix version using 5.3 for aix (or aix 6.1 for that matter)? years back we had kaio turned on but were using an older version of the DB and the OS was on HP-UX and ran into some issues when migrating to the new OS ( i think the log would say the dreaded "KAIO :out of resources). We are looking at going back to KAIO and looking for feedback, etc Thanks. Tom

Become the Best Project Manager

Collaborate With Your employees, manage your project team And Make your project a success. With Project Management Software. Get it now!!!! For free account go to http://freetrial.project-drive.net/account_pd.jsp

5 Reasons why In-memory analysis matters

If you have been tracking the BI industry for a while you will have noticed that that in-memory analysis is all the rage. The reason for this is that it is more than a techno fad. In-memory analysis really does matter. And here are 5 reasons why. [1] Fast BI deployment at low cost Lets face it most organizations are not blessed with plenty of resources (time and money) for BI projects. Traditional data warehousing can be resource intensive =96 with a dismal ROI. What in- memory analysis allows for is rapid development and deployment of analytical datasets that can be used

SMI queries to calculate the buffer wait ratio, the buffer turnover rate and the readahead utilization

Hi all, During my recent performance studies I came across these metrics. As I found it quite difficult to calculate these from the output of 'onstat -p', I thought there must be a better way. I finally ended up with these SQL queries to calculate the metrics. Bufwaits ratio: --- echo "select 'bufwaits ratio: ' || trunc(100 * (select value from sysprofile where name='buffwts')/((select value from sysprofile where name='bufwrites')+(select value from sysprofile where name='pagreads')),2) || ' %' from systables where tabid = 1 " | dbaccess sysmaster --- Buffer turnover rate:

Page size for DBSPACETEMP?

Is there any performance reason to have the Temp Dbspaces anything other than the default page size? Informix 11.10 and 11.50 Linux Redhat 4 and 5 Our current system has standard dbspaces and bufferpools of 2, 4 and 8. Our Temp Dbspaces are 4K. I am wondering why they were ever created at 4K rather than the default page size of 2K and thinking of changing them back to 2K. Or should they always be created as the largest page size possible? Would it be better to create Temp Dbspaces as 16K and they could have their own private bufferpool? Thanks Roy

how to terminate global transactions?

On my Informix instance I have two global transactions holding some locks. See onstat -G and onstat -x output below. How can I get rid of them? Also after a server reboot they are still there. onmode -Z <address> or onmode -H <address> do not work (see below). IBM Informix Dynamic Server Version 11.50.UC7IE on Solaris SPARC 10. Global Transaction Identifiers address flags isol timeout fID gtl bql data 56656bd8 -LX-G LC 0 131075 30 28 312D2D35336530656466663A613139383A34633139336231393A373461652D35336530656466663A613139383A34633139336231393A373

Why Use Project Management tools?

http://www.project-drive.net/ provides all tools, charts, reporting functions and a customizable dashboard for efficient project management and objective-oriented productivity Web based project management software allows you to save time and reduce costs at implementation and throughout the project lifecycles. Easy to learn and intuitive user interface even for non-technical business users I found Project Drive easy to use. It has made managing our research project a breeze. It has allowed my team members to work together, even from different locations. I just became part of

Buying Project Management Software

Some people think that project management software is used just for managing a software based project but it not so. It is used for other tasks as well. It helps in achieving project goals and objectives by planning, managing and organizing resources. It has the ability to track, control and mange resources. Project management software is used for bug-tracking, calendar, email notification, and much more. Try Here Free Project Management Software "Which Free Project Management Software Provider will come in your mind after the listening Online Project Management Software"? What

Re: New Informix packaging and, presumably, pricing

--0-1986188925-1274801274=:47720 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable More info about the limits, check the links bellow.=20 http://www-142.ibm.com/software/products/nz/en/infoinnocedit/ http://www-03.ibm.com/software/sla/sladb.nsf/searchlis/?searchview&amp;sear= chorder=3D4&amp;searchmax=3D0&query=3D%28informix%29and%28field+gadate%3E20= 10/05/01%29 Keep attention to resources limits for this versions... a lot of resources = aren't permitted, but....... it's for free!=20 And I not found anything saying : "not permitted us

ISAM 113 error

What does ISAM 113 error: the file is locked mean?

help tuning query

I've tried and can't get it any significantly faster.<br /> I've tried with a composite index on first_name,last_name,street1 and birth_dt, which prevents a scan of the first subquery, and I've tried without it. Either way it's about the same.<br /> I've tried using hash joins and without. About the same. Maybe a little quicker with hash.<br /> Looks like they are searching for duplicates in the table, joining on itself.<br /> Is there any ideas from those really good at sql ? Any obvious flaws ?<br /> The query used to work ok when they first made it, but some of these semi-permanent sub

Press release

Informix gets on the "smarter planet" bandwagon thanks to an IBM UK partner: http://www.earthtimes.org/articles/show/ibm-teams-with-hildebrand-to,1306545.shtml -- Cheers, Obnoxio The Clown http://obotheclown.blogspot.com I will now proceed to pleasure myself with this fish. -- This message has been scanned for viruses and dangerous content by OpenProtect(http://www.openprotect.com), and is believed to be clean.

SAP buys Sybase .. but why?

Interesting article at The Register: http://www.theregister.co.uk/2010/05/16/sap_sybase_why/ Excerpt: "Returning to Ellison's 12-year-old comment about the database biz, he singled out Informix alongside Sybase as companies Oracle could probably afford to ignore. By 2005 Informix was folded into the Big Blue family and the logic follows that had Microsoft made a play for Sybase around the mid-noughties then perhaps it would still, in its own small way, be able to look like a serious contender up against Oracle. But SAP betting on a fairly anonymous firm that in Ellison's

Looking for help with replicating Informix SE 7 & 4GL application to another AIX box

I'm looking for help with replicating Informix SE 7 & 4GL application to another Power 5 AIX box. The box will have AIX installed. Informix SE available on CD but I prefer to have an image of existing server to be restored on the 2nd box. Any suggestion or professional service offering is greatly appreciated. Bill

Throttle Deletes

Good Morning, We are running Informix 11.50.FC6. I was wondering if we have any informix SQL that will allow me to throttle a delete statement against a table. Similar to being able to use "Select first 500 * from mytable" - I would want to do "delete first 500 from mytable" and run that in a loop until there are no more records to delete. Monthly we need to delete many thousands of records from a table and I want to do it in smaller SQL steps so as not to cause too many locks and keep the transactions smaller and shorter. I know I can use other mechanisms like temp tables or wh

Yellowfin discusses, Selection criteria for an in-memory analysis solution

The evolution of reporting and analytics has seen dramatic changes in recent years. Starting with static =93green bar=94 reports in the mid-to- late '70s, information could be abstracted from mainframe systems and, often manually, transferred to spreadsheets where data could be aggregated and analyzed. Data warehousing was the buzz of the '80s, and while this did enable heterogeneous data sources to be centralized, projects were often grossly over budget and far below expectations. As technologies have matured and the advent of services- based architectures has become more prominent

So is the IIUG now pimping out the mailing list?

--_02f2e818-0e76-471e-9a1d-fa0e42264183_ Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Just out of curiosity ... Did anyone else get a pimped e-mail from Lester via the IIUG's mailer daemo= n? =20 _________________________________________________________________ The New Busy is not the old busy. Search=2C chat and e-mail from your inbox= .. http://www.windowslive.com/campaign/thenewbusy?ocid=3DPID28326::T:WLMTAGL:O= N:WL:en-US:WM_HMP:042010_3= --_02f2e818-0e76-471e-9a1d-fa0e42264183_ Content-Type: text/html; chars

Be relaxed by using Project Management Software by Project Drive

Hi Folks, Hope you are enjoying these days =EF=81=8A Is the question raised ever like =E2=80=9CHow Project Management Software Works for you?=E2=80=9D Even I had this question when I started first and was new and looking for the software to manage my projects. What I think is =E2=80=9CIt's hard to focus on one task when you know that = one task is detrimental to the success of your project. It's a great task because here you have to handle number of different tasks. When handling a project, big or small, the propensity of the project leader is to use simple Excel spreadshee

onmode -P: Unknown option

Hi, I start a drdaexec thread on IDS 11.5 FC6WE with the command 'onmode -P start $DRDA_SERVER'. The $DRDA_SERVER is an Alias in etc/sqlhosts: --------------------------------------- ids_hdw_dr drsoctcp host drdaexec --------------------------------------- The problem: How do I have to start the drdaexec thread on IDS 11.5 UC3WE? Here the command returns an error "onmode -P: Unknown option". The command "execute function task('start listen', 'ids_hdw_dr')" is not known on 11.5 UC3WE. Anyone have a good solution? Regards, Holger de Wall

Create Table with Fragmentation - Syntax Error

This is a MIME message. If you are reading this text, you may want to consider changing to a mail reader or gateway that understands how to properly handle MIME multipart messages. --=__PartE2C84732.0__= Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: quoted-printable IDS 11.50 FC6X3 Suse 10.2 =20 =20 Can anyone tell me what is wrong with the following create table statement?= I keep getting a syntax error. If I take the fragment by clause out, it = will pass a syntax check. Is there something in this table definition = that would prevent fragmentat

Foreign keys referring table in other database

Hi ! IDS 11.50.FC6 I need to set up constraints between tables in different databases. According to the documentation the tables used in a foreign key definition must be in the same database. I have also tried to use synonyms and views thar refers the table in the other databas but no success. One idea is to use ER to replicate the tables in question, another would be to write triggers that does a check against synonyms. Any other ideas anybody ? TIA Ulf

The sysadmin database: version 11

Do most people move this new system db that is created in the rootdbs by default in version 11? For those folks that do not move it, what are you seeing as far as sizing goes for the rootdbs? I am used to not placing anything else within the rootdbs so I am exploring the pro's and cons of just adding more space to our existing rootdbs (and how much to add to accomodate the sysadm db) versus moving it to a new space after initial creation Thanks Tom

Failing to configure cdr replicas between 10.00FC9W2 and 11.50FC6

Hi, first of all, have to say I'm pretty new to Informix...was coming from Oracle world, at my new position we only have Informix so I'm having a little bit of funny time getting use to it. But overall, I'm pretty amazed with Informix. Now, to my problem. We're in the process to migrate our current 10.00 installation with some replicas to 11.50. As first step we're trying to upgrade the non-root nodes to 11.50 but we're facing some problems. Let's name the nodes to try to keep things clear enough, please excuse my terminology I'm sure I'm telling names that you might find wrong