UJP - 技術情報

Life is fun and easy!

不正IP報告数

Okan Sensor
 
メイン
ログイン
ブログ カテゴリ一覧

     

EBF10032を適用する 〜Linux版 ASE11.9.2を11.9.2.6にする〜

EBF10032を適用する

〜Linux版 ASE11.9.2〜


0.更新履歴

  • 2002.04.16 新規作成

1.はじめに

 このドキュメントでは,Linux版のSybase ASE11.9.2開発版に,EBF10032を適用して,ASE11.9.2.6にする手順を示す.

2.モジュールの入手

  • SybaseのEBF(パッチ)は,http://www.sybase.com/で入手する.
  • なお,MySybaseユーザ登録(無料)を行う必要がある.

3.適用前作業

  • 現在のASEのバージョンを確認する.

bash$ isql -Usa -P -Spoweredge
Msg 2401, Level 11, State 2:
Character set conversion is not available between client character set 'iso_1'
and server character set 'sjis'.
No conversions will be done.
1> select @@version
2> go

        ------------------------------------------------------------------------
------------------------
--------------------------------------------------------------------------------
------------------------
-------------------------------------------------------
         Adaptive Server Enterprise/11.9.2/1075/P/Linux Intel/Linux 2.2.5 i586/O
PT/Mon Jul 12 09:51:46 1999

(1 row affected)
1>

  • ASEをシャットダウンする.

bash$ isql -Usa -P -Spoweredge
Msg 2401, Level 11, State 2:
Line 1:
Character set conversion is not available between client character set 'iso_1'
and server character set 'sjis'.
No conversions will be done.
1> shutdown SYB_BACKUP
2> go
Backup Server: 3.48.1.1: The Backup Server will go down immediately.
Terminating sessions.
1> shutdown
2> go
Server SHUTDOWN by request.
The SQL Server is terminating this process.
CT-LIBRARY error:
        ct_results(): network packet layer: internal net library error: Net-Library 
operation terminated due to disconnect
CT-LIBRARY error:
        ct_cancel(): network packet layer: internal net library error: Net-Lib prot
ocol driver call to read data failed
bash$ showserver
USER       PID %CPU %MEM   VSZ  RSS TTY      STAT START   TIME COMMAND
bash$

4.適用作業 ファイルの展開

  • 作業用のディレクトリを作成しておく.

bash$ mkdir EBF
bash$ cd EBF
bash$ pwd
/opt/sybase-11.9.2/EBF
bash$

  • そこにダウンロードしたファイルを入れる.
  • ファイルは以下のとおりとなる.

bash$ ls -la
total 31308
drwxrwxr-x    2 sybase   sybase       4096 Apr 16 12:16 .
drwxrwxr-x   22 sybase   sybase       4096 Apr 16 12:15 ..
-rw-rw-r--    1 sybase   sybase     236320 Apr 16 12:16 EBF10032.ltr
-rw-rw-r--    1 sybase   sybase   31772387 Apr 16 12:16 EBF10032.tgz
bash$

  • アーカイブを展開して,中身を確認する.

bash$ gzip -d EBF10032.tgz
bash$ tar xvf EBF10032.tar
ebf10032/
ebf10032/Cover.ROLL.10032
ebf10032/RPMS/
ebf10032/RPMS/sybase-SWR-10032-1.i386.rpm
bash$ ls -la
total 31496
drwxrwxr-x    3 sybase   sybase       4096 Apr 16 12:30 .
drwxrwxr-x   22 sybase   sybase       4096 Apr 16 12:15 ..
-rw-rw-r--    1 sybase   sybase     236320 Apr 16 12:16 EBF10032.ltr
-rw-rw-r--    1 sybase   sybase   31959040 Apr 16 12:16 EBF10032.tar
drwxrwxr-x    3 sybase   sybase       4096 Apr  3 08:44 ebf10032
bash$ cd ebf10032
bash$ ls -la
total 248
drwxrwxr-x    3 sybase   sybase       4096 Apr  3 08:44 .
drwxrwxr-x    3 sybase   sybase       4096 Apr 16 12:30 ..
-rwxr-xr-x    1 sybase   sybase     236320 Mar 28 11:18 Cover.ROLL.10032
drwxr-xr-x    2 sybase   sybase       4096 Apr  3 08:45 RPMS
bash$ cd RPMS
bash$ ls -la
total 31016
drwxr-xr-x    2 sybase   sybase       4096 Apr  3 08:45 .
drwxrwxr-x    3 sybase   sybase       4096 Apr  3 08:44 ..
-rwxr-xr-x    1 sybase   sybase   31714513 Apr  3 01:18 sybase-SWR-10032-1.i386.rpm
bash$

  • rootユーザにSwitchUserして,rpmを適用する.

bash$ su
Password:■■■■■■
[root@poweredge RPMS]# ls
sybase-SWR-10032-1.i386.rpm
[root@poweredge RPMS]# rpm -ihv sybase-SWR-10032-1.i386.rpm
sybase-SWR                  ##################################################
[root@poweredge RPMS]#

  • 追加されたパッケージがなんなのか,確認する.

[root@poweredge RPMS]# rpm -qa | grep sybase
sybase-common-11.9.2-1
sybase-japanese-11.9.2-1
sybase-openclient-11.1.1-1
sybase-ase-11.9.2-1
sybase-SWR-10032-1
[root@poweredge RPMS]#

  • パッケージがどのようなファイルで構成されているか確認する.

