Mas DB2 Notes

Friday, July 4, 2014

Another set of create database command for reference

CREATE DATABASE dmdb USING CODESET UTF-8 TERRITORY US PAGESIZE 32 k

connect to dmdb

create regular tablespace datamart pagesize 32k

GRANT USE OF TABLESPACE datamart TO USER datamart WITH GRANT OPTION

REVOKE USE OF TABLESPACE USERSPACE1 FROM PUBLIC
Posted by pikachu at 1:41 AM
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest

No comments:

Post a Comment

Newer Post Older Post Home
Subscribe to: Post Comments (Atom)

Blog Archive

  • ►  2025 (1)
    • ►  March (1)
  • ►  2024 (7)
    • ►  November (1)
    • ►  October (3)
    • ►  July (2)
    • ►  March (1)
  • ►  2023 (1)
    • ►  January (1)
  • ►  2021 (23)
    • ►  November (11)
    • ►  September (4)
    • ►  June (2)
    • ►  May (2)
    • ►  April (4)
  • ►  2020 (8)
    • ►  December (8)
  • ►  2018 (1)
    • ►  March (1)
  • ►  2016 (1)
    • ►  October (1)
  • ►  2015 (3)
    • ►  September (3)
  • ▼  2014 (15)
    • ►  December (4)
    • ▼  July (11)
      • Migrating Lotus Notes to a new laptop (or image)
      • Useful links on using DB2MOVE
      • Grant DBADM Privilege
      • Using DB2MOVE to move schema1 to schema2 on anothe...
      • DB2 Instance
      • Configuring DB2 with TCPIP
      • db2 dbm cfg
      • Checking for DB2SET values
      • SQL to find out DB2 Instance Name
      • Another set of create database command for reference
      • Script to drop disconnect and drop DB2 database
  • ►  2013 (17)
    • ►  November (4)
    • ►  October (5)
    • ►  July (8)

About Me

My photo
pikachu
View my complete profile
Awesome Inc. theme. Powered by Blogger.