API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Mar 9th, 2018
131
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.94 KB | None | 0 0
raw download clone embed print report
  1. CNKE4ML, CNKE2ML, CNA8LML, CND1AML, CND1DML, CND1EML, CND1FML, CND0ZML, CND18ML, CIY9SML, CNKF6ML, CNB21ML, CNB8FML, CNF8IML
  2.  
  3. Instalar DB2
  4. # su db2inst1
  5. # db2set DB2_COMPATIBILITY_VECTOR=ORA
  6. # db2set DB2_DEFERRED_PREPARE_SEMANTICS=YES
  7. # db2 create database tririga PAGESIZE 32 K
  8. # db2 update db cfg for tririga using STMT_CONC OFF DEFERRED
  9. # useradd -g db2iadm1 tridata
  10. # echo "tridata:tridata" | chpasswd
  11. # db2 connect to tririga
  12. # db2 GRANT CONNECT ON DATABASE TO USER tririga
  13. # db2 GRANT CONNECT ON DATABASE TO USER tridata
  14. # db2 GRANT DBADM ON DATABASE TO USER tridata
  15. # db2 GRANT SECADM ON DATABASE TO USER tridata
  16. # db2 GRANT ACCESSCTRL ON DATABASE TO USER tridata
  17. # db2 GRANT DATAACCESS ON DATABASE TO USER tridata
  18. # db2 TERMINATE
  19. # db2 update db cfg for tririga using STRING_UNITS CODEUNITS32
  20. # db2stop force
  21. # db2start
  22.  
  23.  
  24. ip-172-31-20-110
  25.  
  26. # su db2inst1
  27. # db2set DB2_COMPATIBILITY_VECTOR=ORA
  28. # db2set DB2_DEFERRED_PREPARE_SEMANTICS=YES
  29. # db2 create db tririga3 PAGESIZE 32 K
  30. # db2 update db cfg for tririga3 using STMT_CONC OFF DEFERRED
  31. # useradd -g dasadm1 tridata3
  32. # echo "tridata3:tridata3" | chpasswd
  33. # db2 connect to tririga3 --- AQUI
  34.  
  35. * db2 CONNECT TO tririga3 user tridata3 using tridata3
  36. * db2 GRANT DBADM, CREATETAB, BINDADD, CONNECT, CREATE_NOT_FENCED, IMPLICIT_SCHEMA, LOAD ON DATABASE TO USER tridata3
  37.  
  38. # db2 GRANT CONNECT ON DATABASE TO USER tririga3
  39. # db2 GRANT CONNECT ON DATABASE TO USER tridata3
  40. # db2 GRANT DBADM ON DATABASE TO USER tridata3
  41. # db2 GRANT SECADM ON DATABASE TO USER tridata3
  42. # db2 GRANT ACCESSCTRL ON DATABASE TO USER tridata3
  43. # db2 GRANT DATAACCESS ON DATABASE TO USER tridata3
  44. # db2 TERMINATE
  45. # db2 update db cfg for tririga3 using STRING_UNITS CODEUNITS32
  46. # db2stop force
  47. # db2start
  48.  
  49.  
  50. Database Connection Information
  51.  
  52. Database server = DB2/LINUXX8664 11.1.0
  53. SQL authorization ID = DB2INST1
  54. Local database alias = TRIRIGA1
  55.  
  56.  
  57. Configuracoes Tririga
  58. Server name is:server1
  59. Profile name is:AppSrv01
  60. Profile home is:/opt/IBM/WebSphere/AppServer/profiles/AppSrv01
  61. Profile type is:default
  62. Cell name is:ip-172-31-20-110Node01Cell
  63. Node name is:ip-172-31-20-110Node01
  64. Current encoding is:ANSI_X3.4-1968
  65. Start running the following command:/opt/IBM/WebSphere/AppServer/profiles/AppSrv01/bin/startServer.sh server1 -profileName AppSrv01
  66. >ADMU0116I: Tool information is being logged in file
  67. > /opt/IBM/WebSphere/AppServer/profiles/AppSrv01/logs/server1/startServer.log
  68. >ADMU0128I: Starting tool with the AppSrv01 profile
  69. >ADMU3100I: Reading configuration for server: server1
  70. >ADMU3200I: Server launched. Waiting for initialization status.
  71.  
  72. Frontend Trriga
  73. ip-172-31-20-110
  74.  
  75.  
  76.  
  77. DBS NEW
  78. USer: dasusr2
  79. Pass: dasusr2
  80. Group: dasadm1
  81.  
  82. db2inst2
  83. db2inst2
  84. db2iadm1
  85.  
  86. db2fenc2
  87. db2fenc2
  88. db2fadm1
  89.  
  90. db2c_db2inst2
  91. 50009
  92.  
  93. db2j_db2inst2
  94. 55001
  95.  
  96. Resume:
  97. Install Location:/opt/ibm/db2/V11.1
  98. Instance Name:db2inst2
  99. DAS Username:dasusr2
  100. Fenced User Name:db2fenc2
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!