[root@poweredge RPMS]# rpm -ql sybase-SWR-10032-1
/opt/sybase-11.9.2
/opt/sybase-11.9.2/SWR
/opt/sybase-11.9.2/SWR/SWR-10032.tar.gz
[root@poweredge RPMS]#

  • RPMなのにgzファイルを置くだけなのか!

[root@poweredge RPMS]# cd /opt/sybase-11.9.2/
[root@poweredge sybase-11.9.2]# ls -la *.gz
-r--r--r--    1 root     root     31904784 Apr 16 13:51 SWR-10032.tar.gz
[root@poweredge sybase-11.9.2]#

  • rootユーザでgzファイルが出来てしまってるよ.
  • アーカイブファイルを展開する.

[root@poweredge sybase-11.9.2]# gzip -d SWR-10032.tar.gz
[root@poweredge sybase-11.9.2]# tar xvf SWR-10032.tar
./
bin/
bin/sqlloc
bin/sqllocres
bin/backupserver
bin/monserver
bin/histserver
bin/dataserver
bin/diagbs
bin/diagserver
bin/diagsmb
bin/diagxps
bin/optdiag
bin/sqlupgrade
bin/sqlupgraderes
bin/srvbuild
bin/srvbuildres
bin/sybmultbuf
bin/xpserver
charsets/
charsets/iso15/
charsets/iso15/binary.srt
charsets/iso15/charset.loc
charsets/iso15/iso15.cfg
charsets/iso15/utf8.ctb
charsets/iso15/dictionary.srt
charsets/iso15/espdict.srt
charsets/iso15/espnoac.srt
charsets/iso15/espnocs.srt
charsets/iso15/noaccents.srt
charsets/iso15/nocase.srt
charsets/iso15/nocasepref.srt
charsets/roman9/
charsets/roman9/binary.srt
charsets/roman9/charset.loc
charsets/roman9/dictionary.srt
charsets/roman9/espdict.srt
charsets/roman9/espnoac.srt
charsets/roman9/espnocs.srt
charsets/roman9/noaccents.srt
charsets/roman9/nocase.srt
charsets/roman9/nocasepref.srt
charsets/roman9/roman9.cfg
charsets/roman9/utf8.ctb
charsets/utf8/
charsets/utf8/iso15.ctb
charsets/utf8/utf8.cfg
charsets/utf8/roman9.ctb
charsets/unicode/
charsets/unicode/cp1250.uct
charsets/unicode/cp1251.uct
charsets/unicode/cp1252.uct
charsets/unicode/cp1253.uct
charsets/unicode/cp1254.uct
charsets/unicode/cp1255.uct
charsets/unicode/cp1256.uct
charsets/unicode/cp1257.uct
charsets/unicode/cp1258.uct
charsets/unicode/cp874.uct
charsets/unicode/iso15.uct
charsets/unicode/roman9.uct
config/
config/objectid.dat
devlib/
devlib/libinsck.so.11.1.1.1
lib/
lib/sybsyesp.so
lib/xpsmsgs.so
lib/libsmapp.a
lib/libinsck.so.11.1.1.1
locales/
locales/message/
locales/message/us_english/
locales/message/us_english/bslib.loc
scripts/
scripts/installcommit
scripts/installsecurity
scripts/installmaster
scripts/instmsgs.ebf
scripts/installdbccdb
scripts/installdbccalt
symlib/
symlib/sybsyesp.so
symlib/xpsmsgs.so
upgrade/
upgrade/preupgrade
upgrade/upgrade
[root@poweredge sybase-11.9.2]#

  • rootユーザでファイルが展開されてしまっている.
  • ディレクトリを移動する.

[root@poweredge sybase-11.9.2]# cd /opt
[root@poweredge /opt]# ls -la
total 4952
drwxr-xr-x    3 root     root         4096 Apr 15 18:42 .
drwxr-xr-x   18 root     root         4096 Apr 15 18:45 ..
drwxrwxr-x   22 root     root         4096 Apr 16 14:14 sybase-11.9.2
-rw-rw-r--    1 root     root      5044673 Apr 15 18:41 sybase-common-11.9.2-
1.i386.rpm
[root@poweredge /opt]#

  • 権限をsybaseユーザにしておく.

[root@poweredge /opt]# chown -R sybase sybase-11.9.2
[root@poweredge /opt]# chgrp -R sybase sybase-11.9.2
[root@poweredge /opt]#

5.適用作業 システムデータベースの更新

  • sybaseユーザに戻り,ASEを起動する.

[root@poweredge /opt]# exit
exit
bash$ id
uid=501(sybase) gid=501(sybase) groups=501(sybase)
bash$
bash$ cd $SYBASE/install
bash$ ls
RUN_poweredge       SPR        cshrc    rc.sybase   startserver
RUN_poweredge_back  auditinit  profile  showserver  sybinstall.sh
bash$ startserver -f RUN_poweredge -f RUN_poweredge_back

  • installmasterファイルを確認する.

bash$ ls -la $SYBASE/scripts/installmaster
-r--r-xr--    1 sybase   sybase    2162850 Mar 12 17:55 /opt/sybase-11.9.2/scri
pts/installmaster
bash$ 

  • isqlにより,installmasterファイルを実行する.

