yinxin
作者yinxin·2015-04-20 18:21
项目经理·某金融机构

portal db2集群无法删除页面

字数 19523阅读 1320评论 0赞 0

环境:

portal 8.0.0.1

RHEL 6.3

DB2 9.7.0.4

单节点集群,

删除页面的时候报错

日志报错如下:

Caused by: com.ibm.icm.da.DBAccessException: DB2 SQL Error: SQLCODE=-286, SQLSTATE=42727, SQLERRMC=4096;DB2INST1, DRIVER=4.12.55Thread 2021751134 : qlSyntaxErrorException: DB2 SQL Error: SQLCODE=-286, SQLSTATE=42727, SQLERRMC=4096;DB2INST1, DRIVER=4.12.55

at com.ibm.db2.jcc.am.hd.a(hd.java:676)

at com.ibm.db2.jcc.am.hd.a(hd.java:60)

at com.ibm.db2.jcc.am.hd.a(hd.java:127)

at com.ibm.db2.jcc.am.mn.c(mn.java:2621)

at com.ibm.db2.jcc.am.mn.d(mn.java:2609)

at com.ibm.db2.jcc.am.mn.b(mn.java:2023)

at com.ibm.db2.jcc.t4.cb.h(cb.java:225)

at com.ibm.db2.jcc.t4.cb.b(cb.java:48)

at com.ibm.db2.jcc.t4.q.b(q.java:38)

at com.ibm.db2.jcc.t4.rb.h(rb.java:114)

at com.ibm.db2.jcc.am.mn.hb(mn.java:2018)

at com.ibm.db2.jcc.am.mn.a(mn.java:3132)

at com.ibm.db2.jcc.am.mn.e(mn.java:1051)

at com.ibm.db2.jcc.am.mn.execute(mn.java:1035)

at com.ibm.ws.rsadapter.jdbc.WSJdbcStatement.pmiExecute(WSJdbcStatement.java:1579)

at com.ibm.ws.rsadapter.jdbc.WSJdbcStatement.execute(WSJdbcStatement.java:722)

at com.ibm.icm.da.portable.common.sql.PStatement.execute(PStatement.java:163)

at com.ibm.icm.da.portable.data.ProcessLinks.createOrCleanupTemporaryTable(ProcessLinks.java:1018)

at com.ibm.icm.da.portable.data.ProcessLinks.buildTemporaryDeleteTable(ProcessLinks.java:1265)

at com.ibm.icm.da.portable.data.ProcessLinks.collectiveBatchRemoveLink(ProcessLinks.java:723)

at com.ibm.icm.da.portable.data.ProcessLinks.processLinks(ProcessLinks.java:1518)

at com.ibm.icm.da.portable.data.DataManager.processLinks(DataManager.java:574)

at com.ibm.icm.ci.data.impl.PathService._executeProcessLinkAction(PathService.java:310)

at com.ibm.icm.ci.data.impl.PathService._processPathList(PathService.java:294)

at com.ibm.icm.ci.data.impl.PathService.removeByParentChildPair(PathService.java:264)

at com.ibm.icm.jcr.NodeImpl.save(NodeImpl.java:2531)

at com.ibm.icm.jcr.NodeImpl.save(NodeImpl.java:2436)

at com.ibm.icm.jcr.WorkspaceImpl.save(WorkspaceImpl.java:2766)

at com.ibm.icm.jcr.WorkspaceImpl.save(WorkspaceImpl.java:2755)

at com.ibm.workplace.wcm.services.transaction.steps.repository.SaveWorkspace.execute(SaveWorkspace.java:106)

at com.ibm.workplace.wcm.services.transaction.CompositeTransactionStep.execute(CompositeTransactionStep.java:143)

at com.ibm.workplace.wcm.services.transaction.steps.repository.RepositoryRemove.execute(RepositoryRemove.java:177)

at com.ibm.workplace.wcm.services.transaction.TxUnitOfWork$1.call(TxUnitOfWork.java:111)

at com.ibm.workplace.wcm.util.transaction.DefaultTransactionManager.doCall(DefaultTransactionManager.java:320)

at com.ibm.workplace.wcm.util.transaction.DefaultTransactionManager.doCall(DefaultTransactionManager.java:230)

at com.ibm.workplace.wcm.util.transaction.DefaultTransactionManager.call(DefaultTransactionManager.java:109)

at com.ibm.workplace.wcm.services.transaction.TxUnitOfWork.run(TxUnitOfWork.java:166)

at com.ibm.workplace.wcm.services.content.ContentServiceImpl$9.run(ContentServiceImpl.java:2252)

at com.ibm.wps.ac.impl.UnrestrictedAccessImpl.run(UnrestrictedAccessImpl.java:84)

at com.ibm.wps.command.ac.ExecuteUnrestrictedCommand.execute(ExecuteUnrestrictedCommand.java:90)

at com.ibm.workplace.wcm.services.repository.PACServiceImpl.runAsPrivileged(PACServiceImpl.java:1962)

at com.ibm.workplace.wcm.services.content.ContentServiceImpl.softDelete(ContentServiceImpl.java:2218)

at com.ibm.workplace.wcm.services.content.ContentServiceImpl.delete(ContentServiceImpl.java:2637)

at com.ibm.workplace.wcm.api.WCM_Workspace.delete_aroundBody66(WCM_Workspace.java:1645)

at com.ibm.workplace.wcm.api.WCM_Workspace.delete(WCM_Workspace.java:1)

at com.ibm.wps.model.content.controller.wcm.ContentModelControllerForPPmiWCM.deletePageInWCM(ContentModelControllerForPPmiWCM.java:1244)

at com.ibm.wps.model.content.controller.wcm.ContentModelControllerForPPmiWCM.access$800(ContentModelControllerForPPmiWCM.java:115)

at com.ibm.wps.model.content.controller.wcm.ContentModelControllerForPPmiWCM$2$1.run(ContentModelControllerForPPmiWCM.java:877)

at com.ibm.wps.ac.impl.UnrestrictedAccessImpl.run(UnrestrictedAccessImpl.java:84)

at com.ibm.wps.command.ac.ExecuteUnrestrictedCommand.execute(ExecuteUnrestrictedCommand.java:90)

at com.ibm.wps.model.content.controller.wcm.ContentModelControllerForPPmiWCM$2.run(ContentModelControllerForPPmiWCM.java:890)

at com.ibm.workplace.wcm.api.WCM_Repository.runWithoutSynchronization_aroundBody20(WCM_Repository.java:447)

at com.ibm.workplace.wcm.api.WCM_Repository$AjcClosure21.run(WCM_Repository.java:1)

at com.ibm.workplace.wcm.api.WCMAPIWorkspaceAspect.ajc$around$com_ibm_workplace_wcm_api_WCMAPIWorkspaceAspect$1$77189ab8proceed(WCMAPIWorkspaceAspect.aj)

at com.ibm.workplace.wcm.api.WCMAPIWorkspaceAspect.ajc$around$com_ibm_workplace_wcm_api_WCMAPIWorkspaceAspect$1$77189ab8(WCMAPIWorkspaceAspect.aj:176)

at com.ibm.workplace.wcm.api.WCM_Repository.runWithoutSynchronization(WCM_Repository.java:1)

at com.ibm.wps.model.content.controller.wcm.ContentModelControllerForPPmiWCM.internalCommit(ContentModelControllerForPPmiWCM.java:854)

at com.ibm.wps.model.content.controller.wcm.ContentModelControllerForPPmiWCM.access$000(ContentModelControllerForPPmiWCM.java:115)

at com.ibm.wps.model.content.controller.wcm.ContentModelControllerForPPmiWCM$1.call(ContentModelControllerForPPmiWCM.java:787)

at com.ibm.wps.services.wcm.SynchronizationEventControlServiceImpl.executeWithoutPortalUpdates(SynchronizationEventControlServiceImpl.java:69)

at com.ibm.wps.model.content.controller.wcm.ContentModelControllerForPPmiWCM.commit(ContentModelControllerForPPmiWCM.java:782)

at sun.reflect.GeneratedMethodAccessor365.invoke(Unknown Source)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:37)

at java.lang.reflect.Method.invoke(Method.java:611)

at com.ibm.wps.util.ContextWrapper$Handler.invoke(ContextWrapper.java:115)

at $Proxy252.commit(Unknown Source)

at com.ibm.workplace.wcm.templating.engine.WCMContentModelController.commit(WCMContentModelController.java:198)

at sun.reflect.GeneratedMethodAccessor365.invoke(Unknown Source)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:37)

at java.lang.reflect.Method.invoke(Method.java:611)

at com.ibm.wps.util.ContextWrapper$Handler.invoke(ContextWrapper.java:115)

at $Proxy251.commit(Unknown Source)

at com.ibm.portal.model.controller.ContentModelControllerAdapter.commit(ContentModelControllerAdapter.java:376)

at com.ibm.wps.lc.templating.controller.ContentModelControllerForCI.commit(ContentModelControllerForCI.java:90)

at sun.reflect.GeneratedMethodAccessor365.invoke(Unknown Source)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:37)

at java.lang.reflect.Method.invoke(Method.java:611)

at com.ibm.wps.util.ContextWrapper$Handler.invoke(ContextWrapper.java:115)

at $Proxy252.commit(Unknown Source)

at com.ibm.portal.model.controller.ContentModelControllerAdapter.commit(ContentModelControllerAdapter.java:376)

at com.ibm.wps.model.content.controller.ContentModelControllerForTemplating.commit(ContentModelControllerForTemplating.java:264)

at sun.reflect.GeneratedMethodAccessor365.invoke(Unknown Source)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:37)

at java.lang.reflect.Method.invoke(Method.java:611)

at com.ibm.wps.util.ContextWrapper$Handler.invoke(ContextWrapper.java:115)

at $Proxy251.commit(Unknown Source)

at com.ibm.wps.portlets.managepages.utils.PageCommand.deletePage(PageCommand.java:393)

at com.ibm.wps.portlets.managepages.utils.TableModelUtils.deletePage(TableModelUtils.java:493)

at com.ibm.wps.portlets.managepages.PageTableCommandListener.commandPerformed(PageTableCommandListener.java:108)

at com.ibm.psw.wcl.core.CommandHandler.handleCommand(CommandHandler.java:74)

at com.ibm.psw.wcl.core.markup.WHyperlink$EHyperlinkCallbackWrapper.handleTrigger(WHyperlink.java:482)

at com.ibm.psw.wcl.core.trigger.Trigger.process(Trigger.java:304)

at com.ibm.psw.wcl.core.trigger.TriggerManager.processTrigger(TriggerManager.java:781)

at com.ibm.psw.wcl.portlet.WclPortletTriggerManager.handleRequest(WclPortletTriggerManager.java:260)

at com.ibm.psw.wcl.portlet.WclPortletFacade.handleRequest(WclPortletFacade.java:497)

at com.ibm.psw.wcl.portlet.WclPortletFacade.handleRequest(WclPortletFacade.java:478)

at com.ibm.wps.portlets.managepages.PageManager.actionPerformed(PageManager.java:240)

at com.ibm.wps.pe.pc.legacy.SPIPortletInterceptorImpl.handleEvents(SPIPortletInterceptorImpl.java:337)

at com.ibm.wps.pe.pc.legacy.invoker.impl.PortletDelegateImpl._dispatch(PortletDelegateImpl.java:385)

at com.ibm.wps.pe.pc.legacy.invoker.impl.PortletDelegateImpl.access$200(PortletDelegateImpl.java:70)

at com.ibm.wps.pe.pc.legacy.invoker.impl.PortletDelegateImpl$Context.callPortlet(PortletDelegateImpl.java:553)

at com.ibm.wps.pe.pc.legacy.cmpf.impl.PortletFilterChainImpl.doFilter(PortletFilterChainImpl.java:133)

at com.ibm.wps.pe.pc.legacy.services.PortletFilterServiceImpl.doFilter(PortletFilterServiceImpl.java:368)

at com.ibm.wps.pe.pc.legacy.services.PortletFilter.doFilter(PortletFilter.java:42)

at com.ibm.wps.pe.pc.legacy.invoker.impl.PortletDelegateImpl.dispatch(PortletDelegateImpl.java:144)

