By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
454,280 Members | 1,601 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 454,280 IT Pros & Developers. It's quick & easy.

SQL2036N when backing up to CIFS

P: n/a
Hi,

I'm not sure if anyone can help with this issue I have, but I would
appreciate any thoughts.

We are running DB2 8.2, fp11 on windows 2003. The goal is to backup to
an external EMC SAN which uses CIFS. Is this possible?

It was my understanding that backups were file system independent. I
have also successfully backed up onto an NTFS network drive, so the
remote drive issue doesn't appear to be a problem for DB2 either.

This leaves me with the possibility that the backup isn't doable
because we are using different file systems (NTFS to CIFS), that there
is a permissions issue on our particular SAN, or some other factor I
haven' considered.

Any ideas?

Oct 4 '06 #1
Share this Question
Share on Google+
2 Replies


P: n/a
Ian
Victor Alvarez wrote:
Hi,

I'm not sure if anyone can help with this issue I have, but I would
appreciate any thoughts.

We are running DB2 8.2, fp11 on windows 2003. The goal is to backup to
an external EMC SAN which uses CIFS. Is this possible?

It was my understanding that backups were file system independent. I
have also successfully backed up onto an NTFS network drive, so the
remote drive issue doesn't appear to be a problem for DB2 either.

This leaves me with the possibility that the backup isn't doable
because we are using different file systems (NTFS to CIFS), that there
is a permissions issue on our particular SAN, or some other factor I
haven' considered.

Any ideas?
DB2 does support writing to shares (the type of file system is
immaterial).

However, there are some restrictions:

1) You can't backup to a network drive (i.e. H:\, which is mapped
to \\server\share), because the share isn't visible to the DB2
service. You have to use a UNC path, i.e.

backup database X to \\server\share

2) The account that the DB2 service Logs on As must have permission
to access the share.

Oct 4 '06 #2

P: n/a
Thanks Ian, this is what I imagined.

I'll have to speak with the SAN admin.
Ian wrote:
Victor Alvarez wrote:
Hi,

I'm not sure if anyone can help with this issue I have, but I would
appreciate any thoughts.

We are running DB2 8.2, fp11 on windows 2003. The goal is to backup to
an external EMC SAN which uses CIFS. Is this possible?

It was my understanding that backups were file system independent. I
have also successfully backed up onto an NTFS network drive, so the
remote drive issue doesn't appear to be a problem for DB2 either.

This leaves me with the possibility that the backup isn't doable
because we are using different file systems (NTFS to CIFS), that there
is a permissions issue on our particular SAN, or some other factor I
haven' considered.

Any ideas?

DB2 does support writing to shares (the type of file system is
immaterial).

However, there are some restrictions:

1) You can't backup to a network drive (i.e. H:\, which is mapped
to \\server\share), because the share isn't visible to the DB2
service. You have to use a UNC path, i.e.

backup database X to \\server\share

2) The account that the DB2 service Logs on As must have permission
to access the share.
Oct 5 '06 #3

This discussion thread is closed

Replies have been disabled for this discussion.