bash$ isql -Usa -P -Spoweredge -n -i$SYBASE/scripts/installmaster -o$SYBASE/da
tabase/log/EBF10032.log
00:00000:00001:2002/04/16 14:25:50.74 server  Configuration file '/opt/sybase-
11.9.2/poweredge.cfg' has been written and the previous version has been renam
ed to '/opt/sybase-11.9.2/poweredge.031'.
00:00000:00001:2002/04/16 14:25:50.75 server  The configuration option 'allow 
updates to system tables' has been changed by 'sa' from '0' to '1'.
00:00000:00001:2002/04/16 14:26:39.77 server  Configuration file '/opt/sybase-
11.9.2/poweredge.cfg' has been written and the previous version has been renam
ed to '/opt/sybase-11.9.2/poweredge.032'.
00:00000:00001:2002/04/16 14:26:39.77 server  The configuration option 'allow 
updates to system tables'has been changed by 'sa' from '1' to '0'.
bash$

  • 実行ログを確認してみる.

bash$ cat $SYBASE/database/log/EBF10032.log

Msg 2401, Level 11, State 2:
Character set conversion is not available between client character set 'iso_1'
and server character set 'sjis'.
No conversions will be done.
(1 row affected)
(1 row affected)
             
 ----------- 
           1 
(1 row affected)
Dropping sp_procxmode
Dropping sp_validlang
Dropping sp_getmessage
Dropping sp_configure
Dropping sp_dboption
Dropping sp_validaltlang
Dropping sp_namecrack
Dropping sp_chklangparam
Dropping sp_helpgroup
Dropping sp_helpuser
Dropping sp_locklogin
Dropping sp_displaylogin
Dropping sp_addalias
Dropping sp_addgroup
Dropping sp_password
Dropping sp_addlogin
Dropping sp_addtype
Dropping sp_addumpdevice
Dropping sp_addthreshold
Dropping sp_modifythreshold
Dropping sp_adduser
Dropping sp_addremotelogin
Dropping sp_addsegment
Dropping sp_addserver
Dropping sp_addlanguage
Dropping sp_defaultlanguage
Dropping sp_helplanguage
Dropping sp_droplanguage
Dropping sp_setlangalias
Dropping sp_bindefault
Dropping sp_bindrule
Dropping sp_changedbowner
Dropping sp_aux_getsize
Dropping syb_aux_expandbitmap
Dropping syb_aux_privexor
Dropping syb_aux_privnots
Dropping syb_aux_privsand
Dropping syb_aux_privunion
Dropping syb_aux_colbit
Dropping syb_aux_printprivs
Dropping sp_aux_computeprivs
Dropping sp_aux_text
Dropping sp_checksource
Dropping sp_column_privileges
Dropping sp_table_privileges
Dropping sp_changegroup
Dropping sp_commonkey
Dropping sp_cursorinfo
Dropping sp_defaultdb
Dropping sp_databases
Dropping sp_dbremap
Dropping sp_remap
Dropping sp_depends
Dropping sp_diskdefault
Dropping sp_dropalias
Dropping sp_dropdevice
Dropping sp_dropgroup
Dropping sp_dropkey
Dropping sp_droplogin
Dropping sp_dropthreshold
Dropping sp_droptype
Dropping sp_dropuser
Dropping sp_addextendedproc
Dropping sp_dropextendedproc
Dropping sp_freedll
Dropping sp_helpextendedproc
Dropping sp_dropremotelogin
Dropping sp_dropsegment
Dropping sp_dropserver
Dropping sp_estspace
Dropping sp_extendsegment
Dropping sp_fixindex
Dropping sp_fkeys
Dropping sp_flushstats
Dropping sp_foreignkey
Dropping sp_helpconstraint
Dropping sp_helpdb
Dropping sp_helpdevice
Dropping sp_helplog
Dropping sp_helpindex
Dropping sp_helpjoins
Dropping sp_helpkey
Dropping sp_objectsegment
Dropping sp_indsuspect
Dropping sp_helpartition
Dropping sp_help
Dropping sp_helprotect
Dropping sp_helptext
Dropping sp_helpthreshold
Dropping sp_lock
Dropping sp_logdevice
Dropping sp_lookup
Dropping sp_helpremotelogin
Dropping sp_helpsegment
Dropping sp_helpsort
Dropping sp_helpserver
Dropping sp_hidetext
Dropping sp_markreport
Dropping sp_monitor
Dropping sp_pkeys
Dropping sp_placeobject
Dropping sp_primarykey
Dropping sp_recompile
Dropping sp_remoteoption
Dropping sp_rename
Dropping sp_renamedb
Dropping sp_serveroption
Dropping sp_serverinfo
Dropping sp_server_info
Dropping sp_inform
Dropping sp_setreplicate
Dropping sp_spaceused
Dropping sp_sproc_columns
Dropping sp_statistics
Dropping sp_sendmsg
Dropping sp_stored_procedures
Dropping sp_unbindefault
Dropping sp_unbindrule
Dropping sp_who
Dropping sp_procqmode
Dropping sp_reportstats
Dropping sp_clearstats
Dropping sp_datatype_info
Dropping sp_addmessage
Dropping sp_dropmessage
Dropping sp_bindmsg
Dropping sp_unbindmsg
Dropping sp_altermessage
Dropping sp_role
Dropping sp_modifylogin
Dropping sp_volchanged
Dropping sp_checkreswords
Dropping sp_tables
Dropping sp_special_columns
Dropping sp_columns
Dropping sp_aux_parse_entity
Dropping sp_cachestrategy
Dropping sp_chgattribute
Dropping sp_cacheconfig
Dropping sp_bindcache
Dropping sp_poolconfig
Dropping sp_unbindcache
Dropping sp_unbindcache_all
Dropping sp_setrepcol
Dropping sp_setrepproc
Dropping sp_setreptable
Dropping sp_logiosize
Dropping sp_helpcache
Dropping sp_setrepdefmode
Dropping sp_displaylevel
Dropping sp_setlockpromote
Dropping sp_droplockpromote
Dropping sp_familylock
Dropping sp_setpglockpromote
Dropping sp_dropglockpromote
Dropping sp_setrowlockpromote
Dropping sp_droprowlockpromote
Dropping sp_sysmon_kernel
Dropping sp_sysmon_wpm
Dropping sp_sysmon_parallel
Dropping sp_sysmon_taskmgmt
Dropping sp_sysmon_appmgmt
Dropping sp_sysmon_esp
Dropping sp_sysmon_hk
Dropping sp_sysmon_maccess
Dropping sp_sysmon_xactsum
Dropping sp_sysmon_xactmgmt
Dropping sp_sysmon_index
Dropping sp_sysmon_mdcache
Dropping sp_sysmon_locks
Dropping sp_sysmon_dcache_dtl
Dropping sp_sysmon_dcache_sum
Dropping sp_sysmon_dcache
Dropping sp_sysmon_pcache
Dropping sp_sysmon_memory
Dropping sp_sysmon_recovery
Dropping sp_sysmon_diskio
Dropping sp_sysmon_netio
Dropping sp_addengine
Dropping sp_addexeclass
Dropping sp_bindexeclass
Dropping sp_clearpsexe
Dropping sp_dropengine
Dropping sp_dropexeclass
Dropping sp_setpsexe
Dropping sp_showcontrolinfo
Dropping sp_showexeclass
Dropping sp_showpsexe
Dropping sp_unbindexeclass
Dropping sp_activeroles
Dropping sp_displayroles
Dropping sp_validateconfigname
Dropping sp_countmetadata
Dropping sp_monitormetadata
Dropping sp_monitorconfig
Dropping sp_helpconfig
Dropping sp_sysmon_collect
Dropping sp_sysmon_analyze
Dropping sp_shmdumpsize
Dropping sp_shmdumpdrop
Dropping sp_shmdumpdisp
Dropping sp_shmdumpconfig
Dropping sp_sysmon
Dropping sp_add_resource_limit
Dropping sp_add_time_range
Dropping sp_drop_resource_limit
Dropping sp_drop_time_range
Dropping sp_help_resource_limit
Dropping sp_modify_resource_limit
Dropping sp_modify_time_range
Dropping sp_showplan
Dropping sp_listsuspect_page
Dropping sp_forceonline_page
Dropping sp_makesuspect_obj
Dropping sp_forceonline_db
Dropping sp_listsuspect_db
Dropping sp_listsuspect_object
Dropping sp_forceonline_object
Dropping sp_setsuspect_error
Dropping sp_setsuspect_granularity
Dropping sp_setsuspect_threshold
Dropping sp_dbrecovery_order
Dropping sp_plan_dbccdb
Dropping sp_reptostandby
Dropping sp_config_rep_agent
Dropping sp_help_rep_agent
Dropping sp_start_rep_agent
Dropping sp_stop_rep_agent
Dropping sp_object_stats
Dropping sp_iqdbcheck
Dropping sp_addexternlogin
Dropping sp_addobjectdef
Dropping sp_addtabledef
Dropping sp_autoconnect
Dropping sp_defaultloc
Dropping sp_dropexternlogin
Dropping sp_dropobjectdef
Dropping sp_droptabledef
Dropping sp_helpexternlogin
Dropping sp_helpobjectdef
Dropping sp_passthru
Dropping sp_remotesql
Dropping sp_servertype
Dropping sp_checknames
Installing sp_instmsg
(return status = 1)
(return status = 1)

