Sybase administration GUI

[#1]

Hi guys,

recently ive installed a new ERP 6.0 landscape with Sybase ASE and in both instances i was able to manage the database using the scjview executable, usually located under X:\sybase\SID\Shared\Sybase Central 6.0.0\win64 path.
Now if i try to install the latest Sybase version the executable seems missing, even if the path still exist.

Probably is a SAP choice, i dont understand the meaning (and worse i dont find any note/documentation regarding this change) but im just wondering which is the grapich tool i have to use to manage the database.
I tried to download Sybase Control Center (3.2.5) but im stucked after a few steps (not able to connect the database using sa/sapsa user).
Am i using the correct tool? Is there any other way? Administration is command line only?

Help me.

Thanks.

Regards.

[former_member188065]

There is an official note available on how to get back to Sybase Central. Please read and learn what it teaches regarding restrictions if using scjview compared to the officially recommended tools "SAPgui TA dbacockpit" and "Sybase Control Center" versus Control Center here:

1991153 - Sybase Central Unavailable on ASE 15.7 SP101 how to add it back

Good luck!

[Former Member]

I understand that you want a tool you are used to, to manage installed instances and operate the RDBMS. I guess you are familiar with Sybase Central already and hardly want to miss any of it's powerfull features.

Please navigate here:

Technical Support - Adaptive Server Enterprise - Database Management - Products - Sybase Inc

For a typical up to date SAP installation EBF for the ASE v15 plugin would be EBF21169 for Windows and EBF21167 for Linux (64-Bit)

This can be setup staright away on the server running the RDBMS. If you need to put it on a central management host, make sure to install a limited developer version (free developer edition from SCN with no licensing issues) on that host before you try to install the Sybase Central plugin.

Source:

Changes to Sybase Central

Sybase Central ASE plug-in is no longer included in the Adaptive Server installation image. Use Sybase Control Center 3.2.7 to manage your Adaptive 15.7 ESD#2 servers.
Sybase no longer maintains Sybase Central. However, if required, you can download Sybase Central Plug-ins by going to the http://www.sybase.com/downloads site, then clicking on Maintenance Releases and Bug Fixes (EFBs).

Good luck in finding the download, while it might have vanished meanwhile to "motivate" SAP Basis guys to use dbacokpit or SCC !

I personally hate both for certain limitations and a highly complicated install and setup procedure compared to Sybase Central...

[Former Member]

Maybe this can help you downloading the required files:

[Former Member]

Hello Maurizio

You can install Sybase Control Center from Sybase ASE installation media.

1. Run setup

2. Choose "Custom" Install

3. Select only Sybase Control Center

4. Define your SCC Administrator Password

5. Log on to SCC with user : sccadmin and your defined password.

6. Add resource (Sybase ASE) with user sapsa

Hope it help you.

[former_member184473]

Hello Maurizio,

You can also isql.

e.g.

isql -S<Server> -Usapsa -P<password_sapsa>

Regards,

Eduardo Rezende

[Former Member]

Hi Maurizio,

Sybase control center is the correct tool.

Apart from that for Administration purpose you may configure dbacockpit.

Another alternative is to use command line options available with sybase ase.

Regards,

Deepak Kori

[former_member117942]

Hi Deepak,

thanks for your reply, now i know that i dont wasting my time trying to use SCC.

I configured dbacockpit transaction but i cannot use it if SAP is down, i was looking for a more powerful tool...

About SCC, i've a few questions:

- which is the correct version to use? 3.2.5 is ok?

- im trying to connect my DB (15.0.7.41) using 4901 TCP port, is that correct?

- which is the right user to complete SCC DB Authentication? I tried to use sa and sapsa without any result

- Is there any recent documentation regarding this tool?

Thanks.

Regards.

[Former Member]

Hi Maurizio,

Please verify whether you have downloaded the DVD from the path defined below from SAP site.

Installations and Updates -> Sybase Products -> SYBASE ASE -> SYBASE ASE 15.7 -> Installation -> Sybase Control Center 3.2.x

Also Please refer following links on sybase Control center.

1) how to login to sybase control center

   http://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.infocenter.dc01710.0510/doc/html/tbi13...

