Setup, Tuning, and Workload Performance Guide for Sybase Adaptive Server Enterprise (ASE) on Sun St
This document describes how to configure the Sybase Adaptive Server Enterprise (ASE) database server to use Oracle's Sun Storage 7000 Unified Storage Systems as a storage unit.
Dear Team
Please provide suggestion on below query which is used in Sybase Adaptive Server Enterprise/15.7 (ASE).
Query takes more time > 30 Mins to 1 Hr
All required indexes are built
Can we have any efficient approach to get the data retrieval faster for below query.Any help... (0 Replies)
Dear Team
I am using Sybase Adaptive Server Enterprise/15.7 (ASE). Trying my luck on SOUNDEX function to get unique records
Though the command works for characters and provides unique code for similar outputs.
But when i try with Starting numbers ( Followed with Street address ) , soundex... (1 Reply)
Hi Team ,
I am new to Sybase Adaptive Server Enterprise/15.7 (ASE) and need some guidance to find the different values in serial format column.
SELECT DISTINCT SERIAL_FORMAT FROM PRODUCTS
It has values with below format which contains 12 digits hexadecimal characters with... (2 Replies)
Hi Team -
I am using Sybase ASE 15.7 version. Below query is throwing an error
stating Error : incorrect syntax near the keyword 'OVER'
SELECT
EMPLOYEE_ID ,
EMPLOYEE ,
Department,
CAST( Salary as DECIMAL( 10, 2 ) ) AS Salary
CAST(AVG( Salary) OVER ( PARTITION... (3 Replies)
HI Team
I am using Sybase ASE15.7 version.
Below is the sample column values .
http://abc.lifeline.airs.com/support/
https://xyzbre.lifeline.airs.com/video/
Would like to know how to
Trim http:// and https:// from above list of example
Remove characters after first /
Include only the... (3 Replies)
Overview:
Introduction
What Does Success Mean?
What Does Performance Mean?
Every Picture is Worth a Thousand Words
Work Like a Physicist
Work Like You Walk - One Step at a Time
Learn to Know Your System
Choose Your Weapons!
Tools of the Trade 1 - vmstat
A Little Theory Along the Way -... (1 Reply)
i'm looking for an installer of Sybase ASE 11.9.2.6 for HP-UX. tried buying from the local distributor but he can only give me the latest version. can anyone point me to where i could possibly get it? (0 Replies)
Hello,
Can someone share his experience with SCO unix server performance tuning?
- how to make some performance analysis
- how to tune up a server for better performance
Thank you! (0 Replies)
asmigrate(1m) Application Server Utility asmigrate(1m)NAME
asmigrate - automates migration of J2EE applications from other J2EE platforms to Sun Java System Application Server
SYNOPSIS
asmigrate [-h | --help] [-v | --version] [(-c |--commandline) | (-u --ui) ] [-q | --quiet] [-d | --debug][-s | --sourcedirectory
source_directory] [-S | --sourceserver source_application_server] [-t | --targetdirectory target_directory] [-T | --targetserver tar-
get_application_server] [-n | --scan-native-apis-only ] [-p | --scan-packages package_list] [-j | --java2db create-tables=true, drop-
tables=true, db-vendor-name=dbVendorName] [-m | --migrate-cmp comment-pk-modifiers=true, overwrite-conflicting-accessors=true] [-f |
--file-filter all-files=true, html-files=true, java-files=true, jsp-files=true, xml-files=true, archive-files=true] [-a | --append-logs
][operands]
Use the asmigrate utility to analyze your J2EE application and translate vendor specific settings to Sun JavaTMTM System Application Server
specific settings making the application deployable on Sun's J2EE products.
The following table identifies the supported J2EE product migrations:
+--------------------------+--------------------------------+
| Source J2EE Platform | Destination J2EE Platform |
+--------------------------+--------------------------------+
|WebSphere Application |Sun ONE Application Server 6.5 |
|Server 4.0 | |
| | |
|WebLogic Application | |
|Server 5.1 | |
+--------------------------+--------------------------------+
|WebLogic Application |Sun ONE Application Server 7 |
|Server 5.1, 6.0, 6.1 | |
| | |
|WebSphere Application | |
|Server 4.0 | |
| | |
|JavaTMTM 2 Platform | |
|Enterprise Edition 1.3 | |
| | |
|Sun ONE Application | |
|Server 6.x | |
| | |
|Sun ONE Web Server 6.0 | |
| | |
|JBoss Application Server | |
|3.0 | |
| | |
|Tomcat Web Server 4.1.12 | |
+--------------------------+--------------------------------+
|WebLogic Application |JavaTMTM 2 Platform, Enterprise |
|Server 5.1, 6.0, 6.1 |Edition 1.4 Application Server |
| | |
|WebSphere Application | |
|Server 4.0 | |
| | |
|JavaTMTM 2 Platform | |
|Enterprise Edition | |
|1.3/1.4 | |
| | |
|Sun ONE Application | |
|Server 6.x | |
| | |
|Sun ONE Web Server 6.0 | |
| | |
|JBoss Application Server | |
|3.0 | |
| | |
|Tomcat Web Server 4.1.12 | |
+--------------------------+--------------------------------+
|WebLogic Application |Sun JavaTMTM System Application |
|Server 5.1, 6.0, 6.1 |Server Platform Edition 8 |
| | |
|WebSphere Application | |
|Server 4.0 | |
| | |
|JavTMTMa 2 Platform | |
|Enterprise Edition | |
|1.3/1.4 | |
| | |
|Sun ONE Application | |
|Server 6.x | |
| | |
|Sun ONE Web Server 6.0 | |
| | |
|JBoss Application Server | |
|3.0 | |
| | |
|JBoss Application Server | |
|3.2 | |
| | |
|Tomcat Web Server 4.1.12 | |
+--------------------------+--------------------------------+
OPTIONS -h --help displays the arguments for launching the MigrationTool.
-v --version displays the version of the MigrationTool.
-u --ui invokes the tool in user interface mode.
-c --commandline invokes the tool in command-line mode.
-q --quiet launches the tool in quiet mode.
-d --debug launches the tool in debug mode.
-s --sourcedirectory identifes the directory where the source code to migrate or scan is present.
-S --sourceserver identifes the source application server of the applications to be migrated. Possible servers include:
o wl51: WebLogic Application Server 5.1
o wl60: WebLogic Application Server 6.0
o wl61: WebLogic Application Server 6.1
o as65: Sun ONE Application Server 6.5
o as70: Sun ONE Application Server 7.0
o ws40: WebSphere Application Server 4.0
o ri13: JavaTMTM 2 Platform Enterprise Edition 1.3
o ri14: JavaTMTM 2 Platform Enterprise Edition 1.3
o s1ws: Sun ONE Web Server
o jb30: JBoss Application Server 3.0
o tc41: Tomcat Application Server 4.1
-t --targetdirectory target or output directory where the migrated application should be placed.
-T --targetserver target application server to which the application is to be migrated.
-n --scan-native-apis-onlscans the source code only for the presence of application server specific proprietary APIs.
-p --scan-packages comma-separated list of Java packages to scan.
-j --java2db bypasses the creation of the sun-cmp-mapping.xml file. Instead, introduces the option argument into the sun-ejb-
jar.xml file. Option arguments are:
o create-tables: if set to true (default), creates tables at deploy. If set to false tables are not created.
o drop-tables: if set to true (default), tables are dropped at undeploy. If set to false tables are not dropped.
o db-vendor-name: name of the database vendor for the application to be migrated. Supported vendor names
include: Oracle, Sybase, DB2, Generic SQL92, PointBase, MSSQL.
-m --migrate-cmp migrates 1.1 compliant CMPs, if any, to 2.0. Option arguments are:
o overwrite-conflicting-accessors: if set to true (default), conflicting accessors are overwritten. If set to
false, conflicting accessors are not overwritten.
o comment-pk-modifiers: if set to true (default), setters of primary key are commented. If set to false, setters
of primary key are not commented.
-f --file-filter selects the type of files to migrate. Option arguments are:
o all-files: if specified and set to true (default), migrates all types of files.
o html-files: if specified and set to true (default), migrates HTML files.
o java-files: if specified and set to true (default), migrates Java files.
o jsp-files: if specified and set to true (default), migrates JSP type files.
o archive-files: if specified and set to true (default), migrates jar/ear/war/rar file types.
-a --append-logs if specified, appends the logging to the existing or previous logs without overwriting them. If not specified,
previous logs are overwritten.
operands identifes the archive file (jar/ear/war/rar) to be migrated.
SEE ALSO asupgrade(1M)J2EE 1.4 SDK March 2004 asmigrate(1m)