〜略〜

(return status = 0)
(return status = 0)
(return status = 0)
(return status = 0)
(return status = 0)
(return status = 0)
(return status = 0)
(0 rows affected)
(1 row affected)
(1 row affected)

〜略〜

(1 row affected)
(1 row affected)
(1 row affected)
Msg 2714, Level 16, State 1:
Line 5:
There is already an object named 'syblicenseslog' in the database.
Installing sp_procxmode
(return status = 0)
Installing sp_validlang
(return status = 0)
Installing sp_getmessage
(return status = 0)
Installing sp_configure
(return status = 0)
Installing sp_dboption
(return status = 0)
(0 rows affected)
(1 row affected)
(1 row affected)
(1 row affected)
(1 row affected)
DBCC execution completed. If DBCC printed error messages, contact a user with
System Administrator (SA) role.
Installing sp_dbupgrade
Installing sp_loaddbupgrade
Installing sp_prtsybsysmsgs
(1 row affected)
(1 row affected)
(1 row affected)
Installing system stored procedures in the sybsystemprocs database.
(return status = 0)
Database option 'trunc. log on chkpt.' turned ON for database 'sybsystemprocs'.
Run the CHECKPOINT command in the database that was changed.
(return status = 0)
(1 row affected)
(1 row affected)

〜略〜