2) Info document on Sybase control center

http://infocenter.sybase.com/help/topic/com.sybase.infocenter.dc01264.0310/doc/pdf/scc_framework.pdf

Hope this helps.

Regards,

Deepak Kori

[former_member117942]

Hi Deepak,

we have downloaded SCC and installed.

I've configured the connection to the Sybase ASE with this parameter:

• ASE Host name --> SAP Server hostname
• ASE port --> 4901
• User --> sa (it was unlocked by me)
• Passsword --> sa password

When I try to authenticate SCC, the process sccservice.exe is running with high CPU load and memory process is increasing.

Is there something wrong in SCC configuration ?

Regards.

[Former Member]

Hi Maurizio,

Could you try connecting with these parameters

• ASE Host name --> SAP Server hostname
• ASE port --> 4901
• User --> sapsa
• Passsword --> sapsa password

Also have you tried login with sccadmin as shared in the urls above.

Regards,

Deepak Kori

[former_member117942]

Hi Deepak,

I've tried also sapsa but with no success.

Do you know some configuration that have to be made in SCC or in ASE server for the connection ?

Can ASE Server installed by sapinst be connected to SCC ?

I've attached our ASE Config file.

Regards.

##################################

##############################################################################
#
#  Configuration File for the Sybase SQL Server
#
#  Please read the System Administration Guide (SAG)
#  before changing any of the values in this file.
#
##############################################################################

[Configuration Options]

[General Information]
config file version = DEFAULT

[Backup/Recovery]
recovery interval in minutes = DEFAULT
print recovery information = DEFAULT
tape retention in days = DEFAULT
max concurrently recovered db = DEFAULT
number of checkpoint tasks = DEFAULT
enable backupserver HA = DEFAULT
enforce dump configuration = DEFAULT
enable dump history = 1
dump history filename = DEFAULT

[Cache Manager]
number of oam trips = DEFAULT
number of index trips = DEFAULT
memory alignment boundary = DEFAULT
global async prefetch limit = DEFAULT
global cache partition number = DEFAULT
extended cache size = DEFAULT

[Named Cache:default data cache]
cache size = 400M
cache status = default data cache
cache replacement policy = DEFAULT
local cache partition number = DEFAULT

[Meta-Data Caches]
number of open databases = DEFAULT
number of open objects = 60000
open object spinlock ratio = DEFAULT
number of open indexes = 60000
open index hash spinlock ratio = DEFAULT
open index spinlock ratio = DEFAULT
partition groups = DEFAULT
partition spinlock ratio = DEFAULT
number of open partitions = 50000

[Disk I/O]
disk i/o structures = 2048
number of large i/o buffers = DEFAULT
page utilization percent = DEFAULT
number of devices = 200
disable disk mirroring = DEFAULT
allow sql server async i/o = DEFAULT
number of disk tasks = DEFAULT
enable hp posix async i/o = DEFAULT

[Languages]
disable character set conversions = DEFAULT

[Unicode]
enable unicode normalization = 0
enable surrogate processing = 0
enable unicode conversions = DEFAULT
size of unilib cache = DEFAULT
dynamic SQL plan pinning = DEFAULT

[Network Communication]
default network packet size = 16384
max network packet size = 16384
remote server pre-read packets = DEFAULT
number of remote connections = DEFAULT
number of remote logins = DEFAULT
number of remote sites = DEFAULT
max number network listeners = DEFAULT
tcp no delay = DEFAULT
send doneinproc tokens = DEFAULT
allow sendmsg = DEFAULT
syb_sendmsg port number = DEFAULT
allow remote access = DEFAULT
number of network tasks = DEFAULT
network polling mode = DEFAULT
number of early send rows = DEFAULT
early row send increment = DEFAULT

[O/S Resources]
max async i/os per engine = DEFAULT
max async i/os per server = DEFAULT

