Sybase IQ 12.4.0 installation instructions Addition to Stop Database statement

Page 19

Adaptive Server IQ 12.4.0

Addition to STOP DATABASE statement

Y

 

 

------------------------------------------------------

 

-

If you type Y (yes), the following message displays:

------------------------------------------------------

-

 

Shutting down asiqsrv12

(server shutdown).

-------------------------------------------------

If you type N, you are returned to the system prompt and IQ does not shut down the server. If no running servers were started by your user ID, Adaptive Server IQ displays information about processes run by other users, as follows:

------------------------------------------------

express@janed> stop_asiq

Checking system for ASIQ 12 Servers ...

There are no ASIQ 12 Servers on this system owned by

’janed’

 

 

 

 

There

were

6 other ASIQ 12 processes(s) found

UID

PID

PPID

C

STIME TTY

TIME CMD

aharring 13870 13869

0 Jun 07 ?

1:20 asiqsrv12

-c 16m -gc

6000 -gd

all -gr 6000 -gm 10 -gp 4096 -ti

4400 -tl 300 asi

 

 

 

teds 16255

5843

0

Jun 07 pts/27

0:03 asiqsrv12 -

gd all -tl

120 -gm 10 -n writer -gp 4096 -x

tcpip{port=6907}

 

 

 

jamesfay 3683

1

0 23:32:14 ?

14:33 asiqsrv12

-gc 6000 -gr 6000 -gm 10 -n express_daily_49765 -c 16M -gp 4096 -gd a

redisch 5486

1

4 10:10:40 pts/6

348:20 asiqsrv12

-c 16m -gc 6000

-gd all -gr 6000 -gm 10 -gp

4096 -ti

4400 -tl 300 -n

 

 

 

 

 

maryc 16800

1

0

Jun 07 ?

30:10

asiqsrv12

@mary.cfg asiqdemo.db -o /express1/users/maryc/12031/asiq12/logfiles/

ambler 26982 1 0 Jun 09 pts/18 13:11 asiqsrv12 @asiqdemo.cfg -N 6

-----------------------------------------------

Be sure to check with users before shutting down their servers.

9.1.11 Addition to STOP DATABASE statement

Release Bulletin for Digital UNIX

19

Image 19
Contents Product summary Release Bulletin Adaptive Server IQ For Digital UnixRequired Operating System Patches Adaptive Server IQ Required Operating System PatchesAdaptive Server IQ Converting 12.0.x databases to RestrictionsRelease Bulletin for Digital Unix Following outer join format is supported Setting the Ldlibrarypath Environment Variable Installation InstructionsDocumentation for this version Go to support.sybase.com Accessing Current Release Bulletin InformationSpecial migration instructions Obtaining query plansChanged functionality in Adaptive Server IQ Changed functionality in this versionImproved stored procedure output Adaptive Server IQ Adaptive Server IQ Stopasiq utility Known problems1 ANY, SOME, and ALL subquery support Temporary tables in proceduresData definition Adaptive Server IQ QueriesChanging length of Dbisql column values Adaptive Server IQ OperationsLarge in subqueries Output to file in DbisqlUser-defined variable issue Adaptive Server IQ User-defined variable issueDbspawn Error when starting a server Unsupported terminal types cause Dbisql errorNotification message setting omitted from Index Properties Problems with Add User-defined Data Type wizardDSE not installed on Windows client systems Add Service utility installed only with Server ComponentsData Type column in Table Editor retains focus Documentation updates and clarificationsProduct compatibilities Startup, shutdown, and connectionSpecifying server switches Additions to the startasiq or asiqsrv12 command-line optionsGm command line option Adaptive Server IQ Gm command line optionGn command-line option Using -v switch on 64-bit platformsConfirming connections Using Odbc connectivity with UnixAdaptive Server IQ Confirming connections Using a .odbc.ini file Adaptive Server IQ Using a .odbc.ini fileStopasiq utility Adaptive Server IQ Addition to Stop Database statement Addition to Stop Database statementDisconnect details omitted Error in Dbstop exampleConfiguration files do not accept quotes Error in Dbstop example Adaptive Server IQChange to Create Database statement Switch must be uppercaseAdaptive Server IQ Switch must be uppercase Data definition DDLIQ database file paths must be unique LowDisk functions as HighGroupColumn Limit Correction Joint Virtual Table JVT definitionAdaptive Server IQ Error documenting IQ Path Error documenting IQ PathError in raw partition limit Error on Create DbspaceAddition to Drop Database statement Size clause of Create DbspaceSize clause of Create Dbspace Adaptive Server IQ Recommended index types Changes to Using join indexesAdaptive Server IQ Recommended index types Id custid idlname Changes to Using join indexes Adaptive Server IQAdaptive Server IQ Changes to Using join indexes Data manipulation DML Error in Diskstriping defaultSupport for joins between stores or databases Adaptive Server IQ DefaultNew and changed general database options Adaptive Server IQ New and changed general database optionsInsertnumberrowsperrawiobuffer Adaptive Server IQ DescriptionDescription Adaptive Server IQ Corrections to Insert LocationAdaptive Server IQ String function Repeat is supported String function Repeat is supportedCorrection to Char function Number* function not supportedNew options for reserving space Backup and system administrationUsing Isnull and Coalesce Using Isnull and Coalesce Adaptive Server IQInsufficient disk space Change to error messageEffect of checkpoints Adaptive Server IQ Forced recovery and leaked space recoveryStorage within the database as in use Dbccoption option Spiqcheckdb Set dbccoption to 2, as a temporary option New Stored Procedure Columns Improved output in stored proceduresSpiqstatus now displays IQ Page Size Minpasswordlength optionTransaction Log utility Maintaining a transaction log or mirror Setting PrefetchBufferLimit option Error message for buffer cache settingsGrant Connect for existing user ID Dropping users may delete tables Documentation on Data Backup and RecoveryCleaning up after abnormal exit Changes to Backup statementMonitoring server activity Help files Using PC client applicationsCreating attribute tables for PowerBuilder Client applicationsAdaptive Server IQ plug-in help reflects Multiplex support Technical SupportSybase Certifications on the Web Other sources of informationTechinfo.sybase.com