Tuesday, June 17, 2014

DB2 Tablespace and storage group

db2 => values current server

1
------------------
ARUNDB2

  1 record(s) selected.

db2 =>


db2 => create regular tablespace tsp01 managed by database using (file 'tsp01' 256) extentsize 4 autoresize yes
DB20000I  The SQL command completed successfully.
db2 =>


db2 => create regular tablespace tsp02 managed by database using (file 'tsp02' 128) extentsize 2 autoresize yes maxsize 2M
DB20000I  The SQL command completed successfully.
db2 =>


db2 => create tablespace tsp03 managed by database using (file 'tsp03' 1024) extentsize 8 autoresize yes maxsize 10m
DB20000I  The SQL command completed successfully.
db2 =>

db2 => create stogroup app_data on '/home/db2inst2'
DB20000I  The SQL command completed successfully.
db2 =>

db2 => create tablespace tsp04  managed by automatic storage using stogroup app_data initialsize 100 k maxsize none extentsize 2
DB20000I  The SQL command completed successfully.
db2 =>



db2 => create tablespace tsp05 managed by automatic storage using stogroup app_data initialsize 100 k maxsize none extentsize 2
DB20000I  The SQL command completed successfully.
db2 =>


db2 => create regular tablespace tsp06 extentsize 4
DB20000I  The SQL command completed successfully.
db2 =>


db2 => create regular tablespace sms01 managed by system using ('sms/sms01') extentsize 4
DB20000I  The SQL command completed successfully.
db2 =>

Posted by at