[Query Tuning]
optimization goal = DEFAULT
allow backward scans = DEFAULT
abstract plan load = DEFAULT
abstract plan dump = DEFAULT
abstract plan replace = DEFAULT
abstract plan cache = DEFAULT
sampling percent = DEFAULT
number of histogram steps = DEFAULT
enable sort-merge join and JTC = DEFAULT
number of worker processes = DEFAULT
memory per worker process = DEFAULT
max parallel degree = DEFAULT
max scan parallel degree = DEFAULT
max repartition degree = DEFAULT
max resource granularity = DEFAULT
enable metrics capture = DEFAULT
optimization timeout limit = DEFAULT
metrics lio max = DEFAULT
metrics pio max = DEFAULT
metrics elap max = DEFAULT
metrics exec max = DEFAULT
sproc optimize timeout limit = DEFAULT
min pages for parallel scan = DEFAULT
prod-consumer overlap factor = DEFAULT
enable literal autoparam = DEFAULT
max query parallel degree = DEFAULT
cost of a logical io = DEFAULT
cost of a physical io = DEFAULT
cost of a cpu unit = DEFAULT
auto query tuning = DEFAULT
enable query tuning mem limit = DEFAULT
query tuning plan executions = DEFAULT
enable query tuning time limit = DEFAULT
max buffers per lava operator = DEFAULT
enable merge join = DEFAULT
mnc_full_index_filter = DEFAULT
capture missing statistics = DEFAULT
enable compatibility mode = DEFAULT
procedure deferred compilation = DEFAULT
optimizer level = ase_current
search engine timeout factor = DEFAULT
deferred name resolution = DEFAULT
update statistics hashing = DEFAULT
builtin date strings = DEFAULT
enable deferred parallel = DEFAULT

[Physical Resources]

[Physical Memory]
max memory = 1792000
additional network memory = 10485760
shared memory starting address = DEFAULT
allocate max shared memory = DEFAULT
dynamic allocation on demand = DEFAULT
lock shared memory = DEFAULT
heap memory per user = 49152
engine memory log size = DEFAULT
compression memory size = DEFAULT
kernel resource memory = 32768

[Processors]
max online engines = 16
max online Q engines = DEFAULT
number of engines at startup = DEFAULT
number of Q engines at startup = DEFAULT
statement cache size = 51200

[SQL Server Administration]
procedure cache size = 262144
default database size = DEFAULT
identity burning set factor = DEFAULT
allow nested triggers = DEFAULT
allow updates to system tables = DEFAULT
default fill factor percent = DEFAULT
default exp_row_size percent = DEFAULT
number of mailboxes = DEFAULT
number of messages = DEFAULT
number of alarms = 1000
number of pre-allocated extents = DEFAULT
event buffers per engine = DEFAULT
cpu accounting flush interval = DEFAULT
i/o accounting flush interval = DEFAULT
sql server clock tick length = DEFAULT
runnable process search count = DEFAULT
i/o polling process count = DEFAULT
time slice = DEFAULT
cpu grace time = 1000
number of sort buffers = DEFAULT
size of auto identity column = DEFAULT
identity grab size = DEFAULT
housekeeper free write percent = DEFAULT
enable housekeeper GC = DEFAULT
sysstatistics flush interval = DEFAULT
allow resource limits = DEFAULT
number of aux scan descriptors = 1024
SQL Perfmon Integration = DEFAULT
license information = DEFAULT
text prefetch size = DEFAULT
enable HA = DEFAULT
i/o batch size = DEFAULT
enable semantic partitioning = 1
enable compression = 1
compression info pool size = 32768
capture compression statistics = DEFAULT
enable xml = 1
enable webservices = DEFAULT
enable job scheduler = 1
job scheduler tasks = DEFAULT
job scheduler interval = DEFAULT
js job output width = DEFAULT
percent database for history = DEFAULT
percent history free = DEFAULT
percent database for output = DEFAULT
percent output free = DEFAULT
maximum job output = 2147483647
enable sql debugger = DEFAULT
identity reservation size = DEFAULT
kernel mode = DEFAULT
max transfer history = DEFAULT
disable varbinary truncation = 1
enable console logging = DEFAULT
enable async database init = DEFAULT
aggressive task stealing = DEFAULT

