Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

Bufferpool BP12 must be activated

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
harish_2480

New User


Joined: 07 Jun 2007
Posts: 23
Location: USA

PostPosted: Thu Jun 17, 2010 11:34 pm    Post subject: Bufferpool BP12 must be activated
Reply with quote

Hi,

I am trying to create a table in my test DB2 region and i am getting the below error:
"Bufferpool BP12 must be activated". Please can some one tell me what could be the reason. It means that i doesnot have access? I am using below query:
"CREATE TABLE Qualifier.Table_Name LIKE Qualifier.Wxisting_Table_Name"

Thanks in advance.,
Hari.
Back to top
View user's profile Send private message

Robert Sample

Global Moderator


Joined: 06 Jun 2008
Posts: 7993
Location: Bellevue, IA

PostPosted: Thu Jun 17, 2010 11:55 pm    Post subject:
Reply with quote

You are being told that your DBA needs to activate bufferpool BP12 -- which would have nothing to do with access, I would think. Contact your site support group and work with them to resolve the problem.
Back to top
View user's profile Send private message
harish_2480

New User


Joined: 07 Jun 2007
Posts: 23
Location: USA

PostPosted: Fri Jun 18, 2010 12:28 am    Post subject: Bufferpool BP12 must be activated
Reply with quote

Hi Robert,

Thank you for information and help. I will do that.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts ALTER BUFFERPOOL - Error while changi... gylbharat DB2 4 Mon Oct 22, 2012 4:36 pm
No new posts How to load a table to bufferpool whe... dejunzhu DB2 5 Thu Mar 22, 2012 9:03 am
No new posts SYSLOG Message ID Activated Assembly ... Bill Dennis PL/I & Assembler 9 Tue Jul 21, 2009 1:22 pm
No new posts Will changing BUFFERPOOL help perform... sushanth bobby DB2 2 Fri Jan 23, 2009 7:50 pm
No new posts lu62 channel not activated! kamran Java & MQSeries 3 Wed Mar 26, 2008 12:58 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us