Dropping a member

字数 24067阅读 1115评论 0赞 0

[PS continued] Reference: <a href="http://www-01.ibm.com/support/knowledgecenter/SSEPGG_10.5.0/com.ibm.db2.luw.qb.server.doc/doc/t0056036.html" target="_blank" target="_blank">http://www-01.ibm.com/support/knowledgecenter/SSEPGG_10.5.0/com.ibm.db2.luw.qb.server.doc/doc/t0056036.html</a>In this example, I will drop member s2 from my PS cluster.[root@s1 ~]# su - i1[i1@s1 ~]$ db2instance -listID        TYPE             STATE                HOME_HOST               CURRENT_HOST            ALERT   PARTITION_NUMBER        LOGICAL_PORT    NETNAME--        ----             -----                ---------               ------------            -----   ----------------        ------------    -------0       MEMBER           STARTED                       s1                         s1               NO                  0                   0         s11       MEMBER           STARTED                       s2                         s2               NO                  0                   0         s2128     CF               PRIMARY                       s0                         s0               NO                  -                   0         s0HOSTNAME                   STATE                INSTANCE_STOPPED        ALERT--------                   -----                ----------------        -----      s0                  ACTIVE                              NO           NO      s2                  ACTIVE                              NO           NO      s1                  ACTIVE                              NO           NO[i1@s1 ~]$ db2stop force03/25/2015 18:42:33     1   0   SQL1064N  DB2STOP processing was successful.03/25/2015 18:42:40     0   0   SQL1064N  DB2STOP processing was successful.SQL1064N  DB2STOP processing was successful.[i1@s1 ~]$ exitlogout[root@s1 ~]# db2iupdt -drop -m s2 i1DBI1446I  The db2iupdt command is running.DB2 installation is being initialized. Total number of tasks to be performed: 3 Total estimated time for all tasks to be performed: 310 second(s) Task #1 startDescription: Initializing instance list Estimated time 5 second(s) Task #1 end Task #2 startDescription: Initiating the remote host list Estimated time 5 second(s) Task #2 end Task #3 startDescription: Configuring DB2 instances Estimated time 300 second(s) Task #3 end The execution completed successfully.For more information see the DB2 installation log at "/tmp/db2iupdt.log.16861".DBI1070I  Program db2iupdt completed successfully.-- Verify the cluster [root@s1 ~]# su - i1[i1@s1 ~]$ db2start03/25/2015 19:07:40     0   0   SQL1063N  DB2START processing was successful.SQL1063N  DB2START processing was successful.[i1@s1 ~]$ db2instance -listID        TYPE             STATE                HOME_HOST               CURRENT_HOST            ALERT   PARTITION_NUMBER        LOGICAL_PORT    NETNAME--        ----             -----                ---------               ------------            -----   ----------------        ------------    -------0       MEMBER           STARTED                       s1                         s1               NO                  0                   0         s1128     CF               PRIMARY                       s0                         s0               NO                  -                   0         s0HOSTNAME                   STATE                INSTANCE_STOPPED        ALERT--------                   -----                ----------------        -----      s0                  ACTIVE                              NO           NO      s1                  ACTIVE                              NO           NO[i1@s1 ~]$ db2 connect to sample   Database Connection Information Database server        = DB2/LINUXX8664 10.5.5 SQL authorization ID   = I1 Local database alias   = SAMPLE[i1@s1 ~]$ db2 list tablesTable/View                      Schema          Type  Creation time             ------------------------------- --------------- ----- --------------------------ACT                             I1              T     2015-03-21-23.28.57.308325ADEFUSR                         I1              S     2015-03-21-23.29.01.086494CATALOG                         I1              T     2015-03-21-23.29.04.535381CL_SCHED                        I1              T     2015-03-21-23.28.53.953651CUSTOMER                        I1              T     2015-03-21-23.29.03.659451DEPARTMENT                      I1              T     2015-03-21-23.28.54.525943DEPT                            I1              A     2015-03-21-23.28.55.160876EMP                             I1              A     2015-03-21-23.28.55.702909EMPACT                          I1              A     2015-03-21-23.28.57.293864EMPLOYEE                        I1              T     2015-03-21-23.28.55.163900EMPPROJACT                      I1              T     2015-03-21-23.28.57.170356EMP_ACT                         I1              A     2015-03-21-23.28.57.301658EMP_PHOTO                       I1              T     2015-03-21-23.28.55.705102EMP_RESUME                      I1              T     2015-03-21-23.28.56.239070INVENTORY                       I1              T     2015-03-21-23.29.03.447870IN_TRAY                         I1              T     2015-03-21-23.28.57.605126ORG                             I1              T     2015-03-21-23.28.57.757312PRODUCT                         I1              T     2015-03-21-23.29.02.956125PRODUCTSUPPLIER                 I1              T     2015-03-21-23.29.05.358596PROJ                            I1              A     2015-03-21-23.28.56.901656PROJACT                         I1              T     2015-03-21-23.28.56.904004PROJECT                         I1              T     2015-03-21-23.28.56.591647PURCHASEORDER                   I1              T     2015-03-21-23.29.04.141621SALES                           I1              T     2015-03-21-23.28.58.006396STAFF                           I1              T     2015-03-21-23.28.57.909730STAFFG                          I1              T     2015-03-21-23.28.59.801279SUPPLIERS                       I1              T     2015-03-21-23.29.04.971348VACT                            I1              V     2015-03-21-23.28.58.272456VASTRDE1                        I1              V     2015-03-21-23.28.58.375935VASTRDE2                        I1              V     2015-03-21-23.28.58.382023VDEPMG1                         I1              V     2015-03-21-23.28.58.350577VDEPT                           I1              V     2015-03-21-23.28.58.100862VEMP                            I1              V     2015-03-21-23.28.58.261588VEMPDPT1                        I1              V     2015-03-21-23.28.58.359285VEMPLP                          I1              V     2015-03-21-23.28.58.490141VEMPPROJACT                     I1              V     2015-03-21-23.28.58.344298VFORPLA                         I1              V     2015-03-21-23.28.58.426056VHDEPT                          I1              V     2015-03-21-23.28.58.255947VPHONE                          I1              V     2015-03-21-23.28.58.471965VPROJ                           I1              V     2015-03-21-23.28.58.266906VPROJACT                        I1              V     2015-03-21-23.28.58.279705VPROJRE1                        I1              V     2015-03-21-23.28.58.398905VPSTRDE1                        I1              V     2015-03-21-23.28.58.406748VPSTRDE2                        I1              V     2015-03-21-23.28.58.413071VSTAFAC1                        I1              V     2015-03-21-23.28.58.438264VSTAFAC2                        I1              V     2015-03-21-23.28.58.443939  46 record(s) selected.

数据库 Db2 pureScale

著作权归作者所有

如果觉得我的文章对您有用，请点赞。您的支持将鼓励我继续创作！

添加新评论0 条评论

Ctrl+Enter 发表

匿名评论

Dropping a member

添加新评论0 条评论

作者其他文章

相关文章

相关问题

相关资料