[User Environment]
number of user connections = 200
stack size = 151552
stack guard size = 4096
permission cache entries = DEFAULT
user log cache size = DEFAULT
user log cache spinlock ratio = DEFAULT
session tempdb log cache size = DEFAULT
max nesting level = DEFAULT
number of backup connections = DEFAULT
enable pci = DEFAULT
max pci slots = DEFAULT
pci memory size = DEFAULT
transfer utility memory size = DEFAULT
column default cache size = DEFAULT
replication agent memory size = DEFAULT
max native threads per engine = DEFAULT
messaging memory = DEFAULT
enable real time messaging = DEFAULT
histogram tuning factor = DEFAULT
rtm thread idle wait period = DEFAULT

[Lock Manager]
number of locks = 5000000
deadlock checking period = DEFAULT
lock spinlock ratio = DEFAULT
lock address spinlock ratio = DEFAULT
lock table spinlock ratio = DEFAULT
lock hashtable size = 8192
cluster redundancy level = DEFAULT
lock scheme = datarows
lock wait period = 1800
read committed with lock = DEFAULT
print deadlock information = DEFAULT
deadlock retries = DEFAULT
page lock promotion HWM = DEFAULT
page lock promotion LWM = DEFAULT
page lock promotion PCT = DEFAULT
row lock promotion HWM = 2147483647
row lock promotion LWM = 2147483647
row lock promotion PCT = DEFAULT

[Security Related]
systemwide password expiration = DEFAULT
audit queue size = DEFAULT
curread change w/ open cursors = DEFAULT
allow procedure grouping = DEFAULT
select on syscomments.text = DEFAULT
auditing = DEFAULT
current audit table = DEFAULT
suspend audit when device full = DEFAULT
enable row level access = DEFAULT
check password for digit = DEFAULT
minimum password length = DEFAULT
maximum failed logins = DEFAULT
enable ssl = DEFAULT
FIPS login password encryption = 1
enable predicated privileges = DEFAULT
enable granular permissions = DEFAULT
restricted decrypt permission = DEFAULT
net password encryption reqd = DEFAULT
automatic master key access = DEFAULT
unified login required = DEFAULT
use security services = DEFAULT
msg confidentiality reqd = DEFAULT
msg integrity reqd = DEFAULT
enable pam user auth = DEFAULT
enable ldap user auth = DEFAULT
enable encrypted columns = DEFAULT
secure default login = DEFAULT
enable logins during recovery = DEFAULT

[Extended Stored Procedure]
esp unload dll = DEFAULT
esp execution priority = DEFAULT
esp execution stacksize = DEFAULT
xp_cmdshell context = DEFAULT
start mail session = DEFAULT
start xp server during boot = DEFAULT

[Error Log]
event logging = DEFAULT
log audit logon success = DEFAULT
log audit logon failure = DEFAULT
event log computer name = DEFAULT

[Rep Agent Thread Administration]
enable rep agent threads = DEFAULT

[Component Integration Services]
enable cis = DEFAULT
cis connect timeout = DEFAULT
cis bulk insert batch size = DEFAULT
max cis remote connections = DEFAULT
cis idle connection timeout = DEFAULT
cis packet size = DEFAULT
cis cursor rows = DEFAULT
enable snmp = DEFAULT
enable file access = DEFAULT
cis bulk insert array size = DEFAULT
enable full-text search = DEFAULT
cis rpc handling = DEFAULT

[Java Services]
enable java = DEFAULT
size of process object heap = DEFAULT
size of shared class heap = DEFAULT
size of global fixed heap = DEFAULT
number of java sockets = DEFAULT

[DTM Administration]
enable DTM = DEFAULT
enable xact coordination = DEFAULT
xact coordination interval = DEFAULT
number of dtx participants = DEFAULT
strict dtm enforcement = DEFAULT
txn to pss ratio = DEFAULT
dtm lock timeout period = DEFAULT
dtm detach timeout period = DEFAULT

