8 More Discussions You Might Find Interesting
1. Programming
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)
Discussion started by: Perlbaby
0 Replies
2. Programming
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)
Discussion started by: Perlbaby
1 Replies
3. Programming
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)
Discussion started by: Perlbaby
2 Replies
4. Programming
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)
Discussion started by: Perlbaby
3 Replies
5. Programming
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)
Discussion started by: Perlbaby
3 Replies
6. Tips and Tutorials
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)
Discussion started by: bakunin
1 Replies
7. UNIX and Linux Applications
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)
Discussion started by: sam_salazar
0 Replies
8. SCO
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)
Discussion started by: forumuser7
0 Replies
dr(7d) Devices dr(7d)
NAME
dr, drmach, ngdr, ngdrmach - Sun Enterprise 10000 dynamic reconfiguration driver
SYNOPSIS
dr
drmach
ngdr
ngdrmach
DESCRIPTION
The dynamic reconfiguration (DR) driver consists of a platform-independent driver and a platform-specific module. The DR driver uses stan-
dard features of the Solaris operating environment whenever possible to control DR operations and calls the platform specific module as
needed. The DR driver creates minor nodes in the file system that serve as attachment points for DR operations.
The DR driver provides a pseudo-driver interface to sequence attach and detach operations on system boards using file system entry points
referred to as "attachment points." The attachment point form depends on the platform.
Sun Enterprise 10000 Server
On the Sun Enterprise 10000 server, the DR driver consists of a platform-independent driver (ngdr) and a platform-specific module (ngdr-
mach).
The domain configuration server (DCS) accepts DR requests from the system services processor (SSP) and uses the libcfgadm(3LIB) interface
to initiate the DR operation. After the operation is performed, the results are returned to the SSP. For more information about the DCS on
the Sun Enterprise 10000, refer to the dcs(1M) man page and the Sun Enterprise 10000 Dynamic Reconfiguration User Guide.
The DR driver creates physical attachment points for system board slots that takes the following form:
/devices/pseudo/ngdr@0:SBx
Where x represents the slot number (0 to 15) for a particular board.
The cfgadm_sbd(1M) plugin creates dynamic attachment points that refer to components on system boards, including CPUs, memory, or I/O
devices. Refer to the cfgadm_sbd(1M) man page for more details.
SEE ALSO
cfgadm_sbd(1M), ioctl(2), libcfgadm(3LIB)
Sun Enterprise 10000 Dynamic Reconfiguration User Guide
SunOS 5.10 29 Sep 2003 dr(7d)