Search found 4 matches

by garrethdk
Fri Mar 04, 2011 10:33 am
Forum: Zend Core for i5/OS
Topic: zmysql subsystem mysqlERROR 1146 (42S02):
Replies: 5
Views: 9466

Re: zmysql subsystem mysqlERROR 1146 (42S02):

Thanks again for replying Tim , 1. From looking at the database ,one of the tables seems to be MyISAM and the rest InnoDB 2. Could not find any files with .Err or .Log in either the /usr/local/mysql or /usr/local/mysqldata directories 3. See the mysqlcheck results all the tables are messed up bar se...
by garrethdk
Thu Mar 03, 2011 12:32 pm
Forum: Zend Core for i5/OS
Topic: zmysql subsystem mysqlERROR 1146 (42S02):
Replies: 5
Views: 9466

Re: zmysql subsystem mysqlERROR 1146 (42S02):

Hi Tim, Thanks for the response , the user is mysql in both cases and protected_titles does show up on the list Current Opt Subsystem/Job User Type CPU % Function Status ZMYSQL QSYS SBS .0 DEQW ZMYSQLD MYSQL BCI .0 PGM-mysqld SELW and the object owner for the data is Display Attributes Object . . . ...
by garrethdk
Tue Mar 01, 2011 7:09 pm
Forum: Zend Core for i5/OS
Topic: zmysql subsystem mysqlERROR 1146 (42S02):
Replies: 5
Views: 9466

zmysql subsystem mysqlERROR 1146 (42S02):

our iseries machine hosting mysql using zendcore failed to shut down correctly , when i go into mysql i can see the database but get the following Table 'sckb.protected_titles' doesn't exist when i query a table , is there any way of correcting the database ? i have tried bin/mysqlcheck --user=root ...
by garrethdk
Tue Dec 15, 2009 9:57 am
Forum: Zend Core for i5/OS
Topic: job ZC_STR_PRN ZENDADMIN
Replies: 0
Views: 1934

job ZC_STR_PRN ZENDADMIN

When i do a netstat *cnn , i see connections still open tied to a job that is not active , the job ZC_STR_PRN is display in the detail , why do these jobs not clean themselves up ? is there a way to auto remove these ? I can manually do this but i don't think i should have to . any help is appreciat...