Re: Whatcha' wanta have?????

#31

Neil Truby wrote:

Quote:

"Preetinder Dhaliwal" <preetinder.dhaliwal (AT) dhl (DOT) com> wrote in message
news:c076eq$c86$1 (AT) terabinaries (DOT) xmission.com...

Check in onmonitor and other utilities for adding chunks, dbspaces
etc , which makes sure that user does not accidentally overwrites
existing space.

that is , it should check for overlapping atleast in the same
instance.

Is this a post from the heart? ;-)

I thought it already did this check; although it doesn't check the
underlying files if you are using symlinks or physical device names.

If the user specifies a device, I think it should issue at least a warning
if it's not a raw device. If it's not even a block device, it probably
should be a fatal error.

#32

Paul,

"Set optimization low" does not help, we've tried it.
"set optimization low" only works well after 'update statistics',
not after real 'alter table'
I think, it's related to minor/major table version change

Alexey Sonkin

Quote:

From: mosserp (AT) wellsfargo (DOT) com [mailto:mosserp (AT) wellsfargo (DOT) com]
Sent: Monday, February 09, 2004 6:58 PM

That is, after executing any DDL statement that changes table
version all
prepared SQL statements, open cursors and stored procedures
related to that
table became invalid, and user session get -710 error.

Related: Implement outstanding feature request to run "set optimization
low"
from the *server* side.

sending to informix-list

#33

Paul,

"Set optimization low" does not help, we've tried it.
"set optimization low" only works well after 'update statistics',
not after real 'alter table'
I think, it's related to minor/major table version change

Alexey Sonkin

Quote:

From: mosserp (AT) wellsfargo (DOT) com [mailto:mosserp (AT) wellsfargo (DOT) com]
Sent: Monday, February 09, 2004 6:58 PM

That is, after executing any DDL statement that changes table
version all
prepared SQL statements, open cursors and stored procedures
related to that
table became invalid, and user session get -710 error.

Related: Implement outstanding feature request to run "set optimization
low"
from the *server* side.

sending to informix-list

sending to informix-list

#34

Please remove the 32GB Tablespce limit.

owner-informix-list (AT) iiug (DOT) org schrieb am 07.02.2004 00:41:18:

Quote:

As a mild diversion from the IDS-DB2 conversion thread, its time for one
of
my more favorite exercises. ;-)

We are nearing the end of the coding cycle for IDS 9.5. We've got a
whole
bunch of really cool stuff in place and - well - its time to get input
from
you guys as to what you want to see in the 9.6 release.

Now, I know that everyone's favorite thing is going to be "marketing",
but
I'm in development. So I need to talk features and functionality. So
feel
free to send them on in.

Just an FYI - I'll be away for a while and won't be able to get email via
my
comcast email address. But, I'll be following the newsgroup rather
closely.

Also, next week I'll be in some planning meeting. So getting responses
back
fairly quickly would really help.

Thanks

M.Pruet

--

General Logistics Systems
Thomas Mieslinger
German-Parcel-Str. 1-7 fon: +49 6677 17 463
36286 Neuenstein fax: +49 6677 17 111
Germany eMail: thomas.mieslinger (AT) gls-germany (DOT) com

sending to informix-list

#35

Please remove the 32GB Tablespce limit.

owner-informix-list (AT) iiug (DOT) org schrieb am 07.02.2004 00:41:18:

Quote:

As a mild diversion from the IDS-DB2 conversion thread, its time for one
of
my more favorite exercises. ;-)

We are nearing the end of the coding cycle for IDS 9.5. We've got a
whole
bunch of really cool stuff in place and - well - its time to get input
from
you guys as to what you want to see in the 9.6 release.

Now, I know that everyone's favorite thing is going to be "marketing",
but
I'm in development. So I need to talk features and functionality. So
feel
free to send them on in.

Just an FYI - I'll be away for a while and won't be able to get email via
my
comcast email address. But, I'll be following the newsgroup rather
closely.

Also, next week I'll be in some planning meeting. So getting responses
back
fairly quickly would really help.

Thanks

M.Pruet

--

General Logistics Systems
Thomas Mieslinger
German-Parcel-Str. 1-7 fon: +49 6677 17 463
36286 Neuenstein fax: +49 6677 17 111
Germany eMail: thomas.mieslinger (AT) gls-germany (DOT) com

sending to informix-list

sending to informix-list

#36

"Madison Pruet" <mpruet (AT) comcast (DOT) net> wrote

Quote:

As a mild diversion from the IDS-DB2 conversion thread, its time for one of
my more favorite exercises. ;-)

