{"id":990,"date":"2010-11-16T05:33:42","date_gmt":"2010-11-16T05:33:42","guid":{"rendered":"http:\/\/pchero21.com\/?p=990"},"modified":"2010-11-16T05:33:42","modified_gmt":"2010-11-16T05:33:42","slug":"sybase-%ea%b8%b0%eb%b3%b8-%ec%82%ac%ec%9a%a9%eb%b2%95%ec%8b%9c%ec%9e%91%ec%a2%85%eb%a3%8c-loginlogout-db%ec%83%9d%ec%84%b1%ec%82%ad%ec%a0%9c%eb%b3%80%ea%b2%bd-device%eb%93%b1%eb%a1%9d","status":"publish","type":"post","link":"http:\/\/pchero21.com\/?p=990","title":{"rendered":"SYBASE \uae30\ubcf8 \uc0ac\uc6a9\ubc95(\uc2dc\uc791\/\uc885\ub8cc, Login\/Logout, DB\uc0dd\uc131\/\uc0ad\uc81c\/\ubcc0\uacbd, Device\ub4f1\ub85d\/\uc0ad\uc81c,"},"content":{"rendered":"

SYBASE \uc0ac\uc6a9\ubc95(\uc694\uc57d)<\/p>\n

SYBASE home directory\ub294 \/home\/sybase\ub85c \uac00\uc815\ud558\uba70, \uc774\ud558 ‘HOME’\uc774\ub77c \ud569\ub2c8\ub2e4.<\/p>\n

1.User System Account\ub4f1\ub85d
\n   1)User Account\uc0dd\uc131(System\uc758 User\ub4f1\ub85d\ubc29\ubc95\uc5d0 \ub530\ub77c)
\n      Login as root – System Booting\ud6c4 Root\uc640 Password \uc785\ub825)
\n      Ex) #vi \/etc\/passwd\/
\n      Format] username:password:UID:GID:comment:user home directory:shell type
\n      Example]sybase::100:100:SYBASE USER:\/home\/sybase:\/bin\/csh<\/p>\n

  2)User Directory\uc0dd\uc131
\n      #cd \/home
\n      #mkdir sybase
\n      #chown sybase sybase
\n      #exit<\/p>\n

2.Sysytem Login
\n   Login as sybase – System Booting\ud6c4 User name\uacfc Password\uc785\ub825<\/p>\n

3.Server\ub97c Start\uc2dc\ud0b4
\n   1)”HOME”\uc5d0\uc11c install directory\ub85c \ubcc0\uacbd(cd install)
\n      Format]startserver -f RUN_SERVERNAME
\n      \u203b RUN_SYBASE\uc778 \uacbd\uc6b0, startserver\ub9cc \ud574\uc90c, ServerName\ub294 LAN\uc0c1 unique\ud574\uc57c \ud568
\n      \u203b showserver – server\uac00 start\ub418\uc5b4 \uc788\ub294\uc9c0 install directory\uc5d0\uc11c \ud655\uc778.<\/p>\n