(1 row affected)
(1 row affected)
(1 row affected)
(0 rows affected)
(0 rows affected)
Installing sp_procxmode
(return status = 0)
Installing sp_validlang
(return status = 0)
Installing sp_getmessage
(return status = 0)
Installing sp_configure
(return status = 0)
Installing sp_dboption
(return status = 0)
Installing sp_validaltlang
(return status = 0)
Installing sp_namecrack
(return status = 0)
Installing sp_chklangparam
Installing sp_helpgroup
(return status = 0)
Installing sp_helpuser
(return status = 0)
Installing sp_locklogin
(return status = 0)
Installing sp_displaylogin
(return status = 0)
Installing sp_addalias
(return status = 0)
Installing sp_addgroup
(return status = 0)
Installing sp_password
(return status = 0)
Installing sp_addlogin
(return status = 0)
Installing sp_addtype
(return status = 0)
Installing sp_addumpdevice
(return status = 0)
Installing sp_addthreshold
(return status = 0)
Installing sp_modifythreshold
(return status = 0)
Installing sp_adduser
(return status = 0)
Installing sp_addremotelogin
(return status = 0)
Installing sp_addsegment
(return status = 0)
Installing sp_addserver
(return status = 0)
Installing sp_addlanguage
(return status = 0)
Installing sp_defaultlanguage
(return status = 0)
Installing sp_helplanguage
(return status = 0)
Installing sp_droplanguage
(return status = 0)
Installing sp_setlangalias
(return status = 0)
Installing sp_bindefault
(return status = 0)
Installing sp_bindrule
(return status = 0)
Installing sp_changedbowner
(return status = 0)
Installing sp_aux_getsize
(return status = 0)
Installing syb_aux_expandbitmap
(return status = 0)
Installing syb_aux_privexor
(return status = 0)
Installing syb_aux_privnots
(return status = 0)
Installing syb_aux_privsand
(return status = 0)
Installing syb_aux_privunion
(return status = 0)
Installing syb_aux_colbit
(return status = 0)
Installing syb_aux_printprivs
(return status = 0)
Installing sp_aux_computeprivs
(return status = 0)
Installing sp_aux_text
(return status = 0)
Installing sp_checksource
(return status = 0)
Installing sp_column_privileges
(return status = 0)
Installing sp_table_privileges
(return status = 0)
Installing sp_changegroup
(return status = 0)
Installing sp_commonkey
(return status = 0)
Installing sp_cursorinfo
(return status = 0)
Installing sp_dboption
(return status = 0)
Installing sp_defaultdb
(return status = 0)
Installing sp_databases
(return status = 0)
Installing sp_dbremap
(return status = 0)
Installing sp_remap
(return status = 0)
Installing sp_depends
(return status = 0)
Installing sp_diskdefault
(return status = 0)
Installing sp_dropalias
(return status = 0)
Installing sp_dropdevice
(return status = 0)
Installing sp_dropgroup
(return status = 0)
Installing sp_dropkey
(return status = 0)
Installing sp_droplogin
(return status = 0)
Installing sp_dropthreshold
(return status = 0)
Installing sp_droptype
(return status = 0)
Installing sp_dropuser
(return status = 0)
Installing sp_addextendedproc
(return status = 0)
Installing sp_dropextendedproc
(return status = 0)
Installing sp_freedll
(return status = 0)
Installing sp_helpextendedproc
(return status = 0)
Installing sp_dropremotelogin
(return status = 0)
Installing sp_dropsegment
(return status = 0)
Installing sp_dropserver
(return status = 0)
Installing sp_estspace
(return status = 0)
Installing sp_extendsegment
(return status = 0)
Installing sp_fixindex
(return status = 0)
Installing sp_fkeys
(return status = 0)
Installing sp_flushstats
(return status = 0)
Installing sp_foreignkey
(return status = 0)
Installing sp_helpconstraint
(return status = 0)
Installing sp_helpdb
(return status = 0)
Installing sp_helpdevice
(return status = 0)
Installing sp_helplog
(return status = 0)
Installing sp_helpindex
(return status = 0)
Installing sp_helpjoins
(return status = 0)
Installing sp_helpkey
(return status = 0)
Installing sp_objectsegment
(return status = 0)
Installing sp_indsuspect
(return status = 0)
Installing sp_helpartition
(return status = 0)
Installing sp_help
(return status = 0)
Installing sp_helprotect
(return status = 0)
Installing sp_helptext
(return status = 0)
Installing sp_helpthreshold
(return status = 0)
Installing sp_lock
(return status = 0)
Installing sp_logdevice
(return status = 0)
Installing sp_lookup
(return status = 0)
Installing sp_helpremotelogin
(return status = 0)
Installing sp_helpsegment
(return status = 0)
Installing sp_helpsort
(return status = 0)
Installing sp_helpserver
(return status = 0)
Installing sp_hidetext
(return status = 0)
Installing sp_markreport
(return status = 0)
Installing sp_monitor
(return status = 0)
Installing sp_pkeys
(return status = 0)
Installing sp_placeobject
(return status = 0)
Installing sp_primarykey
(return status = 0)
Installing sp_recompile
(return status = 0)
Installing sp_remoteoption
(return status = 0)
Installing sp_rename
(return status = 0)
Installing sp_renamedb
(return status = 0)
Installing sp_serveroption
(return status = 0)
Installing sp_serverinfo
(return status = 0)
Installing sp_server_info
(return status = 0)
Installing sp_inform
(return status = 0)
Installing sp_setreplicate
(return status = 0)
Installing sp_spaceused
(return status = 0)
Installing sp_sproc_columns
(return status = 0)
Installing sp_statistics
(return status = 0)
Installing sp_sendmsg
Installing sp_stored_procedures
(return status = 0)
Installing sp_unbindefault
(return status = 0)
Installing sp_unbindrule
(return status = 0)
Installing sp_who
(return status = 0)
Installing sp_procqmode
(return status = 0)
Primary key for the table or view dropped.
(return status = 0)
New primary key added.
(return status = 0)
Primary key for the table or view dropped.
(return status = 0)
New primary key added.
(return status = 0)
Primary key for the table or view dropped.
(return status = 0)
New primary key added.
(return status = 0)
Primary key for the table or view dropped.
(return status = 0)
New primary key added.
(return status = 0)
Primary key for the table or view dropped.
(return status = 0)
New primary key added.
(return status = 0)
Primary key for the table or view dropped.
(return status = 0)
New primary key added.
(return status = 0)
Primary key for the table or view dropped.
Dependent foreign keys were also dropped.
(return status = 0)
New primary key added.
(return status = 0)
Primary key for the table or view dropped.
(return status = 0)
New primary key added.
(return status = 0)
Primary key for the table or view dropped.
(return status = 0)
New primary key added.
(return status = 0)
Primary key for the table or view dropped.
(return status = 0)
New primary key added.
(return status = 0)
Primary key for the table or view dropped.
Dependent foreign keys were also dropped.
(return status = 0)
New primary key added.
(return status = 0)
Primary key for the table or view dropped.
(return status = 0)
New primary key added.
(return status = 0)
New foreign key added.
(return status = 0)
Common keys dropped.
(return status = 0)
New common key added.
(return status = 0)
Common keys dropped.
(return status = 0)
New common key added.
(return status = 0)
New common key added.
(return status = 0)
Common keys dropped.
(return status = 0)
New common key added.
(return status = 0)
Common keys dropped.
(return status = 0)
New common key added.
(return status = 0)
New common key added.
(return status = 0)
New common key added.
(return status = 0)
New common key added.
(return status = 0)
Common keys dropped.
(return status = 0)
New common key added.
(return status = 0)
Common keys dropped.
(return status = 0)
New common key added.
(return status = 0)
Common keys dropped.
(return status = 0)
New common key added.
(return status = 0)
Common keys dropped.
(return status = 0)
New common key added.
(return status = 0)
New foreign key added.
(return status = 0)
Common keys dropped.
(return status = 0)
New common key added.
(return status = 0)
Common keys dropped.
(return status = 0)
New common key added.
(return status = 0)
Common keys dropped.
(return status = 0)
New common key added.
(return status = 0)
Common keys dropped.
(return status = 0)
New common key added.
(return status = 0)
Common keys dropped.
(return status = 0)
New common key added.
(return status = 0)
Common keys dropped.
(return status = 0)
New common key added.
(return status = 0)
Common keys dropped.
(return status = 0)
New common key added.
(return status = 0)
Primary key for the table or view dropped.
(return status = 0)
New primary key added.
(return status = 0)
Primary key for the table or view dropped.
(return status = 0)
New primary key added.
(return status = 0)
Primary key for the table or view dropped.
(return status = 0)
New primary key added.
(return status = 0)
Primary key for the table or view dropped.
(return status = 0)
New primary key added.
(return status = 0)
Primary key for the table or view dropped.
(return status = 0)
New primary key added.
(return status = 0)
Primary key for the table or view dropped.
(return status = 0)
New primary key added.
(return status = 0)
Primary key for the table or view dropped.
Dependent foreign keys were also dropped.
(return status = 0)
New primary key added.
(return status = 0)
Primary key for the table or view dropped.
(return status = 0)
New primary key added.
(return status = 0)
Primary key for the table or view dropped.
(return status = 0)
New primary key added.
(return status = 0)
Primary key for the table or view dropped.
(return status = 0)
New primary key added.
(return status = 0)
Primary key for the table or view dropped.
Dependent foreign keys were also dropped.
(return status = 0)
New primary key added.
(return status = 0)
Primary key for the table or view dropped.
(return status = 0)
New primary key added.
(return status = 0)
Primary key for the table or view dropped.
(return status = 0)
New primary key added.
(return status = 0)
Primary key for the table or view dropped.
(return status = 0)
New primary key added.
(return status = 0)
New foreign key added.
(return status = 0)
Common keys dropped.
(return status = 0)
New common key added.
(return status = 0)
Common keys dropped.
(return status = 0)
New common key added.
(return status = 0)
New common key added.
(return status = 0)
Common keys dropped.
(return status = 0)
New common key added.
(return status = 0)
Common keys dropped.
(return status = 0)
New common key added.
(return status = 0)
New common key added.
(return status = 0)
New common key added.
(return status = 0)
New common key added.
(return status = 0)
Common keys dropped.
(return status = 0)
New common key added.
(return status = 0)
Common keys dropped.
(return status = 0)
New common key added.
(return status = 0)
Common keys dropped.
(return status = 0)
New common key added.
(return status = 0)
Common keys dropped.
(return status = 0)
New common key added.
(return status = 0)
New foreign key added.
(return status = 0)
Common keys dropped.
(return status = 0)
New common key added.
(return status = 0)
Common keys dropped.
(return status = 0)
New common key added.
(return status = 0)
Common keys dropped.
(return status = 0)
New common key added.
(return status = 0)
Common keys dropped.
(return status = 0)
New common key added.
(return status = 0)
Common keys dropped.
(return status = 0)
New common key added.
(return status = 0)
Common keys dropped.
(return status = 0)
New common key added.
(return status = 0)
Primary key for the table or view dropped.
(return status = 0)
New primary key added.
(return status = 0)
Primary key for the table or view dropped.
(return status = 0)
New primary key added.
(return status = 0)
Primary key for the table or view dropped.
(return status = 0)
New primary key added.
(return status = 0)
Primary key for the table or view dropped.
(return status = 0)
New primary key added.
(return status = 0)
Primary key for the table or view dropped.
(return status = 0)
New primary key added.
(return status = 0)
Primary key for the table or view dropped.
(return status = 0)
New primary key added.
(return status = 0)
Common keys dropped.
(return status = 0)
New common key added.
(return status = 0)
Common keys dropped.
(return status = 0)
New common key added.
(return status = 0)
Common keys dropped.
(return status = 0)
New common key added.
(return status = 0)
Common keys dropped.
(return status = 0)
New common key added.
(return status = 0)
Common keys dropped.
(return status = 0)
New common key added.
(return status = 0)
Common keys dropped.
(return status = 0)
New common key added.
(return status = 0)
Common keys dropped.
(return status = 0)
New common key added.
(return status = 0)
Common keys dropped.
(return status = 0)
New common key added.
(return status = 0)
Common keys dropped.
(return status = 0)
New common key added.
(return status = 0)
Installing sp_reportstats
(return status = 0)
Installing sp_clearstats
(return status = 0)
Installing sp_datatype_info
(return status = 0)
Installing sp_addmessage
(return status = 0)
Installing sp_dropmessage
(return status = 0)
Installing sp_bindmsg
(return status = 0)
Installing sp_unbindmsg
(return status = 0)
Installing sp_altermessage
(return status = 0)
Installing sp_role
(return status = 0)
Installing sp_modifylogin
(return status = 0)
Installing sp_volchanged
(return status = 0)
Installing sp_checkreswords
(return status = 0)
Installing sp_tables
(return status = 0)
Installing sp_special_columns
(return status = 0)
Installing sp_columns
(return status = 0)
Installing sp_aux_parse_entity
Installing sp_cachestrategy
(return status = 0)
Installing sp_chgattribute
(return status = 0)
Installing sp_cacheconfig
(return status = 0)
Installing sp_bindcache
(return status = 0)
Installing sp_poolconfig
(return status = 0)
Installing sp_unbindcache
(return status = 0)
Installing sp_unbindcache_all
(return status = 0)
Installing sp_setrepcol
(return status = 0)
Installing sp_setrepproc
(return status = 0)
Installing sp_setreptable
(return status = 0)
Installing sp_logiosize
(return status = 0)
Installing sp_helpcache
(return status = 0)
Installing sp_setrepdefmode
(return status = 0)
Installing sp_displaylevel
(return status = 0)
Installing sp_setlockpromote
(return status = 0)
Installing sp_droplockpromote
(return status = 0)
Installing sp_familylock
(return status = 0)
Installing sp_setpglockpromote
(return status = 0)
Installing sp_dropglockpromote
(return status = 0)
Installing sp_setrowlockpromote
(return status = 0)
Installing sp_droprowlockpromote
(return status = 0)
Installing sp_sysmon_kernel
(return status = 0)
Installing sp_sysmon_wpm
(return status = 0)
Installing sp_sysmon_parallel
(return status = 0)
Installing sp_sysmon_taskmgmt
(return status = 0)
Installing sp_sysmon_appmgmt
(return status = 0)
Installing sp_sysmon_esp
(return status = 0)
Installing sp_sysmon_hk
(return status = 0)
Installing sp_sysmon_maccess
(return status = 0)
Installing sp_sysmon_xactsum
(return status = 0)
Installing sp_sysmon_xactmgmt
(return status = 0)
Installing sp_sysmon_index
(return status = 0)
Installing sp_sysmon_mdcache
(return status = 0)
Installing sp_sysmon_locks
(return status = 0)
Installing sp_sysmon_dcache_dtl
(return status = 0)
Installing sp_sysmon_dcache_sum
(return status = 0)
Installing sp_sysmon_dcache
(return status = 0)
Installing sp_sysmon_pcache
(return status = 0)
Installing sp_sysmon_memory
(return status = 0)
Installing sp_sysmon_recovery
(return status = 0)
Installing sp_sysmon_diskio
(return status = 0)
Installing sp_sysmon_netio
(return status = 0)
Installing sp_addengine
Installing sp_addexeclass
Installing sp_bindexeclass
Installing sp_clearpsexe
(return status = 0)
Installing sp_dropengine
Installing sp_dropexeclass
Installing sp_setpsexe
(return status = 0)
Installing sp_showcontrolinfo
(return status = 0)
Installing sp_showexeclass
(return status = 0)
Installing sp_showpsexe
(return status = 0)
Installing sp_unbindexeclass
Installing sp_activeroles
(return status = 0)
Installing sp_displayroles
(return status = 0)
Installing sp_validateconfigname
(return status = 0)
Installing sp_countmetadata
(return status = 0)
Installing sp_monitormetadata
(return status = 0)
Installing sp_monitorconfig
(return status = 0)
Installing sp_helpconfig
(return status = 0)
Installing sp_sysmon_collect
(return status = 0)
Installing sp_sysmon_analyze
(return status = 0)
Installing sp_shmdumpsize
(return status = 0)
Installing sp_shmdumpdrop
(return status = 0)
Installing sp_shmdumpdisp
(return status = 0)
Installing sp_shmdumpconfig
(return status = 0)
Installing sp_sysmon
(return status = 0)
Installing sp_add_resource_limit
(return status = 0)
Installing sp_add_time_range
(return status = 0)
Installing sp_drop_resource_limit
(return status = 0)
Installing sp_drop_time_range
(return status = 0)
Installing sp_help_resource_limit
(return status = 0)
Installing sp_modify_resource_limit
(return status = 0)
Installing sp_modify_time_range
(return status = 0)
Installing sp_showplan
Installing sp_listsuspect_page
(return status = 0)
Installing sp_forceonline_page
(return status = 0)
Installing sp_makesuspect_obj
Installing sp_forceonline_db
(return status = 0)
Installing sp_listsuspect_db
(return status = 0)
Installing sp_listsuspect_object
(return status = 0)
Installing sp_forceonline_object
(return status = 0)
Installing sp_setsuspect_error
(return status = 0)
Installing sp_setsuspect_granularity
(return status = 0)
Installing sp_setsuspect_threshold
(return status = 0)
Installing sp_dbrecovery_order
(return status = 0)
Installing sp_plan_dbccdb
(return status = 0)
Installing sp_reptostandby
(return status = 0)
Installing sp_config_rep_agent
(return status = 0)
Installing sp_help_rep_agent
(return status = 0)
Installing sp_start_rep_agent
(return status = 0)
Installing sp_stop_rep_agent
(return status = 0)
Installing sp_object_stats
(return status = 0)
Installing sp_modifystats
(return status = 0)
Installing sp_iqdbcheck
(return status = 0)
Installing sp_addexternlogin
(return status = 0)
Installing sp_addobjectdef
(return status = 0)
Installing sp_addtabledef
(return status = 0)
Installing sp_autoconnect
(return status = 0)
Installing sp_defaultloc
(return status = 0)
Installing sp_dropexternlogin
(return status = 0)
Installing sp_dropobjectdef
(return status = 0)
Installing sp_droptabledef
(return status = 0)
Installing sp_helpexternlogin
(return status = 0)
Installing sp_helpobjectdef
(return status = 0)
Installing sp_passthru
(return status = 0)
Installing sp_remotesql
(return status = 0)
Installing sp_servertype
(return status = 0)
Installing sp_checknames
(return status = 0)
(1 row affected)
(return status = 0)
(return status = 0)
 Parameter Name                 Default     Memory Used Config Value
	 Run Value   
 ------------------------------ ----------- ----------- ------------ 
	----------- 
 allow updates to system tables           0           0           0 
	           0 
