Results 1 to 4 of 4
  1. #1
    Join Date
    Dec 2016
    Posts
    20

    Unanswered: DB2- help for the commands to create a databse & log file in linux

    Hi All,

    please help me to share the commands in Linux for the below activities. I have given the database details for reference.

    1.How do I recreate HR database with 32 KB page size.Previously it was 4 KB page size and creating issue for some queries.(/home/inst1/sqllib/db2dump/HR_RECREATE path)

    2.How to change the existing Log file size to 32 MB also for both XX and YY database.



    Thanks

  2. #2
    Join Date
    Jan 2003
    Posts
    4,310
    Provided Answers: 5
    1) You need to create new tablespaces at 32K, and move your data there
    2) Read about the UPDATE DATABASE CONFIGURATION command

    Andy

  3. #3
    Join Date
    Dec 2016
    Posts
    20
    I am the beginners in DB2

    Please share the commands steps by steps

  4. #4
    Join Date
    Jan 2003
    Posts
    4,310
    Provided Answers: 5
    As a beginner, you need to familiarize yourself with the documentation. I suggest that you find the documentation for the version of DB2 you are using and read through it.

    Andy

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •