Utilities

This section provides the syntax and brief descriptions for Adaptive Server utilities. See Utility Guide for more information.

backupserver

The executable form of the Backup Server program.

backupserver
	[-C server_connections]
	[-S b_servername]
	[-I interfaces_file]
	[-e error_log_file]
	[-M sybmultbuf_binary]
	[-N network_connections]
	[-T trace_value]
	[-L Sybase_language_name]
	[-J Sybase_character_set_name]
	[-c tape_config_file]
	[-D n]
	[-A pathname]
	[-P active_service_threads]
	[-V level_number]
	[-p n]
	[-m max_shared_memory]

backupserver -v

bcp

Copies a database table to or from an operating system file in a user-specified format.

bcp [[database_name.]owner.]table_name [: [ partition_id | slice_number ] |
	partition partition_name] {in | out} datafile
	[--show-fi]
	[--hide-vcc]
	[-f formatfile]
	[-e errfile] 
	[-F firstrow]
	[-L lastrow]
	[-b batchsize]
	[-m maxerrors]
	[-n]
	[-c]
	[-t field_terminator]
	[-r row_terminator]
	[-U username]
	[-P password]
	[-I interfaces_file]
	[-S server]
	[-a display_charset]
	[-z language]
	[-A packet_size]
	[-J client_charset]
	[-T text_or_image_size]
	[-E]
	[-g id_start_value]
	[-N]
	[-X]
	[-K keytab_file]
	[-R remote_server_principal]
	[-V [security_options]]
	[-Z security_mechanism]
	[-Q]
	[-Y]
	[--maxconn maximum_connections 

bcp -v

buildmaster

Adaptive Server no longer uses buildmaster.

certauth

Converts a server certificate request to a CA- (certificate authority) signed certificate.

certauth
	[-r]
	[-C caCert_file]
	[-Q request_filename]
	[-K caKey_filename]
	[-N serial_number
	[-O SignedCert_filename]
	[-P caPassword]
	[-s start_time]
	[-T valid_time]

certauth -v

certpk12

Export or import a PKCS #12 file into a certificates file and a private key.

certpk12
	{-O Pkcs12_file | -I Pkcs12_file}
	[-C Cert_file]
	[-K Key_file]
	[-P key_password]
	[-E Pkcs12_password]

certpk12 -v

certreq

Creates a server certificate request and corresponding private key.

certreq
	[-F input_file]
	[-R request_filename]
	[-K PK_filename]
	[-P password]

certreq -v

charset

UNIX platforms only – loads the character sets and sort order files in Adaptive Server.

charset
	[-Ppassword]
	[-Sserver]
	[-Iinterface]
	sort_order
	[ charset ]

charset -v

cobpre

Precompiler for COBOL. See Appendix A of the Open Client and Open Server Programmer’s Supplement.

cpre

Precompiler for C. See Appendix A of the Open Client and Open Server Programmer’s Supplement.

dataserver

UNIX platforms only – the executable form of the Adaptive Server program.

dataserver [-f] [-g] [-G] [-h] [-H] [-m] [-q] [-v] [-X]
	[-a path_to_CAPs_directive_file]
	-b master_device_size [k | K | m | M | g | G | t | T ]
	[-c config_file_for_server]
	[-d device_name]
	[-e path_to_error_log]
	[-i interfaces_file_directory]
	[-K keytab_file]
	[-L config_file_name_for_connectivity]
	[-M shared_memory_repository_directory]
	[-N licinstant
	[-n sa_login_name]
	[-p sa_login_name]
	[-r mirror_disk_name]
	[-s server_name]
	[-T trace_flag]
	[-u sa/sso_name]
	[-w master | model database]
	[-y [password] ]
	[-z page_size [ k | K ] ]

dataserver -v

ddlgen

A Java-based tool that generates definitions for server- and database-level objects in Adaptive Server.

ddlgen 
	-Ulogin
	-Ppassword
	-S[server | host_name : port_number]
	[-I interfaces_file]
	[-Tobject_type]
	[-Nobject_name]
	[-Ddbname]
	[-Xextended_object_type]
	[-Ooutput_file]
	[-Eerror_file]
	[-Lprogress_log_file]
	[-Jclient_charset]
	-F[ % | SGM | GRP | USR | R | D | UDD | U | V | 
		P | XP | I | RI | KC | TR | PC ]

ddlgen -v

defncopy

Copies definitions for specified views, rules, defaults, triggers, or procedures from a database to an operating-system file or from an operating-system file to a database.

defncopy
	[-X]
	[-a display_charset]
	[-I interfaces_file]
	[-J [client_charset]]
	[-K keytab_file]
	[-P password]
	[-R remote_server_principal]
	[-S [server_name]]
	[-U username]
	[-V security_options]
	[-Z security_mechanism]
	[-z language]
	{ in file_name database_name | 
		out file_name database_name [owner.]object_name
		 [[owner.]object_name...] }

defncopy -v

dscp

UNIX platforms only – allows you to view and edit server entries in the interfaces file from the command line in UNIX platforms.

dscp [-p]

dscp -v

dsedit

UNIX platforms– the dsedit utility allows you to view and edit server entries in the interfaces file using a GUI based on X11/Motif in UNIX platforms.

dsedit

dsedit -v

extractjava

Copies a retained JAR and the classes it contains from an Adaptive Server into a client file.

extractjava (extrjava in Windows)
	-j jar_name
	-f file_name
	[-S server_name]
	[-U user_name]
	[-P password]
	[-D database_name]
	[-I interfaces_file]
	[-a display_charset]
	[-J client_charset]
	[-z language]
	[-t timeout]
	[-v]

extractjava -v

installjava

Installs a JAR from a client file into an Adaptive Server.

installjava
	-f file_name
	[ -new | -update ]
	[ -j jar_name ]
	[ -S server_name ]
	[ -U user_name ]
	[ -P password ]
	[ -D database_name ]
	[ -I interfaces_file ]
	[ -a display_charset ]
	[ -J client_charset ]
	[ -z language ]
	[ -t timeout ]
	[-v]

installjava -v

isql

Interactive SQL parser to Adaptive Server.

isql [-b] [-e] [-F] [-p] [-n] [-v] [-X] [-Y] [-Q]
	[-a display_charset]
	[-A packet_size]
	[-c cmdend]
	[-D database]
	[-E editor]
	[-h header]
	[-H hostname]
	[-i inputfile]
	[-I interfaces_file]
	[-J client_charset]
	[-K keytab_file]
	[-l login_timeout]
	[-m errorlevel]
	[-o outputfile]
	[-P password]
	[-R remote_server_principal]
	[-s colseparator]
	[-S server_name]
	[-t timeout]
	-U username
	[-V [security_options]]
	[-w columnwidth]
	[-z locale_name]
	[-Z security_mechanism]

langinstall

Installs a new language in an Adaptive Server.

langinstall
	[-S server]
	[-U user]
	[-P password]
	[-R release_number]
	[-I path]
	language
	character_set

langinstall -v

optdiag

Displays optimizer statistics or loads updated statistics into system tables.

optdiag [binary] [simulate] statistics
	{ -i input_file |
		database[.owner[.[table[.column] ] ] ] [-o output_file] }
	[-U user_name]
	[-P password]
	[-T trace_value]
	[-I interfaces_file]
	[-S server]
	[-v]
	[-h]
	[-s]
	[-z language]
	[-J client_character_set]
	[-a display_charset]

preupgrade

Performs tests on an installation or database to determine its readiness for upgrade, and reports found problems.

preupgrade [-v] [-h] [-N]
	[-D database_name]
	[-I interfaces_file]
	[-P password]
	[-S server_name]
	[-U user_name]
	[-X option[,option]...]

pwdcrypt

Creates and prints an encrypted LDAP password in the libtcl.cfg file.

pwdcrypt

showserver

UNIX platforms only – shows the Adaptive Servers and Backup Servers that are currently running on the local machine, available only in UNIX platforms.

showserver

sqldbgr

sqldbgr is a command-line utility that debugs stored procedures and triggers.

sqldbgr
	-U username
	-P password
	-S host:port

sqlloc

UNIX platforms only – installs and modifies languages, character sets, and sort order defaults for Adaptive Server using a GUI based on X11/Motif.

sqlloc
	[-S Server]
	[-U User]
	[-P Password]
	[-s Sybase Dir]
	[-I Interfaces file]
	[-r Resource file]

sqlloc -v

sqllocres

UNIX platforms only– installs and modifies languages, character sets, and sort order defaults for Adaptive Server, using a resource file.

sqllocres
	[-S Server]
	[-U User]
	[-P Password]
	[-s Sybase Dir]
	[-I Interfaces file]
	[-r Resource file]

sqllocres -v

sqlsrvr

Windows platforms only – is the executable form of the Adaptive Server program.

sqlserver [-f] [-g] [-G] [-h] [-H] [-m] [-P] [-q] [-v] [-X]
	[-a path_to_CAPs_directive_file]
	[-b master_device_size] [k | K | m | M | g | G | t | T ]
	[-c config_file_for_server]
	[-d device_name]
	[-e path_to_error_log]
	[-i interfaces_file_directory]
	[-K keytab_file]
	[-L config_file_name_for_connectivity]
	[-M shared_memory_repository_directory]
	[-p sa_login_name]
	[-r mirror_disk_name]
	[-s server_name]
	[-T trace_flag]
	[-u sa/sso_name]
	[-w master | model database]
	[-y [password] ]
	[-z page_size [ k | K ] ]

sqlupgrade

UNIX platforms only – upgrades your currently installed version of Adaptive Server to the newest release using a GUI based on X11/Motif.

sqlupgrade
	[-s Sybase Dir]
	[-r Resource File]

sqlupgrade -v

sqlupgraderes

UNIX platforms only – upgrades your currently installed release of Adaptive Server to the newest release using resource files.

sqlupgraderes
	[-s Sybase Dir]
	[-r Resource File]

sqlupgraderes -v

srvbuild

UNIX platforms only – creates a new Adaptive Server, Backup Server, Monitor Server, or XP Server with default or user-specified values for key configuration attributes.

srvbuild
	[-s sybase_dir]
	[-I interfaces_file]
	[-r resource_file]

srvbuild -v

srvbuildres

UNIX platforms only – creates, using resource files, a new Adaptive Server, Backup Server, Monitor Server, or XP Server with default or user-specified values for key configuration attributes.

srvbuildres
	[-s sybase_dir]
	[-I interfaces_file]
	[-r resource_file]

srvbuildres -v

startserver

UNIX platforms only – starts an Adaptive Server or a Backup Server.

startserver [[-f runserverfile] [-m]] ...

sybmigrate

Allows you to convert an Adaptive Server from one page size to another page size, and migrate between platforms.

sybmigrate [-v ] [-h ] [-f ]
	[-D 1 | 2 | 3 | 4 ]
	[-I interfaces file ]
	[-r input resource file ]
	[-m setup | migrate | validate | report ]
	[-rn status | space_est | repl | diff | password ]
	[-l log file ]
	[-t output template resource file ]
	[-J client_charset ]
	[-z language ]
	[-T trace_flags ]
	[-Tase trace flags ]
	[-f ]

xpserver

Starts XP Server manually.

xpserver
 -SXP_Server
	[-Iinterfaces_file]
	[-ppriority]
	[-sstack_size]
	[-u]
	[-v]
	[-x]

View this book as PDF