| | |
Description | Compatibility | Level/
Author | Views/
Date
Submitted | User Rating |
| |
| |
 |
 Baan index performance, oxym0ron! | Informix
, Oracle | Beginner /
Steven Hauser | 8448 since
7/11/2000 11:04:57 PM | Unrated
|
| |
Baan Indexes - Anchor your Performance Firmly in the Mud. I do not know about you, but BaanIVc with the "Level 2" Oracle driver
has some of the worst indexes I have seen, well, since PeopleSoft anyway. And this is not just Oracle specific, any database wi ...(description truncated) |
| |
| |
| |
|
 baanwho.shar | Informix
| Beginner /
Steven Hauser | 5903 since
7/11/2000 10:45:50 PM | Unrated
|
| |
Informix/Baan, match DB session to bshell |
| |
| |
| |
|
Basic Application Design for System Adminstration | SQL Server 7.0, Informix
, Oracle, Other | Beginner /
Steven Hauser | 20757 since
7/11/2000 10:58:05 PM |
By 6 Users
|
| |
As a system administrator I have seen many "off the shelf" applications and in house applications that have basic administration problems. Some are just plain bad design that make the application hard to administer. Here are some tips. |
| |
Please support the site by visiting our
sponsor:
|
| |
| |
|
Find processes over time limit | Informix
| Intermediate /
Steven Hauser | 9383 since
7/11/2000 10:56:38 PM |
By 1 Users
|
| |
By Steven.Hauser-1@tc.umn.edu Find non root processes with more than TLIMIT minutes of CPU time. For machine Sun Solaris 2.6
|
| |
| |
| |
|
Got constraints? ERP does not. | SQL Server 7.0, Informix
, Oracle, Other | Beginner /
Steven Hauser | 11085 since
7/11/2000 11:08:28 PM |
By 2 Users
|
| |
The question of database level enforced constraints vs programmer applied constraints is asked occasionally by people who have not done much database development work.
|
| |
| |
| |
|
Hacks for relational algebra. | SQL Server 7.0, Informix
, Oracle, Other | Beginner /
Steven Hauser | 6014 since
7/11/2000 10:52:24 PM |
By 2 Users
|
| |
SQL is a language that does not do some
relational algebra very easily.
Here are some examples of SQL trying to do the
relational algebra operations of difference,
simple division and partition.
Other operations like intersect also need subqueries
but ...(description truncated) |
| |
| |
| |
|
Install Informix SE on Caldera Linux | Informix
| Beginner /
Steven Hauser | 3157 since
7/11/2000 10:53:19 PM | Unrated
|
| |
How to install InformixSE on Caldera Open Linux 1.2 Lite |
| |
| |
| |
|
Oracle Shell Wrap | Oracle | Beginner /
Steven Hauser | 5038 since
7/11/2000 10:51:06 PM | Unrated
|
| |
Wrap sqlplus with ksh. |
| |
| |
| |
|
Oracle SQL to check DDL change time | Oracle | Beginner /
Steven Hauser | 3827 since
7/11/2000 10:50:01 PM |
By 1 Users
|
| |
Get the name, type, date of the DDL of a user object.
|
| |
| |
| |
|
Oracle8.0.5 SQL to create instance | Oracle | Intermediate /
Steven Hauser | 5997 since
7/11/2000 10:49:00 PM |
By 1 Users
|
| |
Database instance create script used with Oracle 8.0.5. Start the <sid> instance (ORACLE_SID here must be set to <sid>). Use svrmgrl so admin procedures get run correctly. Shutdown instance, remove all datafiles, control files, lockfiles,
logfiles t ...(description truncated) |
| |
| |
| |
|
ref_load_ord.ksh | Informix
, Oracle | Intermediate /
Steven Hauser | 2365 since
7/11/2000 10:43:45 PM | Unrated
|
| |
Informix referential constraint graph. New Now includes Oracle hooks. |
| |
| |
| |
|
Restart Baan license daemon. | Informix
| Beginner /
Steven Hauser | 3092 since
7/11/2000 10:55:08 PM | Unrated
|
| |
NOTE: run as root
|
| |
| |
| |
|
timeconvert.sql | Informix
| Beginner /
Steven Hauser | 4069 since
7/11/2000 10:44:31 PM | Unrated
|
| |
Informix SPL converts datetime to Visual Basic integers. |
| |
| |
| |
|
ugly_DDL.ksh | Oracle | Beginner /
Steven Hauser | 3604 since
7/11/2000 10:47:46 PM | Unrated
|
| |
Make DDL usable for Oracle svrmgrl or sqlplus from the Oracle export/import utilities. GPL Copyleft.
|
| |
