Author Topic: ArcDBP_SegSQL:Unable to exec direct sql db  (Read 264 times)

SV

  • Jr. Member
  • **
  • Posts: 34
    • View Profile
ArcDBP_SegSQL:Unable to exec direct sql db
« on: December 06, 2019, 11:00:57 AM »
AIX CMOD stooped. Not starting. Trace shows these db errors. SQL ERROR code is not showing up in the log


39518276:258 12/06/2019 10:39:25:195243 ERROR arsseg.c(1132)ArcDBP_SegSQL:Unable to exec direct sql db hstmt=65538 db sql str=CREATE TABLE ccsuser.SL1685 ( time_stamp INTEGER NOT NULL, userid VARCHAR(128) NOT NULL, severity CHAR(1) NOT NULL, msg_num SMALLINT NOT NULL, msg_text VARCHAR(2000) NOT NULL, appl_id CHAR(1) NOT NULL, log_id INTEGER NOT NULL, account VARCHAR(60) NOT NULL, doc_name VARCHAR(11) NOT NULL, doc_off INTEGER NOT NULL, doc_len INTEGER NOT NULL, comp_off INTEGER NOT NULL, comp_len INTEGER NOT NULL, annot CHAR(1) FOR BIT DATA NOT NULL, comp_type CHAR(1) FOR BIT DATA NOT NULL, resource INTEGER NOT NULL, pri_nid SMALLINT NOT NULL, sec_nid SMALLINT NOT NULL , time_stamp_dt TIMESTAMP NOT NULL) IN USERSPACE1 sql=CREATE TABLE ccsuser.SL1685 ( time_stamp INTEGER NOT NULL, userid VARCHAR(128) NOT NULL, severity CHAR(1) NOT NULL, msg_num SMALLINT NOT NULL, msg_text VARCHAR(2000) NOT NULL, appl_id CHAR(1) NOT NULL, log_id INTEGER NOT NULL, account VARCHAR(60) NOT NULL, doc_name VARCHAR(11) NOT NULL, doc_off INTEGER NOT NULL, doc_len INTEGER NOT NULL, comp_off INTEGER NOT NULL, comp_len INTEGER NOT NULL, annot CHAR(1) FOR BIT DATA NOT NULL, comp_type CHAR(1) FOR BIT DATA NOT NULL, resource INTEGER NOT NULL, pri_nid SMALLINT NOT NULL, sec_nid SMALLINT NOT NULL , time_stamp_dt TIMESTAMP NOT NULL) IN USERSPACE1 db sql rc=-1,SQL_ERROR


I executed this sql in the above error and got this error
SQL0289N  Unable to allocate new pages in table space "USERSPACE1". 
SQLSTATE=57011
« Last Edit: December 06, 2019, 11:16:07 AM by SV »
Intrests: #zOS #AIX #Linux #DB2, #TSM, #Install #Migrations #Conversion #Educate #Repair #Upgrade #Migrate #Enhance #Optimize, #ODWEK #DR #ContentNavigator; #CLOUD

jsquizz

  • Global Moderator
  • Sr. Member
  • *****
  • Posts: 370
    • View Profile
Re: ArcDBP_SegSQL:Unable to exec direct sql db
« Reply #1 on: December 06, 2019, 01:41:56 PM »
Anything in db2diag?
#AIX #CMOD #DB2 #TSM #XENOS #AFP2PDF #MIGRATION #TROUBLESHOOT

Justin Derrick

  • IBM Content Manager OnDemand Consultant
  • Administrator
  • Hero Member
  • *****
  • Posts: 1777
  • CMOD Guru for hire...
    • View Profile
    • Tenacious Consulting
Re: ArcDBP_SegSQL:Unable to exec direct sql db
« Reply #2 on: December 06, 2019, 01:58:06 PM »
The database filesystem or tablespace container is full.  Contact the System Admins and/or database admins.

-JD.
#Install, #Educate, #Repair, #Upgrade, #Migrate, #Enhance, #Optimize.

IBM CMOD Professional Services: http://TenaciousConsulting.com
Call:  +1-866-533-7742  or  eMail:  jd@justinderrick.com
IBM CMOD Wiki:  https://CMOD.wiki/

Interests: #AIX #Linux #Multiplatforms #DB2 #TSM #SA #Performance #Security #Audits #Customizing #Availability #HA #DR #Training