Hi !
We are trying to use ODBC to UniVerse.
Does anyone have any experience with it? Is it stable, fast ? And what kind of fun should we expect with it ? Any information will be helpful! Thank you.
Regards,
Alexey Luchko.
UV ODBC
Weve been having problems after upgradeing from HPUX 10 to 11, but were running an older version of UV 9.4.1.1I, which I suspect makes the problem worse. Under high load, uv would freeze and youd have to do a dbsetup to clear up the semaphore/locks table (re: my earlier post). In any case, fingers point to ODBC, but no one can prove anything, so take it as just a word of caution and with a grain of salt (where in the world did that expression come from?).
-----Original Message-----
From: Aleksejs Lucko [mailto:Aleksejs.Lucko@parex.lv]
Sent: Friday, October 19, 2001 4:43 AM
To: u2-users@oliver.com
Subject: UV ODBC
Hi !
We are trying to use ODBC to UniVerse.
Does anyone have any experience with it? Is it stable, fast ? And what kind of fun should we expect with it ? Any information will be helpful! Thank you.
Regards,
Alexey Luchko.
-----Original Message-----
From: Aleksejs Lucko [mailto:Aleksejs.Lucko@parex.lv]
Sent: Friday, October 19, 2001 4:43 AM
To: u2-users@oliver.com
Subject: UV ODBC
Hi !
We are trying to use ODBC to UniVerse.
Does anyone have any experience with it? Is it stable, fast ? And what kind of fun should we expect with it ? Any information will be helpful! Thank you.
Regards,
Alexey Luchko.
Couple of questions if you dont mind since we are likely to be taking that same route -- HPUX 11 and UV and ODBC.
1) Did you have lockup problems on HP10 or only upon moving to HPUX11?
2) Why do you suspect ODBC?
3) Are you running UniVerse Objects?
Ray Kelly
----- Original Message -----
From: "Klein Doyen T"
To:
Sent: Friday, October 19, 2001 9:18 AM
Subject: RE: UV ODBC
> Weve been having problems after upgradeing from HPUX 10 to 11, but
> were running an older version of UV 9.4.1.1I, which I suspect makes
> the problem worse. Under high load, uv would freeze and youd have to
> do a dbsetup to clear up the semaphore/locks table (re: my earlier
> post). In any case, fingers point to ODBC, but no one can prove
> anything, so take it as just a word of caution and with a grain of
> salt (where in the world did that expression come from?).
>
>
> -----Original Message-----
> From: Aleksejs Lucko [mailto:Aleksejs.Lucko@parex.lv]
> Sent: Friday, October 19, 2001 4:43 AM
> To: u2-users@oliver.com
> Subject: UV ODBC
>
>
> Hi !
>
> We are trying to use ODBC to UniVerse.
> Does anyone have any experience with it? Is it stable, fast ? And what
> kind of fun should we expect with it ? Any information will be
> helpful! Thank you.
>
> Regards,
> Alexey Luchko.
>
>
>
>
1) Did you have lockup problems on HP10 or only upon moving to HPUX11?
2) Why do you suspect ODBC?
3) Are you running UniVerse Objects?
Ray Kelly
----- Original Message -----
From: "Klein Doyen T"
To:
Sent: Friday, October 19, 2001 9:18 AM
Subject: RE: UV ODBC
> Weve been having problems after upgradeing from HPUX 10 to 11, but
> were running an older version of UV 9.4.1.1I, which I suspect makes
> the problem worse. Under high load, uv would freeze and youd have to
> do a dbsetup to clear up the semaphore/locks table (re: my earlier
> post). In any case, fingers point to ODBC, but no one can prove
> anything, so take it as just a word of caution and with a grain of
> salt (where in the world did that expression come from?).
>
>
> -----Original Message-----
> From: Aleksejs Lucko [mailto:Aleksejs.Lucko@parex.lv]
> Sent: Friday, October 19, 2001 4:43 AM
> To: u2-users@oliver.com
> Subject: UV ODBC
>
>
> Hi !
>
> We are trying to use ODBC to UniVerse.
> Does anyone have any experience with it? Is it stable, fast ? And what
> kind of fun should we expect with it ? Any information will be
> helpful! Thank you.
>
> Regards,
> Alexey Luchko.
>
>
>
>
1. No
2. Thats was someones opionion, and after changing the ulimit and stopping ODBC the problem went away. It could be either one solved the problem. 3. No
-----Original Message-----
From: Ray Kelly [mailto:raykelly@titantextile.com]
Sent: Friday, October 19, 2001 8:21 AM
To: u2-users@oliver.com
Cc: Ron Engelhardt
Subject: Re: UV ODBC
Couple of questions if you dont mind since we are likely to be taking that same route -- HPUX 11 and UV and ODBC.
1) Did you have lockup problems on HP10 or only upon moving to HPUX11?
2) Why do you suspect ODBC?
3) Are you running UniVerse Objects?
Ray Kelly
----- Original Message -----
From: "Klein Doyen T"
To:
Sent: Friday, October 19, 2001 9:18 AM
Subject: RE: UV ODBC
> Weve been having problems after upgradeing from HPUX 10 to 11, but
> were running an older version of UV 9.4.1.1I, which I suspect makes
> the problem worse. Under high load, uv would freeze and youd have to
> do a dbsetup to clear up the semaphore/locks table (re: my earlier
> post). In any case, fingers point to ODBC, but no one can prove
> anything, so take it as just a word of caution and with a grain of
> salt (where in the world did that expression come from?).
>
>
> -----Original Message-----
> From: Aleksejs Lucko [mailto:Aleksejs.Lucko@parex.lv]
> Sent: Friday, October 19, 2001 4:43 AM
> To: u2-users@oliver.com
> Subject: UV ODBC
>
>
> Hi !
>
> We are trying to use ODBC to UniVerse.
> Does anyone have any experience with it? Is it stable, fast ? And what
> kind of fun should we expect with it ? Any information will be
> helpful! Thank you.
>
> Regards,
> Alexey Luchko.
>
>
>
>
2. Thats was someones opionion, and after changing the ulimit and stopping ODBC the problem went away. It could be either one solved the problem. 3. No
-----Original Message-----
From: Ray Kelly [mailto:raykelly@titantextile.com]
Sent: Friday, October 19, 2001 8:21 AM
To: u2-users@oliver.com
Cc: Ron Engelhardt
Subject: Re: UV ODBC
Couple of questions if you dont mind since we are likely to be taking that same route -- HPUX 11 and UV and ODBC.
1) Did you have lockup problems on HP10 or only upon moving to HPUX11?
2) Why do you suspect ODBC?
3) Are you running UniVerse Objects?
Ray Kelly
----- Original Message -----
From: "Klein Doyen T"
To:
Sent: Friday, October 19, 2001 9:18 AM
Subject: RE: UV ODBC
> Weve been having problems after upgradeing from HPUX 10 to 11, but
> were running an older version of UV 9.4.1.1I, which I suspect makes
> the problem worse. Under high load, uv would freeze and youd have to
> do a dbsetup to clear up the semaphore/locks table (re: my earlier
> post). In any case, fingers point to ODBC, but no one can prove
> anything, so take it as just a word of caution and with a grain of
> salt (where in the world did that expression come from?).
>
>
> -----Original Message-----
> From: Aleksejs Lucko [mailto:Aleksejs.Lucko@parex.lv]
> Sent: Friday, October 19, 2001 4:43 AM
> To: u2-users@oliver.com
> Subject: UV ODBC
>
>
> Hi !
>
> We are trying to use ODBC to UniVerse.
> Does anyone have any experience with it? Is it stable, fast ? And what
> kind of fun should we expect with it ? Any information will be
> helpful! Thank you.
>
> Regards,
> Alexey Luchko.
>
>
>
>
19/10/2001 12:43:20, Aleksejs Lucko wrote:
>Hi !
>
>We are trying to use ODBC to UniVerse.
>Does anyone have any experience with it? Is it stable, fast ? And what
>kind of fun should we expect with it ? Any information will be helpful!
>Thank you.
>
>Regards,
> Alexey Luchko.
>
>
Fast :
No.
Partly because it has to normalise everthing.
Partly because ODBC is inherently slow - especially at earlier versions.
Stable :
Depends.
You need to ensure that your database is set up correctly to use it, or you may get unpredicatable results.
Ensure that all your exposed fields have data types and the correct multivalue specification. Ensure that all files have @SELECT and @KEY phrases Ensure that all multivalued associations are fully defined and have an association key Avoid field names that could clash with SQL keywords (eg USER, STATUS etc) Do not expose fields that have character conversions like MCU, MCT and MCL
Dont even think of using PICK format dictionary items with it.
I would recommend that you only use ODBC for reporting (not updating) access. Where possible use passthrough queries (check the manual for the NATIVE keyword - these run significantly quicker). Finally, if you must access using a normalising tool, the OleDB driver is quicker.
Brian Leach
>Hi !
>
>We are trying to use ODBC to UniVerse.
>Does anyone have any experience with it? Is it stable, fast ? And what
>kind of fun should we expect with it ? Any information will be helpful!
>Thank you.
>
>Regards,
> Alexey Luchko.
>
>
Fast :
No.
Partly because it has to normalise everthing.
Partly because ODBC is inherently slow - especially at earlier versions.
Stable :
Depends.
You need to ensure that your database is set up correctly to use it, or you may get unpredicatable results.
Ensure that all your exposed fields have data types and the correct multivalue specification. Ensure that all files have @SELECT and @KEY phrases Ensure that all multivalued associations are fully defined and have an association key Avoid field names that could clash with SQL keywords (eg USER, STATUS etc) Do not expose fields that have character conversions like MCU, MCT and MCL
Dont even think of using PICK format dictionary items with it.
I would recommend that you only use ODBC for reporting (not updating) access. Where possible use passthrough queries (check the manual for the NATIVE keyword - these run significantly quicker). Finally, if you must access using a normalising tool, the OleDB driver is quicker.
Brian Leach
From: "Klein Doyen T"
To:
Sent: Friday, October 19, 2001 9:18 AM
Subject: RE: UV ODBC
> ....fingers point to ODBC, but no one can prove anything, so take it
> as
just a
> word of caution and with a grain of salt (where in the world did that
> expression come from?).
In olden times, salt was thought to be an antidote for poison and have healing qualities, so taking (drinking or eating) something with a grain of salt was advice to practice preventive medicine. Today, we are figuratively protecting ourselves, using caution or skepticism, when we take (listen to) something with a grain of salt.
To:
Sent: Friday, October 19, 2001 9:18 AM
Subject: RE: UV ODBC
> ....fingers point to ODBC, but no one can prove anything, so take it
> as
just a
> word of caution and with a grain of salt (where in the world did that
> expression come from?).
In olden times, salt was thought to be an antidote for poison and have healing qualities, so taking (drinking or eating) something with a grain of salt was advice to practice preventive medicine. Today, we are figuratively protecting ourselves, using caution or skepticism, when we take (listen to) something with a grain of salt.