at org.apache.jetspeed.portlet.Portlet.doGet(Portlet.java:499)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:575)

at com.ibm.wps.pe.pc.legacy.cache.CacheablePortlet.service(CacheablePortlet.java:120)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:668)

at org.apache.jetspeed.portlet.Portlet.service(Portlet.java:493)

at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:1224)

at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:774)

at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:456)

at com.ibm.ws.webcontainer.servlet.ServletWrapperImpl.handleRequest(ServletWrapperImpl.java:178)

at com.ibm.ws.webcontainer.filter.WebAppFilterManager.invokeFilters(WebAppFilterManager.java:1032)

at com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.dispatch(WebAppRequestDispatcher.java:1384)

at com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.include(WebAppRequestDispatcher.java:548)

at com.ibm.wps.pe.pc.legacy.invoker.impl.PortletInvokerImpl.callMethod(PortletInvokerImpl.java:370)

at com.ibm.wps.pe.pc.legacy.invoker.impl.PortletInvokerImpl.action(PortletInvokerImpl.java:78)

at com.ibm.wps.pe.pc.legacy.PortletContainerImpl.callPortletMethod(PortletContainerImpl.java:1164)

at com.ibm.wps.pe.pc.legacy.EventEnvironmentImpl.includePortlet(EventEnvironmentImpl.java:171)

at com.ibm.wps.pe.pc.legacy.event.ActionEventImpl.prepare(ActionEventImpl.java:155)

at com.ibm.wps.pe.pc.legacy.event.EventQueueManager.processEventLoop(EventQueueManager.java:88)

at com.ibm.wps.pe.pc.legacy.PortletContainerImpl.performEvents(PortletContainerImpl.java:220)

at com.ibm.wps.pe.pc.PortletContainerImpl.performEvents(PortletContainerImpl.java:285)

at com.ibm.wps.engine.phases.WPActionPhase.processPortlets(WPActionPhase.java:3662)

at com.ibm.wps.engine.phases.WPActionPhase.execute(WPActionPhase.java:1004)

at com.ibm.wps.state.phases.AbstractActionPhase.next(AbstractActionPhase.java:146)

at com.ibm.wps.engine.Servlet.callPortal(Servlet.java:305)

at com.ibm.wps.engine.Servlet.doGet(Servlet.java:686)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:575)

at com.ibm.wps.engine.Servlet.doFilter(Servlet.java:411)

at com.ibm.wps.resolver.servlet.ContentHandlerCleanup.doFilter(ContentHandlerCleanup.java:780)

at com.ibm.wps.resolver.servlet.AbstractFilter.doFilter(AbstractFilter.java:96)

at com.ibm.wps.engine.Servlet.service(Servlet.java:1374)

at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:1224)

at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:774)

at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:456)

at com.ibm.ws.webcontainer.servlet.ServletWrapperImpl.handleRequest(ServletWrapperImpl.java:178)

at com.ibm.ws.webcontainer.filter.WebAppFilterChain.invokeTarget(WebAppFilterChain.java:136)

at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:97)

at com.ibm.wps.engine.ExtensionFilter$ExtendedFilterChain.doFilter(ExtensionFilter.java:110)

at com.ibm.wps.engine.ExtensionFilter.doFilter(ExtensionFilter.java:197)

at com.ibm.ws.webcontainer.filter.FilterInstanceWrapper.doFilter(FilterInstanceWrapper.java:195)

at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:91)

at com.ibm.wps.engine.SupportedLocalesFilter.doFilter(SupportedLocalesFilter.java:113)

at com.ibm.ws.webcontainer.filter.FilterInstanceWrapper.doFilter(FilterInstanceWrapper.java:195)

at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:91)

at com.ibm.wps.engine.ExtendedLocaleFilter.doFilter(ExtendedLocaleFilter.java:113)

at com.ibm.ws.webcontainer.filter.FilterInstanceWrapper.doFilter(FilterInstanceWrapper.java:195)

at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:91)

at com.ibm.wps.resolver.friendly.servlet.FriendlySelectionFilter.doFilter(FriendlySelectionFilter.java:191)

