Put an active, wide Terminator on both ends of the cable. The one I picked out with the glowing LED has "Termination Power" and thus is "Active" or there would be no power to make the LED glow. No reason to invoke, "Night and Fog" in this (Nacht und Nebel).
Active termination has nothing to do with term power. Active termination means it is using a chip internally to keep the bus signal levels closer to exact. unlike passive termination which is just resistors that pull high,low etc.The led versions are handy to be sure you have power.
I have found some LVD/SE adapters will not work on the csppc, and some seem ok. Ultra wide SE adapters always work in my experience. Plain scsi 3 terminators may or may not work. i recommend sticking with ones labeled for SE ultrawide use.
Term power is usually supplied by the controller or a device on the chain. a terminator cannot supply term power. term power can be supplied anywhere on the chain.
I have to agree with other people's post. using narrow devices on the scsi chain will slow it. Its best to use all wide devices.
When using narrow devices on the end of the UW scsi chain,a "high byte" terminator(or adapter) should be used as to keep all lines properly terminated.
Plextor makes a line of scsi cdrom drives that are 68Pin ultra interfaced,these can be found used still. many were used in IBM servers.
I have used Acard 7720UW adapters with quality cf adapters and sandisk fast cf cards and managed to attain 32MB/s transfer rates on the csppc scsi. it really does scream as far as things in the amiga world go

mech