[Diagnostics]
dump on conditions = DEFAULT
maximum dump conditions = DEFAULT
number of dump threads = DEFAULT
memory dump compression level = DEFAULT
number of ccbs = DEFAULT
caps per ccb = DEFAULT
average cap size = DEFAULT

[Monitoring]
enable monitoring = 1
sql text pipe active = DEFAULT
sql text pipe max messages = DEFAULT
plan text pipe active = DEFAULT
plan text pipe max messages = DEFAULT
statement pipe active = DEFAULT
statement pipe max messages = DEFAULT
errorlog pipe active = 1
errorlog pipe max messages = 500
deadlock pipe active = 1
deadlock pipe max messages = 500
lock timeout pipe max messages = 500
lock timeout pipe active = 1
wait event timing = 1
process wait events = DEFAULT
object lockwait timing = 1
SQL batch capture = 1
statement statistics active = 1
per object statistics active = 1
max SQL text monitored = 2048
performance monitoring option = DEFAULT
enable stmt cache monitoring = 1
enable spinlock monitoring = DEFAULT

[Shared Disk Cluster]
CIPC regular message pool size = DEFAULT
CIPC large message pool size = DEFAULT
DMA object pool size = DEFAULT
workload manager cache size = DEFAULT
idle migration timeout = DEFAULT
session migration timeout = DEFAULT
automatic cluster takeover = DEFAULT
quorum heartbeat interval = DEFAULT
quorum heartbeat retries = DEFAULT
cluster heartbeat interval = DEFAULT
cluster heartbeat retries = DEFAULT
cluster vote timeout = DEFAULT
enable i/o fencing = DEFAULT

[Dump Configuration:NSADB]
stripe directory = \\192.168.60.19\ehp4-backup\SYBASE_NSA
external api name = DEFAULT
number of stripes = DEFAULT
number of retries = DEFAULT
block size = DEFAULT
compression level = 101
retain days = DEFAULT
init = DEFAULT
verify = header
notify = DEFAULT
remote backup server name = DEFAULT

[Dump Configuration:NSALOG]
stripe directory = \\192.168.60.19\ehp4-backup\SYBASE_NSA
external api name = DEFAULT
number of stripes = DEFAULT
number of retries = DEFAULT
block size = DEFAULT
compression level = 101
retain days = DEFAULT
init = DEFAULT
verify = header
notify = DEFAULT
remote backup server name = DEFAULT

[Application Functionality]
enable functionality group = 1
select for update = DEFAULT
streamlined dynamic SQL = DEFAULT
enable inline default sharing = DEFAULT
enable permissive unicode = DEFAULT
quoted identifier enhancements = DEFAULT
suppress js max task message = DEFAULT
enable concurrent dump tran = DEFAULT
enable plan sharing = 0

[Thread Pool:syb_blocking_pool]
number of threads = 4

[Thread Pool:syb_default_pool]
number of threads = 3
idle timeout = 100

#################################

[former_member184473]

Hello Maurizio,

Are you able to login with isql?

Regards,

Eduardo

[Former Member]

Hi Maurizo,

Above parameters could not provide inputs for login

Could you try this method

http://<scc-hostname>:8282/scc

username: sccadmin

password: < Specified during installation of Sybase Centrol control>

Hope this helps.

Regards,

Deepak Kori

[former_member117942]

Hi,

I would like to be more clear in my question.

I've installed a SAP System (Netweaver 7.31) based on windows /Sybase ASE (last version of DVD installation available in SAP Market Place).

One year ago in the installation of ASE made by sapinst there was a graphical tool (scjview) not available in the last installation DVD.

It seems SCC (Sybase control center) was the universal product to manage Sybase database (ASE, IQ, etc).

I've downloaded and installed successfully this software from market place (SCC version for ASE server).

After connection with user "sccadmin" and "blank password" with success, I've had to register the connection to the ASE database of my SAP Netweaver.

Have you tried this type of graphic console ?

Why ASE parameters indicated above are not working ?

DBACockpit from SAP work well and also ISQL from command; I've only understand if it is possible to use a graphical tool to manage my ASE db.

Thanks.

  Maurizio