at com.ibm.ws.webcontainer.filter.FilterInstanceWrapper.doFilter(FilterInstanceWrapper.java:195)

at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:91)

at com.ibm.wps.project.filter.ProjectIdFilter.doFilterWithoutProjectID(ProjectIdFilter.java:405)

at com.ibm.wps.project.filter.ProjectIdFilter.doFilter(ProjectIdFilter.java:319)

at com.ibm.ws.webcontainer.filter.FilterInstanceWrapper.doFilter(FilterInstanceWrapper.java:195)

at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:91)

at com.ibm.wps.services.preview.PreviewFilterImpl.doFilter(PreviewFilterImpl.java:351)

at com.ibm.ws.webcontainer.filter.FilterInstanceWrapper.doFilter(FilterInstanceWrapper.java:195)

at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:91)

at com.ibm.wps.services.preview.PreviewFilterImpl.doFilter(PreviewFilterImpl.java:351)

at com.ibm.ws.webcontainer.filter.FilterInstanceWrapper.doFilter(FilterInstanceWrapper.java:195)

at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:91)

at com.ibm.wps.mappingurl.impl.URLAnalyzer.doFilter(URLAnalyzer.java:443)

at com.ibm.ws.webcontainer.filter.FilterInstanceWrapper.doFilter(FilterInstanceWrapper.java:195)

at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:91)

at com.ibm.wps.engine.VirtualPortalFilter.doFilter(VirtualPortalFilter.java:88)

at com.ibm.ws.webcontainer.filter.FilterInstanceWrapper.doFilter(FilterInstanceWrapper.java:195)

at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:91)

at com.ibm.wps.resolver.servlet.ContentHandlerGzip.internalDoFilter(ContentHandlerGzip.java:704)

at com.ibm.wps.resolver.servlet.ContentHandlerGzip.doFilter(ContentHandlerGzip.java:451)

at com.ibm.wps.resolver.servlet.AbstractFilter.doFilter(AbstractFilter.java:96)

at com.ibm.ws.webcontainer.filter.FilterInstanceWrapper.doFilter(FilterInstanceWrapper.java:195)

at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:91)

at com.ibm.wps.state.filter.StateCleanup.doFilter(StateCleanup.java:103)

at com.ibm.ws.webcontainer.filter.FilterInstanceWrapper.doFilter(FilterInstanceWrapper.java:195)

at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:91)

at com.ibm.ws.webcontainer.filter.WebAppFilterManager.doFilter(WebAppFilterManager.java:928)

at com.ibm.ws.webcontainer.filter.WebAppFilterManager.invokeFilters(WebAppFilterManager.java:1025)

at com.ibm.ws.webcontainer.webapp.WebApp.handleRequest(WebApp.java:3751)

at com.ibm.ws.webcontainer.webapp.WebGroup.handleRequest(WebGroup.java:304)

at com.ibm.ws.webcontainer.WebContainer.handleRequest(WebContainer.java:962)

at com.ibm.ws.webcontainer.WSWebContainer.handleRequest(WSWebContainer.java:1662)

at com.ibm.ws.webcontainer.channel.WCChannelLink.ready(WCChannelLink.java:195)

at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleDiscrimination(HttpInboundLink.java:452)

at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleNewRequest(HttpInboundLink.java:511)

at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.processRequest(HttpInboundLink.java:305)

at com.ibm.ws.http.channel.inbound.impl.HttpICLReadCallback.complete(HttpICLReadCallback.java:83)

at com.ibm.ws.tcp.channel.impl.AioReadCompletionListener.futureCompleted(AioReadCompletionListener.java:165)

at com.ibm.io.async.AbstractAsyncFuture.invokeCallback(AbstractAsyncFuture.java:217)

at com.ibm.io.async.AsyncChannelFuture.fireCompletionActions(AsyncChannelFuture.java:161)

at com.ibm.io.async.AsyncFuture.completed(AsyncFuture.java:138)

at com.ibm.io.async.ResultHandler.complete(ResultHandler.java:204)

at com.ibm.io.async.ResultHandler.runEventProcessingLoop(ResultHandler.java:775)

