Showing posts from 2010

DB2 Query::SQL 0973N

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


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


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

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+rwxDIRECTORYNAME/FILENAME

IBM DB2 commands......

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..............

Use of Earth Wire in Current in Home

Ground or earth in a mains (AC power) electrical wiring system is a conductor that provides a low impedance path to the earth to prevent hazardous voltages from appearing on equipment (the terms "ground" (North American practice) and "earth" (most other English-speaking countries) are used synonymously here). Normally a grounding conductor does not carry current.Neutral is a circuit conductor (that carries current in normal operation), which is connected to earth (or ground) generally at the service panel with the main disconnecting switch or breaker.In a polyphase or three-wire (single-phase) AC system, the neutral conductor is intended to have similar voltages to each of the other circuit conductors. By this definition, a circuit must have at least three wires for one to serve as a neutral.In the electrical trade, the conductor of a 2-wire circuit that is connected to the supply neutral point and earth ground is also referred to as the "neutral&qu…
----------2 G/3G Spectrum Scam---------

It is a term used telecommunication sector. These are radio waves. It is a spectrum which support 2G technology. High bandwidth is required for this purpose. 2G means second-generation wireless telephone technology. Second generation 2G cellular telecom networks were commercially launched on the GSM standard in Finland in 1991.

G has been superseded by newer technologies such as 2.5G, 2.75G, 3G, and 4G; however, 2G networks are still used in many parts of the world.
Three primary benefits of 2G networks over their predecessors were that phone conversations were digitally encrypted; 2G systems were significantly more efficient on the spectrum allowing for far greater mobile phone penetration levels; and 2G introduced data services for mobile, starting with SMS text messages.

See the new opportunities on our website

Lesson from 3 idiot movie

3 Idiots- Life’s Learning

1. Never try to be successful , pursue excellence
Success is the bye product & the result Excellence always creates Success & it is a process of continual improvement Never run after success Let it happen automatically in life
2. Freedom to Life- Life is beautiful
Don’t die before the actual death Live every moment to the fullest as if today is the last day Life is gifted to humankind to live Live & Live happily towards happiness

3. Passion leads to Excellence
When your hobby becomes your profession , the passion becomes your profession You will be able to lead up to excellence in life Satisfaction, Joy, Pleasure & love will be the outcome of the passion Following your passion for years , you will surely become somebody one day
4. Learning is very simple- Never stop
Be humbleTeachers do fail, Learners never fail Learning is never complicate or difficult Learning is always possible whatever rule you apply
5. Pressure at head
Current education syste…

Banking Jobs


3 Idiots who???

Find out who are the real three India