(1 row affected)
Configuration option changed. The SQL Server need not be rebooted since the
option is dynamic.
(return status = 0)
Loading of master database is complete.
bash$ 
bash$ 
bash$ 

  • 別に再起動しなくて良いらしい.
  • バージョンを確認してみる.

bash$ isql -Usa -P -Spoweredge
Msg 2401, Level 11, State 2:
Line 1:
Character set conversion is not available between client character set 'iso_1'
and server character set 'sjis'.
No conversions will be done.
1> select @@version
2> go


        -----------------------------------------------------------------------------
-------------------
-------------------------------------------------------------------------------------
-------------------
-------------------------------------------------------
         Adaptive Server Enterprise/11.9.2.6/1287/P/SWR 10032 ROLLUP/Linux Intel/Linu
x 2.2.5-15 i586/OPT/Mon Mar 11 23:46:34 2002

(1 row affected)
1>

  • EBF10032が適用されている事がわかる.

6.適用作業 メッセージファイルの更新

  • installmasterと同じように,メッセージファイルを更新する.
  • bash$ isql -Usa -P -Spoweredge -n -i$SYBASE/scripts/instmsgs.ebf -o$SYBASE/datab
    ase/log/ebf10032.msg.log
    00:00000:00001:2002/04/16 14:48:52.90 server  WARNING: *************************
    **
    00:00000:00001:2002/04/16 14:48:52.90 server  Attempt by user 1 to dump xact on 
    db master with NO_LOG
    00:00000:00001:2002/04/16 14:48:52.91 server  Attempt by user 1 to dump xact on 
    db master with NO_LOG wa
    s successful
    00:00000:00001:2002/04/16 14:48:52.91 server  WARNING: *************************
    **
    00:00000:00001:2002/04/16 14:48:52.92 server  Configuration file '/opt/sybase-11
    .9.2/poweredge.cfg' has been written and the previous version has been renamed t
    o '/opt/sybase-11.9.2/poweredge.033'.
    00:00000:00001:2002/04/16 14:48:52.92 server  The configuration option 'allow up
    dates to system tables' has been changed by 'sa' from '0' to '1'.
    00:00000:00001:2002/04/16 14:48:53.35 server  Configuration file '/opt/sybase-11
    .9.2/poweredge.cfg' has been written and the previous version has been renamed t
    o '/opt/sybase-11.9.2/poweredge.034'.
    00:00000:00001:2002/04/16 14:48:53.35 server  The configuration option 'allow up
    dates to system tables'
    has been changed by 'sa' from '1' to '0'.
    bash$

7.その他の適用

  • ここまでで説明してきたもの以外でも,利用している環境によって,以下のスクリプトの実行も行う.
    • 2フェーズコミットを利用している場合は,以下も実行する.
      • $SYBASE/scripts/installcommit
    • セキュリティデータベースを使用している場合
      • $SYBASE/scripts/installsecurity



広告スペース
Google