at com.ibm.io.async.ResultHandler$2.run(ResultHandler.java:905)

at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1690)

at com.ibm.icm.da.portable.common.LSUtil.handleSQLException(LSUtil.java:160)

at com.ibm.icm.da.portable.data.ProcessLinks.collectiveBatchRemoveLink(ProcessLinks.java:757)

at com.ibm.icm.da.portable.data.ProcessLinks.processLinks(ProcessLinks.java:1518)

at com.ibm.icm.da.portable.data.DataManager.processLinks(DataManager.java:574)

at com.ibm.icm.ci.data.impl.PathService._executeProcessLinkAction(PathService.java:310)

... 174 more

Caused by: com.ibm.db2.jcc.am.SqlSyntaxErrorException: DB2 SQL Error: SQLCODE=-286, SQLSTATE=42727, SQLERRMC=4096;DB2INST1, DRIVER=4.12.55

at com.ibm.db2.jcc.am.hd.a(hd.java:676)

at com.ibm.db2.jcc.am.hd.a(hd.java:60)

at com.ibm.db2.jcc.am.hd.a(hd.java:127)

at com.ibm.db2.jcc.am.mn.c(mn.java:2621)

at com.ibm.db2.jcc.am.mn.d(mn.java:2609)

at com.ibm.db2.jcc.am.mn.b(mn.java:2023)

at com.ibm.db2.jcc.t4.cb.h(cb.java:225)

at com.ibm.db2.jcc.t4.cb.b(cb.java:48)

at com.ibm.db2.jcc.t4.q.b(q.java:38)

at com.ibm.db2.jcc.t4.rb.h(rb.java:114)

at com.ibm.db2.jcc.am.mn.hb(mn.java:2018)

at com.ibm.db2.jcc.am.mn.a(mn.java:3132)

at com.ibm.db2.jcc.am.mn.e(mn.java:1051)

at com.ibm.db2.jcc.am.mn.execute(mn.java:1035)

at com.ibm.ws.rsadapter.jdbc.WSJdbcStatement.pmiExecute(WSJdbcStatement.java:1579)

at com.ibm.ws.rsadapter.jdbc.WSJdbcStatement.execute(WSJdbcStatement.java:722)

at com.ibm.icm.da.portable.common.sql.PStatement.execute(PStatement.java:163)

at com.ibm.icm.da.portable.data.ProcessLinks.createOrCleanupTemporaryTable(ProcessLinks.java:1018)

at com.ibm.icm.da.portable.data.ProcessLinks.buildTemporaryDeleteTable(ProcessLinks.java:1265)

at com.ibm.icm.da.portable.data.ProcessLinks.collectiveBatchRemoveLink(ProcessLinks.java:723)

... 177 more

[13-10-30 10:55:22:846 CST] 00000044 servlet       I com.ibm.ws.webcontainer.servlet.ServletWrapper init SRVE0242I: [PA_Portlet_Manager] [/wps/PA_Portlet_Manager] [My Portlets]: 初始化成功。

[13-10-30 10:55:29:434 CST] 0000004f servlet       I com.ibm.ws.webcontainer.servlet.ServletWrapper init SRVE0242I: [PA_Portlet_Manager] [/wps/PA_Portlet_Manager] [/WEB-INF/jsp/html/portletList.jsp]: 初始化成功。

具体操作:

[db2inst1@portal01 ~]$ db2 CONNECT TO jcrdb USER db2inst1 USING wwwwww;

   Database Connection Information

 Database server        = DB2/LINUXX8664 9.7.4

 SQL authorization ID   = DB2INST1

 Local database alias   = JCRDB

[db2inst1@portal01 ~]$ db2 "CREATE USER TEMPORARY TABLESPACE ICMLSUSRTSPACE4 PAGESIZE 4 K MANAGED BY SYSTEM USING ('icmlsusrtspace4') BUFFERPOOL ICMLSVOLATILEBP4"

DB20000I  The SQL command completed successfully.

如果觉得我的文章对您有用,请点赞。您的支持将鼓励我继续创作!

0

添加新评论0 条评论

Ctrl+Enter 发表

作者其他文章

相关文章

相关问题

相关资料

X社区推广