Page tree
Skip to end of metadata
Go to start of metadata

engine

Brings engine online or offline, called by sp_engine

Syntax

dbcc engine(eng_command[,action [,param1][,param2]]])

OptionDescription
eng_commandCommand Options

CommandInfo

onlinebring an engine online

offlineTake an engine offline

can_offlinefigure out if an engine can be offlined

shutdownshuts down an engine forcefully

netNetwork command


net options


CommandInfo


showdisplay all tasks that are currently network affiniated to the engine


showalldisplay all tasks that are currently network affinitied to each engine(group by engines)


netenginedisplay the engine number of the current task network affiniated to
param1Engine number used by show

Example

Bring up engine online

1> dbcc traceon(3604)
2> go
DBCC execution completed. If DBCC printed error messages, contact a user with System Administrator (SA) role.
1> dbcc engine("online")
2> go
02:00000:00000:2009/02/23 08:31:28.68 kernel Network and device connection limi t is 3027.
02:00000:00000:2009/02/23 08:31:28.75 kernel engine 2, os pid 22604 online
02:00000:00000:2009/02/23 08:31:28.76 kernel Warning: Cannot resolve LDAP funct ion ldap_search_ext_s.
02:00000:00000:2009/02/23 08:31:28.77 kernel Encryption provider initialization

 succeeded on engine 2.

Query sysengines before taking engine offline

1> select engine,status from sysengines
2> go
engine status
------ ------------
0 online
1 online
2 online
offline Engine 2

1> dbcc engine("offline", 2)
2> go
00:00000:00011:2009/02/23 08:39:13.67 kernel Listener with protocol tcp, host somehost.sybase.com, port 9099, engine 2 stopped.
1> 00:00000:00000:2009/02/23 08:39:13.67 kernel engine 2, os pid 22604 offline

2> select engine, status from sysengines
3> go
engine status
------ ------------
0 online
1 online

(2 rows affected)

Check tasks affiniated to engine 0

1> dbcc engine(net,show,0)
2> go

Multi Engine Network Listener is enabled.

Tasks that are network affinitied to Engine 0:
kpid vsn psn status
---- --- --- -------------

        1441814    2      27    running(engine 0) setdataok

Total number of tasks that are currently network affinited to engine 0 is 1

Check the task affiniated to each active engine

1> dbcc engine (net,showall)
2> go

Multi Engine Network Listener is enabled.

Tasks that are network affinitied to Engine 0:
kpid vsn psn status
---- --- --- -------------

        1441814    2      27    running(engine 0) setdataok

Total number of tasks that are currently network affinited to engine 0 is 1

Tasks that are network affinitied to Engine 1:
kpid vsn psn status
---- --- --- -------------

Total number of tasks that are currently network affinited to engine 1 is 0

Tasks that are network affinitied to Engine 2:
kpid vsn psn status
---- --- --- -------------
Total number of tasks that are currently network affinited to engine 2 is 0

Show the network engine number of the current task

1> dbcc engine(net,netengine)
2> go
network engine
--------------
0

Disable and then enable engine affinity migration(is only applicable when server is running under 7822,1605,1608 traceflag)

1> select engine, status from sysengines
2> go
engine status
------ ------------
0 online
1 online
2 online

(3 rows affected)
1> dbcc engine("shutdown", 2)
2> go
00:00000:00000:2009/02/23 09:07:41.01 kernel engine 2, os pid 23882 offline
1> select engine, status from sysengines
2> go
engine status
------ ------------
0 online
1 online

  • No labels