IT Certificaions

Google Cloud Platform

Wednesday, December 22, 2010

DB2 Query::SQL 0973N

Question1::
SQL0973N Not enough storage is available in the "PCKCACHESZ" heap to process the request..


Solution:

1. db2 disconnect DATABASENAME

2. db2 "update db cfg for DATABASENAME using app_ctl_heap_sz 25000"

3. db2 "update db cfg for DATABASENAME using applheapsz 25000"

4. db2 "update db cfg for DATABASENAME using locklist 60000"

5. db2 "update db cfg for DATABASENAME using LOGFILSIZ 10000"



// DATABASENAME is your database name....Please edit these SQL Commands by replacing DATABASENAME with your actual database name


now Go to path
cd /opt/IBM/db2/V8.1/bnd

then run the command as it is.


6. db2 connect to DATABASENAME

7. db2 "bind db2clipk.bnd blocking all grant public clipkg 30"

8. db2 "commit"

Now ........

db2 terminate

db2stop force

db2start

Now you will not find this problem............................

Wednesday, December 15, 2010

Suse Linux Problems........

1. How to make full permission to a file in Suse Linux..........
2. Access denied, can't create a directory................

Solution: First login as a root user in linux and the go the location where you want to create a directory with full permission:::::

chmod u+rwx,o+rwx,g+rwx DIRECTORYNAME/FILENAME

IBM DB2 commands......

  1. How to insert text that contains an apostrophe??
insert into TABLENAME (COLUMN NAME) values('Knowledge''s Power')


Now the output will be like
------------------------
Knowledge's Power

------------------------

2 . How to see tablespaces and containers...........

db2 list tablespaces












-------will give you list of all table spaces.............

db2 list tablespace containers for 2

--------here 2 is the tablespaceID for which you want to see all containers..............

db2inst1@user:~> db2 list tablespace containers for 2

Tablespace Containers for Tablespace 2

Container ID = 0

Name = /home/db2inst1/db2inst1/NODE0000/SQL00039/SQLT0002.0

Type = Path

-------------------------------------------------------------------------------------------------------------