aix5208+db2 8.1fix6，通过hba卡连到3584，不使用备份软件，我要直接备到带子上。

我先用mtlib命令去把带子塞进磁带机，测试备份文件到带机没问题，30G的大文件都没问题。
数据库的instance owner直接写带子都可以，但备数据库就出问题了。



db2 backup db edw online to /dev/rmt9 with 4 buffers


SQL2031W  Warning! Please mount the target or source media on device
"/dev/rmt9".
Do you want to continue(c), terminate this device only(d), abort the utility(t) ? (c/d/t) c
SQL2059W  A device full warning was encountered on device "/dev/rmt9".
Do you want to continue(c), terminate this device only(d), abort the utility(t) ? (c/d/t) c
SQL2059W  A device full warning was encountered on device "/dev/rmt9".
Do you want to continue(c), terminate this device only(d), abort the utility(t) ? (c/d/t) t
SQL2001N  The utility was interrupted.  The output data may be incomplete.



我们看看db2的log：


2008-01-23-13.15.35.380387   Instance:dw1   Node:001
PID:578676(db2med.435168.0 1)   TID:1   Appid:none
oper system services  sqlowrite Probe:60

EINVAL from write() does not mean a real disk full condition.
Possible reasons :
1. Invalid parameters to the API.
2. The file size / offset specified is > 2G but the file system
   does not support > 2G.
fileHandle : 0x6  bufferLength: 4194304  offset: -1

2008-01-23-13.15.37.226222   Instance:dw1   Node:001
PID:578676(db2med.435168.0 1)   TID:1   Appid:none
database utilities  sqluMCWriteToDevice Probe:40

Media controller -- End of tape encountered on /dev/rmt9


请各路神仙指点一二。

靠，DB2不支持block size Variable Length!!!!!!!

马上改一下，把rmt9的block size改为4096，就开始动了。

学习啦.

路过BS一下楼主

能去到多大？