Description:
Informix database management software discussions.
|
|
|
Informix User group - TimeSeries Hands on Lab - March 22, 2012
|
| |
Folks,
Registration is open! We are excited to announce that the next Washington Area Informix User Group event will be a one-day Hands on Lab on the Informix TimeSeries technology that is being used in the IBM Smarter Planet initiative with Metering Data and Smart Grid.
...Location: IBM Office, Tysons corner, VA... more »
|
|
|
Utility to inspect RAW disk
|
| |
Is there a utility in either Informix or Solaris that will let me
inspect RAW disk, when Informix isn't running? And will I see the
name of the dbspace that Informix knew that bit of RAW by somewhere
near the start?
The customer decided to do something to their SAN without consulting
and are now facing either sorting out which bit of disk is which, or... more »
|
|
|
Informix Training for New Informix Database Administrators - March 5-8, 2012
|
| |
Folks,
Art Kagel and I will be teaching our Informix Training course for New Informix Database Administrators, March 5-8, 2012. Attend the class in person or online via our Web Training Center. This course is for database administrators, programmers, and technical support personnel who will be setting up, managing, and tuning Informix 11 or 10 databases.... more »
|
|
|
Informix ER & maintenance on historical data
|
| |
Hi all,
I have two Informix istances: IDS 11.50 - root node of ER, replicates
some tables to IDS 9.40 - leaf node of ER (read-only). A few tables
that are replicated have more than 2 thousand rows, and I have to do
massive deletes on them, since a lot of historical data have to be
extracted and archived.... more »
|
|
|
Segregation of indexes in separate dbspaces still valid?
|
| |
As a budding Informix DBA in the last century, I was told that placing
indexes in a dbspace dedicated only to indexes and apart from the
table's data enhanced performance. Is this still true? Even with the
advent of SAN technology? and using Informix fragmentation (data
partitioning)? regardless of the size of the fragments? or size of the... more »
|
|
|
Update to utils2_ak
|
| |
There is an updated release of my utils2_ak package available as of 1/30.
This update includes the following changes:
Myschema:
Shifted the implicit/explicit keyword to upper case for consistency.
Fixed a bug that was ignoring casts from or to built-in (non-UDT) types.
Dostats:
Fixed a bug in SET ISOLATION when executing immediately.... more »
|
|
|
Informix Clustered Indexes
|
| |
Hello All
Have been doing some reading about clustered indexing and wondering
what experiences other folks have had with them?
We currently do not use them in our high transaction OLTP world and am
a bit wary due to reading that they have to be "re-clustered after
table alters and are disturbed by ongoing updates" (from the manual,... more »
|
|
|
Granting DBA to all developers
|
| |
Why is it a bad idea to grant DBA to all developers? On one project I
support, the programmers all use the same project-level account
'projectXdba' to develop and run queries, but whine because they're
not able to differentiate easily the multiple running sessions by
name. The final queries are also run in production as user... more »
|
|
|
Informix User group - TimeSeries Hands on Lab - Registration is open!
|
| |
Folks,
Registration is open! We are excited to announce that the next Washington Area Informix User Group event will be a one-day Hands on Lab on the Informix TimeSeries technology that is being used in the IBM Smarter Planet initiative with Metering Data and Smart Grid.
...Location: IBM Office, Tysons corner, VA... more »
|
|
|
