I think you've reached 123 XT on the tablespace DSNDB04.ABITEST and you ran out of space in it.
Just alter the Primary and Secundary quantities of the tablespace DSNDB04.ABITEST , reorg it and check the extents again.
Then try to insert the data again.
Have a happy new year!
Pedro Gonçalves.
-----Mensagem original-----
De: SANKARAN Sangeetha (AXA-I) [mailto:db2udbdba-ezmlmshield-x67402712.[Email address protected]
Enviada: quinta-feira, 29 de Dezembro de 2005 15:31
Para: LazyDBA Discussion
Assunto: resource unavailable
Hi all,
INSERT INTO TXZSS1.ABITEST
(SELECT * FROM HHHBDE.MXABI);
Am getting the following error when I try to insert to the table
SQLCODE = -904, ERROR: UNSUCCESSFUL EXECUTION CAUSED BY AN
UNAVAILABLE RESOURCE. REASON 00D70014, TYPE OF RESOURCE 00000220, AND
RESOURCE NAME DB2V.DSNDBC.DSNDB04.ABITEST.I0001.A001
I guess the space is giving the problem
Can anyone suggest me the solution to this problem?
Thanks
Sangeetha
This email originates from AXA Services Limited (reg. no. 446043) which is a service company for AXA UK plc (reg. no. 2937724) and the following companies within the AXA UK plc Group:
AXA Insurance Plc (reg. no. 932111)
AXA Insurance UK Plc (reg. no. 78950)
AXA General Insurance Limited (reg. no. 141885)
All of the above mentioned companies are registered in England and have their registered office at 107 Cheapside, London EC2V 6DU, England.
AXA Insurance UK plc is authorised and regulated by the Financial Services Authority.
This message and any files transmitted with it are confidential and intended solely for the individual or entity to whom they are addressed. If you have received this in error, you should not disseminate or copy this email. Please notify the sender immediately and delete this email from your system.
Please also note that any opinions presented in this email are solely those of the author and do not necessarily represent those of The AXA UK Plc Group.
Email transmission cannot be guaranteed to be secure, or error free as information could be intercepted, corrupted, lost, destroyed, late in arriving or incomplete as a result of the transmission process. The sender therefore does not accept liability for any errors or omissions in the contents of this message which arise as a result of email transmission.
Finally, the recipient should check this email and any attachments for viruses. The AXA UK Plc Group accept no liability for any damage caused by any virus transmitted by this email.
---------------------------------------------------------------------
PLEASE CLICK REPLY-ALL TO SEND A REPLY TO EVERYONE
website: http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
AVISO DE CONFIDENCIALIDADE:
Esta mensagem e ficheiros associados podem conter informação CONFIDENCIAL, ou material privilegiado. A sua reprodução, divulgação, e/ou distribuição não está autorizada.
A GLOBAL não se considera responsável pelas consequências de vírus de computador que possam ter sido transmitidos nesta mensagem.
CONFIDENTIALITY NOTICE:
The information in this email and files transmitted with it may be PRIVILEGED or CONFIDENTIAL. Its copy, transmission, and/or distribution is not authorized.
GLOBAL does not accept liability for the consequences of any computer viruses which may have been transmitted by this email.
DB2 & UDB email list listserv db2-l LazyDBA home page