Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
What are best features of V2R4 1
- Thread starter nhewko
- Start date
-
1
- #2
V2r4?
4.0.x or 4.1? 4.1 was released the end of July. I would go straight to 4.1 but my opinion is a little biased since I was the Release Architect for 4.1.
The process to upgrade from 3.0.3 to 4.1 is identical to process to upgrade from 3.0.3 to 4.0.x so the upgrade process should not be of any consideration in the decision of which version to upgrade to.
Several of our large customers have already upgraded to 4.1 and have had no major issues.
V2r4 introduced Stored Procedures. V2r4.1 Extended the functionality of Stored procedures.
4.1 also enhanced the performance of stored procedures.
V2r3 introduced Triggers. V2r4.1 improved the performance of triggers if they are prime key type of transactions.
4.1 also improved the performance of prime key operations in general.
V2r4 added OLAP functions like
COVAR
COVAR_SAMP
RANK
SAMPLE
RANDOM
V2r4.1 completed the Set with
REGRESSION functions (REGR_SXY, REGR_COUNT, REGR_AVGY...)
Trigonometry functions (sin, cos, tan...)
Hyperbolic function (asin, acos, atan...)
Percent_rank
V2r4.0 had several serviceability fixes like making Checktable level one, two and scandisk run faster. V2r4.1 improved the performance of checktable Level three and enhanced scandisk to be able to fix problems.
V2r4.1 added a new Ferret command to display an estimate of the number of cylinders that could be reclaimed by packing individual tables instead of the whole disk. using the output of this new command you can make packdisk run more effiecently.
V2r4.1 added support for 128K data blocks. This improves the performance of sorts and full file scans over intermediate results.
V2r4.1 upped the number of Volatile tables from 64 to 2000 and the number of Global temp tables from 32 to 1000.
If you want, you can look over the release summaries on our web site.
Click on
Release summaries
and then click on v2r4/4.0.1, 4.0.2/4.0.3 or v2r4.1 depending on which version you want to review.
4.0.x or 4.1? 4.1 was released the end of July. I would go straight to 4.1 but my opinion is a little biased since I was the Release Architect for 4.1.
The process to upgrade from 3.0.3 to 4.1 is identical to process to upgrade from 3.0.3 to 4.0.x so the upgrade process should not be of any consideration in the decision of which version to upgrade to.
Several of our large customers have already upgraded to 4.1 and have had no major issues.
V2r4 introduced Stored Procedures. V2r4.1 Extended the functionality of Stored procedures.
4.1 also enhanced the performance of stored procedures.
V2r3 introduced Triggers. V2r4.1 improved the performance of triggers if they are prime key type of transactions.
4.1 also improved the performance of prime key operations in general.
V2r4 added OLAP functions like
COVAR
COVAR_SAMP
RANK
SAMPLE
RANDOM
V2r4.1 completed the Set with
REGRESSION functions (REGR_SXY, REGR_COUNT, REGR_AVGY...)
Trigonometry functions (sin, cos, tan...)
Hyperbolic function (asin, acos, atan...)
Percent_rank
V2r4.0 had several serviceability fixes like making Checktable level one, two and scandisk run faster. V2r4.1 improved the performance of checktable Level three and enhanced scandisk to be able to fix problems.
V2r4.1 added a new Ferret command to display an estimate of the number of cylinders that could be reclaimed by packing individual tables instead of the whole disk. using the output of this new command you can make packdisk run more effiecently.
V2r4.1 added support for 128K data blocks. This improves the performance of sorts and full file scans over intermediate results.
V2r4.1 upped the number of Volatile tables from 64 to 2000 and the number of Global temp tables from 32 to 1000.
If you want, you can look over the release summaries on our web site.
Click on
Release summaries
and then click on v2r4/4.0.1, 4.0.2/4.0.3 or v2r4.1 depending on which version you want to review.
- Status