22 comments:

  1. sathya shriSeptember 4, 2018 at 12:59 AM

    This comment has been removed by the author.

    ReplyDelete
  2. pragyachitraSeptember 27, 2018 at 3:16 AM

    Thank you for benefiting from time to focus on this kind of, I feel firmly about it and also really like comprehending far more with this particular subject matter. In case doable, when you get know-how, is it possible to thoughts modernizing your site together with far more details? It’s extremely useful to me

    angularjs Training in bangalore

    angularjs Training in btm

    angularjs Training in electronic-city

    angularjs Training in online

    angularjs Training in marathahalli

    ReplyDelete
  3. UnknownOctober 8, 2018 at 11:59 PM

    Hello I am so delighted I found your blog, I really found you by mistake, while I was looking on Yahoo for something else, anyways I am here now and would just like to say thanks for a tremendous post. Please do keep up the great work.
    Data Science training in Chennai | Data science training in bangalore
    Data science training in pune| Data science online training
    Python training in Kalyan nagar

    ReplyDelete
  4. jananiOctober 9, 2018 at 12:40 AM

    Thanks for taking the time to discuss this, I feel strongly about it and love learning more on this topic.
    java training in omr | oracle training in chennai

    java training in annanagar | java training in chennai

    ReplyDelete
  5. UnknownOctober 9, 2018 at 10:35 PM

    Excellant post!!!. The strategy you have posted on this technology helped me to get into the next level and had lot of information in it.
    online Python certification course | python training in OMR | python training course in chennai

    ReplyDelete
  6. saiOctober 13, 2018 at 7:28 AM

    After reading this web site I am very satisfied simply because this site is providing comprehensive knowledge for you to audience. Thank you to the perform as well as discuss anything incredibly important in my opinion. We loose time waiting for your next article writing in addition to I beg one to get back to pay a visit to our website in
    python training Course in chennai | python training in Bangalore | Python training institute in kalyan nagar

    ReplyDelete
  7. UnknownOctober 16, 2018 at 11:30 PM

    Nice post,Thanks for sharing for more information about oracle DBA.check it once at
    aws online training
    aws training in hyderabad
    aws online training in hyderabad

    ReplyDelete
  8. simbuOctober 18, 2018 at 10:22 PM

    Read all the information that i've given in above article. It'll give u the whole idea about it.
    Java training in Tambaram | Java training in Velachery

    Java training in Omr | Oracle training in Chennai

    ReplyDelete
  9. UnknownOctober 18, 2018 at 10:53 PM

    I appreciate your efforts because it conveys the message of what you are trying to say. It's a great skill to make even the person who doesn't know about the subject could able to understand the subject . Your blogs are understandable and also elaborately described. I hope to read more and more interesting articles from your blog. All the best.

    Data Science Training in Indira nagar | Data Science Training in btmlayout

    Python Training in Kalyan nagar | Data Science training in Indira nagar

    Data Science Training in Marathahalli | Data Science Training in BTM Layout

    ReplyDelete
  10. Sumaya ManzoorDecember 15, 2018 at 1:47 AM

    Very informative!! Thanks for sharing with us.

    selenium testing training in chennai
    best selenium training center in chennai
    Big Data Training in Chennai
    best ios training in chennai
    java class
    java training center in chennai
    java coaching center in chennai

    ReplyDelete
  11. Anjali SivaDecember 26, 2018 at 4:23 AM

    I have thank for sharing this blog, really helpful.
    DevOps Training in Chennai
    DevOps course in Chennai
    AWS Training in Chennai
    AWS course in Chennai
    R Programming Training in Chennai
    Angularjs Training in Chennai
    RPA Training in Chennai
    ccna course in Chennai
    Data Science Course in Chennai

    ReplyDelete
  12. UnknownMarch 13, 2019 at 3:15 AM

    Your good knowledge and kindness in playing with all the pieces were very useful. I don’t know what I would have done if I had not encountered such a step like this.


    devops online training

    aws online training

    data science with python online training

    data science online training

    rpa online training

    ReplyDelete
  13. nishaMay 28, 2020 at 9:57 PM

    Excellent Blog. each and every content of this blog is explained very Clearly.

    Data Science Training Course In Chennai | Data Science Training Course In Anna Nagar | Data Science Training Course In OMR | Data Science Training Course In Porur | Data Science Training Course In Tambaram | Data Science Training Course In Velachery

    ReplyDelete
  14. RevathiJuly 21, 2020 at 9:32 PM

    Awesome blog. I enjoyed reading your articles. This is truly a great read for me. I have bookmarked it and I am looking forward to reading new articles. Keep up the good work!


    Android Training in Chennai

    Android Online Training in Chennai

    Android Training in Bangalore

    Android Training in Hyderabad

    Android Training in Coimbatore

    Android Training

    Android Online Training

    ReplyDelete
  15. deviJuly 31, 2020 at 12:36 AM

    I have read your blog and i got a very useful and knowledgeable information from your blog.You have done a great job.It's very nice blog
    Thank you for giving valuable information
    I'm expecting much more from you.
    Data Science Training In Chennai

    Data Science Online Training In Chennai

    Data Science Training In Bangalore

    Data Science Training In Hyderabad

    Data Science Training In Coimbatore

    Data Science Training

    Data Science Online Training

    ReplyDelete
  16. shivaAugust 26, 2020 at 3:50 AM

    Wonderful Article. the Blog is clearly explained every content. Concept of this blog is really awesome.
    Cyber Security Training Course in Chennai | Certification | Cyber Security Online Training Course | Ethical Hacking Training Course in Chennai | Certification | Ethical Hacking Online Training Course |
    CCNA Training Course in Chennai | Certification | CCNA Online Training Course | RPA Robotic Process Automation Training Course in Chennai | Certification | RPA Training Course Chennai | SEO Training in Chennai | Certification | SEO Online Training Course

    ReplyDelete
  17. jeniAugust 30, 2020 at 4:30 AM

    Good Post! Thank you so much for sharing this pretty post, it was so good to read and useful to improve my knowledge as updated one, keep blogging.

    data science training in chennai

    data science training in velachery

    android training in chennai

    android training in velachery

    devops training in chennai

    devops training in velachery

    artificial intelligence training in chennai

    artificial intelligence training in velachery

    ReplyDelete
  18. INFYCLE TECHNOLOGIESNovember 24, 2021 at 10:28 AM

    Pull- up your socks and knot your tie. Gonna have a good salary package job after completing Big-data Hadoop training in Chennai at Infycle. Infylce is completely for Software training and placement by friendly trainees, good atmosphere, 200% practical classes, and more.

    ReplyDelete
  19. AnonymousApril 30, 2022 at 10:30 AM

    Mmorpg Oyunlar
    instagram takipçi satın al
    tiktok jeton hilesi
    Tiktok jeton hilesi
    antalya saç ekimi
    referans kimliği nedir
    instagram takipçi satın al
    METİN2 PVP SERVERLAR
    instagram takipçi satın al

    ReplyDelete
  20. AnonymousMay 17, 2022 at 12:33 PM

    Perde modelleri
    MOBİL ONAY
    Vodafone mobil ödeme bozdurma
    Nft Nasıl Alınır
    ankara evden eve nakliyat
    trafik sigortası
    dedektör
    web site kurma
    aşk kitapları

    ReplyDelete
  21. AnonymousJune 4, 2022 at 10:31 PM

    üsküdar toshiba klima servisi
    çekmeköy lg klima servisi
    beykoz beko klima servisi
    üsküdar beko klima servisi
    pendik lg klima servisi
    pendik alarko carrier klima servisi
    pendik daikin klima servisi
    tuzla toshiba klima servisi
    maltepe mitsubishi klima servisi

    ReplyDelete
  22. başkanstylusAugust 23, 2022 at 8:27 AM

    Takipçi satın alTakipçi satın al

    ReplyDelete

Subscribe to: Post Comments (Atom)