4.Server\ub85c Login
\n   1)isql -Usa -P(default is null) – isql \uc0ac\uc6a9
\n      1>SQL Commend \uc785\ub825
\n      2>qo
\n      3>quit  \/* isql exit *\/<\/p>\n

5.Shutdown the Server
\n   1)At isql – recommended
\n      1>shutdown (with nowait)
\n      2>go
\n       \/* with nowait option \uc740 \uc9c4\ud589\uc911\uc778 process\uc758 \uc815\uc0c1\uc885\ub8cc\uc5c6\uc774 Server\uac00 Down\ub428 *\/
\n   2)At OS prompt
\n      %kill -9 PID \/* PID : dataserver process ID *\/<\/p>\n

6.\uae30\uc874 DataBase(install\ud6c4 \uc0dd\uc131)
\n   1)System Database
\n      (1)master – db\ub97c \uad00\ub9ac\ud558\ub294 db(db\uc815\ubcf4, device\uc815\ubcf4, login, account\ub4f1)
\n         \/* master db\uc5d0 object\ub97c \uc0dd\uc131\ud558\ub294 \uac83\uc740 \ud53c\ud574\uc57c \ud55c\ub2e4. – master db full *\/
\n      (2)model – User db\ub97c \uc0dd\uc131\ud558\ub294 prototype(db\ub97c \uc0dd\uc131\ud560 \ub54c model db \ubcf5\uc81c)
\n      (3)tempdb – join, sorting, temprary table($table_name)\ub4f1\uc758 \uc791\uc5c5\uc601\uc5ed
\n      (4)sybsystemrocs – Sybase \uc81c\uacf5 System Procedures(SP_who, SP_hwwlpdb \ub4f1)
\n      (5)sybsecurity – \uc2dc\uc2a4\ud15c \uc804\ubc18\uc801\uc778 \uc0ac\uc6a9\uc744 \uac10\uc2dc\ud558\ub294 db(user, db, table, SQL\ub4f1)
\n      (6)sybsyntec – \uba85\ub839\uc5b4\ub97c \uc800\uc7a5\ud558\uace0 \uc788\ub294 db(DML,DDL,DCL \ubc0f \uae30\ud0c0 \uba85\ub839\uc5b4)
\n   2)The pubs2 database \uc0dd\uc131
\n      %isql -Usa -P < $SYBASE\/scripts\/installpubs2
\n      \/* installpubs2\ub294 pubs2 db\ub97c \uc0dd\uc131\ud558\uae30 \uc704\ud55c script\uc774\uba70,
\n         pubs2\uac00 \uc788\uc744 \uacbd\uc6b0\uc5d0\ub294 \uc0dd\uc131\ud558\uc9c0 \ub9d0 \uac83.(isql\uc0c1\uc5d0\uc11c sp_helpdb\ub85c \ud655\uc778)
\n   3)The pubs2 database query set
\n      %isql -Usa -P (sa\ub85c login) – \uc774\ud558 \uc0dd\ub7b5
\n      1>select db_name() \/* \uc0ac\uc6a9\uc911\uc778 db \ud655\uc778 *\/
\n      2>go
\n      1>user pubs2
\n      2>go
\n      1>select * from titles
\n      2>go
\n      1>vi
\n      select * from titles
\n      ~
\n      :wq query \/* OS file\ub85c query\uc800\uc7a5 *\/
\n      1>:r query \/* OS file\ub85c\ubd80\ud130 isql\ub85c query\ub97c read *\/
\n      2>go \/* \ub610\ub294 vi editor\ub97c call\ud558\uc5ec edit\ud6c4 save\ud558\uace0 \uc218\ud589 *\/
\n      4)Query\ub97c OS File\ub85c \uc791\uc131\ud558\uc5ec \uacb0\uacfc\ub97c OS File\ub85c \ubc1b\uc544\ubcf4\uae30 \uc704\ud55c \ubc29\ubc95
\n      %vi
\n      user pubs2
\n      go
\n      select * from titles
\n      go
\n      :wq query
\n      %isql -Usa -P <query> query.out \/* vi query.out\ub85c \uacb0\uacfc \ud655\uc778 *\/<\/p>\n

7.Devicee\ub4f1\ub85d \ubc0f Drop
\n\uc774\ub294 SQL Server\uac00 Device\ub97c \uc778\uc2dd\ud558\uace0 \uadf8 Device\uc5d0 db\ub97c \uc0dd\uc131\ud560 \uc218 \uc788\ub3c4\ub85d Device initialize\ub97c \ud558\uc5ec Server\uc5d0 Device\ub97c \ub4f1\ub85d\ud574 \uc8fc\ub294 \uacfc\uc815\uc784.
\n   1) Device\uc704\uce58 \uc120\uc815
\n      %su root(root account\ub85c\ubcc0\ud658 \ubc0f passward\uc785\ub825)
\n      # cd\/user(\/user directory\uc5d0 deice \ub97c \uc0dd\uc131\ud558\uace0\uc790 \ud560 \uacbd\uc6b0)
\n      #mkdir test-dev
\n      # chwon sybase test-dv(ownership\ubcc0\uacbd \ub610\ub294 sybase writable)
\n        \/*sybase\ub85clogin\ud558\uc5ec\u201dHOME\u201d\ubc11\uc5d0 \uc0dd\uc131\uc2dc ownership\ubcc0\uacbd \ud544\uc694\uc5c6\uc74c*\/
\n      # exit
\n   2) isql\ub85c server\uc5d0 login
\n      1> disk init
\n      2> name=\u201ddata_dev\u201d,(log_dev\u201d,)
\n      3> physname=\u201dusr\/test_dev\/data_dev,\u201d\u201dlog_dev\u201d,)
\n      4> vdevno=1,(2,)
\n         \/* default : 1-9, \ucd5c\ub300 255, 0\uc740 master device\ub85creserved *\/
\n         \/* device\ub4f1\ub85d\uc744 \uc2e4\ud328\ud560 \ub54c\uc5d0\ub294 \ub2e4\ub978 vdevno\ub97c \ubd80\uc5ec\ud558\uac70\ub098, \uadf8 \ubc88\ud638\ub97c \uc7ac\uc0ac\uc6a9\uc2dc\ub294
\n           server restaret *\/
\n      5> size = 5120(1024)
\n         \/* size\ub294 page\ub2e8\uc704\uc774\uba70, \ub2e8\uc704\ub294 10MB \uc758 device\uc784 *\/
\n         \/* size =512 *MB\ub2e8\uc704 size *\/
\n      6>    go
\n       \/* ()\uc548\uc740 log device\uc5d0 \ub300\ud55c disk init \uc774\uba70, \ubcc4\ub3c4\ub85c disk init \ud558\uc5ec \ub4f1\ub85d *\/
\n       \/* master device\ubc0f device\ub294 raw partition\uc73c\ub85c\ub3c4 \uc9c0\uc815\uac00\ub2a5 *\/
\n      1>  sp_helpdevice-disk init \ud6c4 device\ub4f1\ub85d\ud655\uc778
\n      2>  go
\n      1> sp_dropdevice data_dev(log_dev)
\n      2> go
\n      1>  quit
\n      \/*device\uc5d0 database\uac00 \uc874\uc7ac\ud560 \uacbd\uc6b0 drop\ub418\uc9c0 \uc54a\uc74c- \uba3c\uc800 db drop *\/
\n      % rm data_dev(log_dev)
\n          \/*server\ub0b4\uc5d0\uc11c drop\ud55c \ub2e4\uc74c os\uc5d0 \ud574\ub2f9 file\uc744 \uc9c0\uc6c0 *\/<\/p>\n

8. Database\uc0dd\uc131 \ubc0f Drop
\nDisk init\ub97c \ud558\uc5ec server\uc5d0 \ub4f1\ub85d\ub41c Device \uc5d0 \uc0c8\ub85c\uc6b4 Database \uc0dd\uc131
\n   1> create database mydb on data_dev =5 log on log _dev
\n   2>  go
\n   \/*\uc704 \uc608\uc81c\ub294 data_dev\uc5d0 data\ub97c, og dev \uc5d0 log \ub97c \ub2f4\ub294 db \uc0dd\uc131\ud558\ub294 \uc608\uc81c
\n   device\ub4f1\ub85d\uc2dc\uc5d0\ub294 page\ub2e8\uc704\uc774\uc9c0\ub9cc, db\uc0dd\uc131\uc2dc\uc5d0\ub294 MB\ub2e8\uc704\uc784
\n   \ub0a8\uc544\uc788\ub294 device \uc5ec\ubd84\uc740 mydb \uc758 \ud655\uc7a5 \ubc0f \ud0c0 db\uc758 device\ub85c \uc0ac\uc6a9
\n   log size \ub294 update\ube48\ub3c4\uc5d0 \ub530\ub77c \ub2e4\ub974\uc9c0\ub9cc log device\ub97c \ubcc4\ub3c4\ub85c \uc9c0\uc815\ud558\uc9c0 \uc54a\uc73c\uba74
\n   db\uc0dd\uc131 device\uc5d0 log devie\uc0dd\uc131
\n   database \uc0dd\uc131\uc2dc deice \ub97c \uc0dd\ub7b5\ud558\uba74 master device(default device)\uc5d0 \uc0dd\uc131<\/p>\n

  1>  sp_helpdb \/*mydb\uc0dd\uc131 \ud655\uc778 \ubc0f database list *\/
\n   2>  go
\n   1>  drop data  mydb  \/*  database drop *\/
\n   2>  go<\/p>\n

9. database \uc5d0 \ub300\ud55c ownership\ubcc0\uacbd
\n   1> use mydb  \/* database open , \uc774\ud558 \uc0dd\ub7b5 *\/
\n   2> go
\n   1> sp_changedbowner  dully
\n   2> go
\n     \/* \ud574\ub2f9 db  user \uc774\uba74 ownership\uc774 \ubcc0\uacbd\ub418\uc9c0 \uc54a\uace0,  sp_dropuser \ud6c4 ownership \ubcc0\uacbd*\/<\/p>\n

10. Database \ud655\uc7a5
\nDatabase\uc758 \uc6a9\ub7c9\uc744 \ud655\uc7a5\ud560 \uacbd\uc6b0\uc5d0\ub294 \uae30\uc874 \ub4f1\ub85d\ub41c device \ubc0f disk init\uc5d0 \uc758\ud574 \uc0c8\ub85c \ub4f1\ub85d\ub41c device\uc5d0 database\ub97c \ud655\uc7a5\ud55c\ub2e4.
\n   1> alter  database  mydb  on  data _dev = 3
\n   2> go<\/p>\n

11. Object-Nameing  Convention
\n   1)  Objcet  Name
\n      (1) Table, default, Procedure\ub4f1 \ubaa8\ub450 \ud574\ub2f9\ub428
\n      (2) \ub300 \uc18c\ubb38\uc744 \uad6c\ubd84\ud558\uc5ec, \ucd5c\ub300 30characters
\n      (3) Object name identify ? db, owber, table (puds2. Friend)-dbo\uc77c \uacbd\uc6b0 \uc0dd\ub7b5\uac00\ub2a5
\n   2) Transact ? SQL
\n      (1) \ub300 \uc18c\ubb38\uc790 \uad6c\ubd84 \uc5c6\uc74c(select  or  SELECT)
\n      (2) \ucd95\uc57d\ud615\uac00\ub2a5(procedure:proc, execute: exec, transaction: tran \ub4f1)
\n   3) \ud0c0 DB\uc640  Join
\n      1>  select  a.name, b.amount from friend a, pubs … charg b
\n      2> where a.id = b.id
\n      3> go
\n   4) Object \uc885\ub958 – Table, View, Index, Default, Rule, Procedure, Trigger\ub4f1\uc774 \uc788\uc74c<\/p>\n

<\/span><\/font><\/p>\n

* START UP<\/font><\/p>\n

\n<\/p>\n\n\n\n
\n\n\n\n\n
\n

Oracle<\/font><\/p>\n<\/td>\n

\n

Sybase<\/font><\/p>\n<\/td>\n<\/tr>\n

\n

%su – oracle
password:
%svrmgrl
SVRMGR>connect internal
SVRMGR>startup
SVRMGR>exit
%lsnrctl start<\/font><\/p>\n<\/td>\n

\n

%su – sybase
password:
%cd install
%startserver -f RUN_SYBASE
%startserver -f RUN_SYS_BAKUP
\u203bRUN_SYBASE, RUN_SYB_BACKUP\ub294 Server name\uc774\ubbc0\ub85c \ud655\uc778<\/font><\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

* SHUTDOWN<\/font><\/p>\n

 <\/font><\/p>\n<\/p>\n\n\n\n
\n\n\n\n\n
\n

Oracle<\/font><\/p>\n<\/td>\n

\n

Sybase<\/font><\/p>\n<\/td>\n<\/tr>\n

\n

%su – oracle
password:
%svrmgrl
SVRMGR>connect internal
SVRMGR>shutdown
SVRMGR>exit
%lsnrctl stop<\/font><\/p>\n<\/td>\n

\n

%su – sybase
password:
%cd install
%isql -Usa -P
1>shutdown SYB_BACKUP
2>go
1>shutdown
<\/font><\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

 <\/font><\/p>\n

* CREATE DATABASE<\/font><\/p>\n


<\/font><\/p>\n<\/p>\n\n\n\n
\n\n\n\n\n
\n

Oracle<\/font><\/p>\n<\/td>\n

\n

Sybase<\/font><\/p>\n<\/td>\n<\/tr>\n

\n

%sqlplus system\/manager
SQL>create tablespace mpts\/datafile ‘\/data1\/mpdb\/mp.dbf’ size 100
default storage(
initial 64K
next 64K
pctincrease 0
minextents 2
);
Tablespace create.<\/p>\n

SQL>create tablespace mptmpts\/datafiile ‘\/data1\/mpdb\/mp.dbf’ size 20M
deault storage(
initial 64K
next 64K
pctincrease 0
minextents 2
);
Tablespace create.<\/p>\n

SQL>create user medpack
2 indetified by medpack000
3 default tablesapce mpts
4 temporary tablespace mptmpts
5 quota unlimited on mpts
6 quota unlimited on mptmpts;
User create.<\/p>\n

SQL>grant connect, resource to medpack;
Grant Succeede.<\/p>\n

\u203b \uc704 \uc608\uc81c\ub294 mpts, mptmpts\ub77c\ub294 tablespace\ub97c \ub9cc\ub4e4\uace0 medpack\uc774\ub77c\ub294 User\ub97c \uc0dd\uc131\ud55c\ub2e4.
  mpts\uc640 mptmpts\uc758 \ube44\uc728\uc740 8:2\ube44\uc728\uc774 \uc801\ub2f9\ud558\uace0 User\uc0dd\uc131\uc2dc default tablespace\uc640 temporary tablespace\ub97c \uc9c0\uc815\ud574 \uc900\ub2e4.
\uadf8\ub7f0\ud6c4\uc5d0 connect\uc640 resource\ub77c\ub294 rule\uc744 User\uc5d0\uac8c \ud5c8\uc6a9\ud574 \uc900\ub2e4.<\/p>\n

\uc804\uccb4\uc801\uc778 \uc21c\uc11c\ub294
1)2\uac1c\uc758 Tablespace\uc0dd\uc131
2)User\uc0dd\uc131
3)User\uc5d0\uac8c rule\ud5c8\uc6a9
\uacfc \uac19\ub2e4.<\/p>\n

 <\/font><\/p>\n<\/td>\n

\n

%isql -Usa -P
1>disk init
2>name = ‘mp_dev’,
3>physname = “\/data1\/mpdv\/mp.dev”,
4>vdevno = 2,
5>size = 51200(page\ub2e8\uc704)
6>go<\/p>\n

1>disk init
2>name = “mplog_dev”,
3>physname = “\/data1\/mpdb\/mp.log.dev”,
4>vdevno = 3,
5>size = 10240
6>go<\/p>\n

\u203b100MB\ub97c \ud560\ub2f9\ud558\ub824\uba74 100 * 512 = 51200\uc758 \uac12\uc744 \uc0ac\uc6a9\ud55c\ub2e4.<\/p>\n

1>create database mepackdb
2>on mp_dev = 100(Mega\ub2e8\uc704)
3>log on mplog_dev = 20
4>go<\/p>\n

CREATE DATABASE: allocating 51200 pages…
CREATE DATABASE: allocating10240 pages…<\/p>\n

1>sp_addlogin medpack, medpack000 medpackdb
2>go<\/p>\n

Password correctly set.
Account unlocked.
New login created.
(return status = 0)<\/p>\n

1>use medpackdb
2>go<\/p>\n

1>sp_changedbowner medpack
2>go<\/p>\n

Database owner changed.
(return status = 0)<\/p>\n

\u203b
\n \uc704\uc758 \uc608\uc81c\ub294 mp_dev, mplog_dev\ub77c\ub294 2\uac1c\uc758 device\ub97c \ub9cc\ub4e4\uace0 medpackdb\ub97c \ub9cc\ub4e0\ub2e4. \uadf8\ub7f0\ud6c4\uc5d0
\nmedpack\uc774\ub77c\ub294 User\ub97c \ub9cc\ub4e4\uc5b4 medpackdb\ub97c \uae30\ubcf8db\ub85c \uc124\uc815\ud55c\ub2e4. \uadf8\ub9ac\uace0 \ub098\uc11c medpack\uc758 \uc18c\uc720\uad8c\uc744
\nmedpack\uc73c\ub85c \ubc14\uafb8\uc5b4 \uc900\ub2e4.<\/p>\n

\uc804\uccb4\uc801\uc778 \uc21c\uc11c\ub294
1)2\uac1c\uc758 device \uc0dd\uc131
2)db\uc0dd\uc131
3)User\uc0dd\uc131
4)db\uc758 \uc18c\uc720\uad8c \ubcc0\uacbd
\uacfc \uac19\ub2e4. <\/font><\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

 <\/font><\/p>\n

* DROP DATABASE
<\/font><\/p>\n<\/p>\n\n\n\n
\n\n\n\n\n
\n

Oracle<\/font><\/p>\n<\/td>\n

\n

Sybase<\/font><\/p>\n<\/td>\n<\/tr>\n

\n

%sqlplus system\/manager
SQL>drop user medpack cascade;<\/p>\n

User dropped<\/p>\n

SQL>drop tabelspace mpts
2 including contents
3 cascade contraints;<\/p>\n

Tablespace dropped<\/p>\n

SQL>exit<\/p>\n

\u203b\uadf8\ub7f0\ud6c4\uc5d0 \uc2e4\uc81c data file\ub97c \uc0ad\uc81c\ud55c\ub2e4.<\/p>\n

\u203b\uc704 \uc608\uc81c\ub294 medpack\uc774\ub77c\ub294 User\uc640 \uadf8 User\uc5d0\uac8c \ud560\ub2f9\ub41c tablespace\ub97c \uc0ad\uc81c\ud55c\ub2e4.
 \uc804\uccb4\uc801\uc778 \uc21c\uc11c\ub294
 1)\uba3c\uc800 User\ub97c \uc0ad\uc81c(Drop)
 2)2\uac1c\uc758 tablespace\ub97c \uc0ad\uc81c(Drop)
 3)File System\uc5d0 \uc788\ub294 File\ub4e4\uc744 \uc0ad\uc81c
\uc640 \uac19\ub2e4.
 
\u203bOracle\uc5d0\uc11c\ub294 \uc0ac\uc2e4\uc0c1 database\ub294 \ud558\ub098\ub9cc \uc874\uc7ac\ud55c\ub2e4. \uac01\uac01\uc758 User\ub4e4\uc740 tablespace\ub97c \ud560\ub2f9\ubc1b\uc544 \uc2e4\uc81c\uc758 data\ub97c \uc800\uc7a5\ud55c\ub2e4.
\ub530\ub77c\uc11c, User Space\uc758 \uc99d\uac00\ub294 tablespace\ub97c \ub298\ub824\uc8fc\uba74 \uac00\ub2a5\ud558\ub2e4.
(Ref, alter tablesapce….)<\/font><\/p>\n<\/td>\n

\n

%isql -Usa -P
1>drop database medpackdb
2>go<\/p>\n

1>sp_dropdevice mp_dev
2>go<\/p>\n

Device dropped.
(return status = 0)<\/p>\n

\u203b\uc704 \uc608\uc81c\ub294 medpackdb\uc774\ub77c\ub294 \uc774\ub984\uc758 database\ub97c \uc0ad\uc81c\ud558\uace0 database\uac00 \uc0ac\uc6a9\ud558\uace0 \uc788\ub358 device\ub97c \uc0ad\uc81c\ud55c\ub2e4. \uadf8\ub9ac\uace0 \ub098\uc11c User\ub97c \uc0ad\uc81c\ud55c\ub2e4.
 \uc804\uccb4\uc801\uc778 \uc21c\uc11c\ub294
 1)database \uc0ad\uc81c
 2)2\uac1c\uc758 device\uc0ad\uc81c
 3)User\uc0ad\uc81c
 4)File System\uc5d0 \uc788\ub294 File\ub4e4\uc744 \uc0ad\uc81c
\uc640 \uac19\ub2e4<\/p>\n

\u203bSybase\uc5d0\uc11c\ub294 device\uc5d0\uc11c \uc77c\uc815\ud55c \uc591\uc758 space\ub97c \ud560\ub2f9\ubc1b\uc544 database\ub97c \ub9cc\ub4e0\ub2e4.
device\ub97c \ub9cc\ub4e4 \ub54c \ubc88\ud638\ub97c \uc801\ub2f9\ud558\uac8c \uc9c0\uc815\ud574 \uc8fc\uc5b4\uc57c \ud558\ub294\ub370, sp_helpdevice\ub77c\ub294 system procedure\ub97c \uc774\uc6a9\ud55c\ub2e4.<\/p>\n

 <\/font><\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

—————————————————————————————————————————————————————————-
\ucd9c\ucc98 : http:\/\/www.digipine.com\/?mid=programming&listStyle=gallery&sort_index=readed_count&order_type=desc&document_srl=218<\/a><\/p>\n

<\/p>\n","protected":false},"excerpt":{"rendered":"

SYBASE \uc0ac\uc6a9\ubc95(\uc694\uc57d) SYBASE home directory\ub294 \/home\/sybase\ub85c \uac00\uc815\ud558\uba70, \uc774\ud558 ‘HOME’\uc774\ub77c \ud569\ub2c8\ub2e4. 1.User System Account\ub4f1\ub85d   1)User Account\uc0dd\uc131(System\uc758 User\ub4f1\ub85d\ubc29\ubc95\uc5d0 \ub530\ub77c)      Login as root – System Booting\ud6c4 Root\uc640 Password \uc785\ub825)      Ex) #vi \/etc\/passwd\/      Format] username:password:UID:GID:comment:user home directory:shell … Continue reading →<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[17],"tags":[142,369],"_links":{"self":[{"href":"http:\/\/pchero21.com\/index.php?rest_route=\/wp\/v2\/posts\/990"}],"collection":[{"href":"http:\/\/pchero21.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/pchero21.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/pchero21.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/pchero21.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=990"}],"version-history":[{"count":1,"href":"http:\/\/pchero21.com\/index.php?rest_route=\/wp\/v2\/posts\/990\/revisions"}],"predecessor-version":[{"id":3933,"href":"http:\/\/pchero21.com\/index.php?rest_route=\/wp\/v2\/posts\/990\/revisions\/3933"}],"wp:attachment":[{"href":"http:\/\/pchero21.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=990"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/pchero21.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=990"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/pchero21.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=990"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}