We are nearing the end of the coding cycle for IDS 9.5. We've got a whole
bunch of really cool stuff in place and - well - its time to get input from
you guys as to what you want to see in the 9.6 release.

Now, I know that everyone's favorite thing is going to be "marketing", but
I'm in development. So I need to talk features and functionality. So feel
free to send them on in.

Just an FYI - I'll be away for a while and won't be able to get email via my
comcast email address. But, I'll be following the newsgroup rather closely.

Also, next week I'll be in some planning meeting. So getting responses back
fairly quickly would really help.

Thanks

M.Pruet

I'd like to see

- 'upsert' (update or insert)

- 'smart' foreign key constraint that uses any feasible index

- configurable buffer page pools to stop rubbish queries on large
tables flushing all buffer pages (sybase had this feature about 8
years ago).

- explicit support for temp spaces in RAM

- anything which can be done to lessen checkpoint times

- a job scheduler in the server (so that I can do things like say

at '2004-03-15 15:00:00' execute procedure my_job()

I'd like a transactional interface so that I can remove and add
jobs as part of the scheduled operation, and a bulletproof implementation
that provides guarantees about when jobs get run if the server goes
down and is restarted

Chris

#37

configurable Pagesize. Some ERP Systems like SAP have rowsizes of
2-4kilobytes. It would be extremly usefull to have pagesizes up to 64k

Madison Pruet wrote:

Quote:

As a mild diversion from the IDS-DB2 conversion thread, its time for one of
my more favorite exercises. ;-)

We are nearing the end of the coding cycle for IDS 9.5. We've got a whole
bunch of really cool stuff in place and - well - its time to get input from
you guys as to what you want to see in the 9.6 release.

Now, I know that everyone's favorite thing is going to be "marketing", but
I'm in development. So I need to talk features and functionality. So feel
free to send them on in.

Just an FYI - I'll be away for a while and won't be able to get email via my
comcast email address. But, I'll be following the newsgroup rather closely.

Also, next week I'll be in some planning meeting. So getting responses back
fairly quickly would really help.

Thanks

M.Pruet

#38

1. How about a work-around for the "old page" bug on backups ?

2. More options for restores - restoring single tables, etc.

3. Updating statistics not having an effect on programs currently running

________________________________

<< ella for Spam Control >> has removed 1269 Spam messages and set aside 234 Newsletters for me
You can use it too - and it's FREE! www.ellaforspam.com

sending to informix-list

#39

1. How about a work-around for the "old page" bug on backups ?

2. More options for restores - restoring single tables, etc.

3. Updating statistics not having an effect on programs currently running

________________________________

<< ella for Spam Control >> has removed 1269 Spam messages and set aside 234 Newsletters for me
You can use it too - and it's FREE! www.ellaforspam.com

sending to informix-list

sending to informix-list

#40

Madison Pruet wrote:

Quote:

As a mild diversion from the IDS-DB2 conversion thread, its time for one of
my more favorite exercises. ;-)

We are nearing the end of the coding cycle for IDS 9.5. We've got a whole
bunch of really cool stuff in place and - well - its time to get input from
you guys as to what you want to see in the 9.6 release.

Now, I know that everyone's favorite thing is going to be "marketing", but
I'm in development. So I need to talk features and functionality. So feel
free to send them on in.

Just an FYI - I'll be away for a while and won't be able to get email via my
comcast email address. But, I'll be following the newsgroup rather closely.

Also, next week I'll be in some planning meeting. So getting responses back
fairly quickly would really help.

Thanks

M.Pruet

I' d like to see

- physlog inital setup much like rootdbs
- same for loglog
so that one does not have to do the ever same steps at the
very beginning

- when auto build indexes (at reinable constraints time)
automatic adjustment along a ressource spec or
test of available filesystems / memory so that
it is not a crawl (like now)

- automatic usage of memory in update statistics for sorts,
if memory is around in tons (like it tends to be now
everywhere)

- better documentaion of the ER internal tables
used for conflict resolution
like: when does it go to the dbspace the db was
created in (gramented tables) or when does it sit
in the dbspace where the table is....
All that is rather documented not enough to
avoid problems of running out of space

- a new warning if you load zillions of records
into a table with using default FIRST SIZE of 8 pg

- a warning from update statistics if # of datapages
is much smaller then pages used & indexes are not
on that table or only detached ones.

- a way to tell in what file one wants output of
SET EXPLAIN ON

dic_k
--
Richard Kofler
SOLID STATE EDV
Dienstleistungen GmbH
Vienna/Austria/Europe